ORIGINAL PAPER
Mapping of relational structures in graph database Neo4j
More details
Hide details
1
Poznań University of Life Sciences, Institute of Biosystems Engineering, Poznań, Poland
Journal of Research and Applications in Agricultural Engineering 2018;63(4):121-124
KEYWORDS
ABSTRACT
Extension of functionality of most applications including the ones supporting agriculture, as a general rule requires an indepth knowledge of relational structures creating databases, which can be sometimes difficult to achieve. It can result from the lack of complete technical documentation as well as relatively huge complexity of relational structures. The given publication is a continuation of the author’s actions, aimed at creating a moderately universal application allowing to reproduce the existing relational structures created with the use of different relational database management systems (RDBMS), namely SQL Server, MySQL or Oracle into graph form on the level of Neo4j graph database. This form makes it possible to thoroughly recognize complex relational structures with the use of queries prepared in Cypher language in native client, which is made available from the level of the created application. During the construction process of the presented tool, technologies such as ADO.NET, graph database Neo4j together with available programming interface as well proper tables containing metadata were utilized.
REFERENCES (27)
1.
Celko J., Morgan Kaufman „Joe Celko’s Complete Guide to NoSQL” 2013. ISBN: 978-0-12-407220-6.
2.
Dewson R., Apress „Beginning SQL Server for Developers, 4th Edition” 2014. ISBN: 978-1-484202-81-4.
3.
Ellis G., Packt Publishing „Getting Started with SQL Server 2014 Administration” 2014. ISBN: 978-1-782-17241-3.
4.
Fowler A., Wiley „NoSQL For Dummies” 2015. ISBN: 978- 1-118-90574-6.
5.
Goel A., Packt Publishing „Neo4j Cookbook” 2015. ISBN: 978-1-78328-725-3.
6.
Gupta S., Packt Publishing „Neo4j Essentials” 2015. ISBN: 978-1-78355-517-8.
7.
Idziaszek P., Mueller W., Rudowicz-Nawrocka J., Gruszczyński M., Kujawa S., Górna K., Balcerzak K.: Visualisation of Relational Database Structure by Graph Database. CMST, 2016, Vol. 22 (4), 217-224.
8.
Johnson E., Jones J., Addison-Wesley „A Developer's Guide to Data Modeling for SQL Server” 2008. ISBN: 978-0-321- 49764-2.
9.
Jordan G., Apress „Practical Neo4j” 2015. ISBN: 978-1- 484200-23-0.
10.
Kreigel A., Wrox „Discovering SQL” 2011. ISBN: 978-1- 4571-0657-6.
11.
Lal M., Packt Publishing „Neo4j Graph Data Modeling” 2015. ISBN: 978-1-78439-730-2.
12.
Masood-Al.-Faroog B.A., Packt Publishing „SQL Server 2014 Development Essentials” 2014. ISBN: 978-1-78217- 255-0.
13.
Naboulsi Z., Ford S., Microsoft Press „Coding Faster: Getting More Productive with Microsoft Visual Studio” 2011. ISBN: 978-0-73564-992-7.
14.
Oppel A., McGraw-Hill „Data Modeling” 2009. ISBN: 978- 0-07-162398-8.
15.
Panazarino O., Packt Publishing „Learning Cypher” 2014. ISBN: 978-1-78328-775-8.
16.
Powell J., Chandos Publishing „A Librarian's Guide to Graphs, Data and the Semantic Web” 2015. ISBN: 978-1- 78063-434-0.
17.
Raj S., Packt Publishing „Neo4j High Performance” 2015. ISBN: 978-1-78355-516-1.
18.
Redmon E., Wilson J.R., O’Reilly Media „Seven Databases in Seven Weeks” 2012. ISBN: 978-1-934356-92-0.
19.
Robinson I., Webber J., Eifrem E., O’Reilly Media „Graph Databases” 2013. ISBN:978-1-449-35626-2.
20.
Robinson I., Webber J., Eifrem E., O’Reilly Media „Graph Databases Second Edition” 2015. ISBN:978-1-491-93200-1.
21.
Sadalage P.J., Fowler M., Pearson Education „NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence” 2013. ISBN:978-0321826626.
22.
Schmalz M., O’Reilly Media „C# Database Basics” 2012. ISBN: 978-1-4493-0998-5.
23.
Sideris Courseware Corp. „Data Modeling: Logical Database Design” 2011. ISBN: 978-1-936930-19-7.
24.
Tiwari S., Wrox „Professional NoSQL” 2011. ISBN: 978-1- 4571-0685-9.
25.
Vaish G., Packt Publishing „Getting Started with NoSQL” 2013. ISBN: 978-1-84969-498-8.
26.
Van Bruggen R., Packt Publishing „Learning Neo4j” 2014. ISBN: 978-1-84951-716-4.
27.
Vucotic A., Watt N., Abedrabbo T., Fox D., Partner J., Manning „Neo4j in Action” 2014. ISBN: 978-1-61729-076-3.