Most IT systems rely on dedicated databases, and most of these databases are relational. The advantages of such databases are well known and widely reported in literature. Unfortunately, attempts to identify the topology of links in the relational model produced by iterative development or administrative enhancements are often hampered by the large number of tables that make up the database and the lack of comprehensive technical documentation. Analysis of the model by someone other than its designer requires substantial effort. The aim of the presented work is therefore to develop an application for effective presentation of the database structure in the form of a directed graph. The main assumption was that a graph-oriented database environment would be used. This paper presents the RELATIONS-Graph application developed by the authors. This application automatically generates a directed graph which presents links between tables and attributes which constitute a relational database. The RELATIONS-Graph application can also scan the generated graph in order to discover links between selected tables and columns. This solution has been applied to SQL Server 2014 SP1 DBMS using the Microsoft .NET technology and the Neo4j graph database, also by .NET API. The RELATIONS-Graph application was developed in C#, an object-oriented programming language.
The study concerns the possibility of using the Neo4j database as a graph analysistool. The analysis was presented on the example of the railway connection network assessmentwhen designing a new version of the railway infrastructure in the Silesian Voivodeship. Theauthors present the concepts of a laboratory environment built on the basis of the Neo4jdatabase, and an application that allows obtaining data and modifying the railway infrastructuremodel. Thanks to this, it is possible to simulate many variants of the designed model and itsevaluation using the proposed measurement indicators. The study presents methods and tools ofanalysis that can be successfully used to assess the topology of a graph in many different researchareas, such as analysis of management systems, computer networks or biological systems.
JavaScript jest wyłączony w Twojej przeglądarce internetowej. Włącz go, a następnie odśwież stronę, aby móc w pełni z niej korzystać.