Removal of the aforementioned imperfections related to current versions of the application required not only extension of its functionality but also changing parts of applied technologies. Additionally, information technologies that have been used by us so far, narrowed down previous solutions solely to Windows platform. In the process of mapping and visualization also differentiation for the case of occurrence of relations defined on the basis of elementary complex key were not taken into consideration in the previous solution. This structure may contain only foreign keys or can be equipped with additional columns describing relation. In case of intermediate tables we can deal with two different situations. Yet another imperfection of resulting and offered solutions was lack of differentiation between intermediate tables eliminating relations characterized by numerical strength many to many and relational structures storing directly requested data, both in the process of mapping and later visualization. However, this way of visualization was subject to certain limitations, present in the tool that wasapplied. On the other hand, available and at the same time required results visualization, is a consequence of using client software offered by the producer of Neo4j, which is stared via web browser. However, querying graph database which was formed this way, managed by the Neo4j engine, will require the command of Cypher language. Previous solutions, characterized by different character of universality, were based on the same premises, namely each table is to be mapped in the form of central unit and relations occurring in this unit are to represent edges. For the moment, the authors were focusing on - both in this as well as in previous publications - those relational structures where foreign keys were defined overtly, which automatically relates to the occurrence of relations of referential integrity. This feature is undoubtedly strengthened by visualization of queries results, which seems to be a more effective way of medium than tabular form. The mapping of relational structures alone in graph database, which is equipped with proper language of queries, allows us to recognize them in a comfortable way and thus can be very useful approach within this scope. However, their recognition can be a nuisance by virtue of their complexity, multitude of tables and lack of or incomplete technical documentation. At the same time the application ensures results visualization in richer form than client program with the engine Neo4j that is available and offered.Īs it was signaled in previous publications the extension of application cooperating with relational databases as a general rule is not possible without command of their structures. Another improvement of the presented application is new user interface, which eliminates the necessity for user of having Cypher language skill in order to query graph database. The problem that the authors have failed to take into consideration so far, and that is presented now, is the case of intermediate tables occurrence, which are used in great measure to eliminate many to many relations on the level of relational bases as well as to eliminate relations based on complex keys. The effects of queries realization were presented with graph form, which resulted from the potential of the client program of the platform called Neo4j used for the needs of this research. The main aim of the aforementioned actions was to utilize the possibilities of graph database of programming languages paying special attention to searching for connections between tables when both their number and relations is very high and documentation is incomplete or unavailable. Various mechanisms of mapping relational structures in graph database Neo4j presented in previous publications describing both detailed and more universal solutions, did not take into account the whole complexity of relational databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |