Mapping of relational structures in graph database NEO4J

Abstract

Extension of functionality of most applications including the ones supporting agriculture, as a general rule requires an in-depth 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.

Authors and Affiliations

Wojciech Mueller, Przemysław Idziaszek, Sebastian Kujawa, Mateusz Łukomski

Keywords

Related Articles

The mineral elements content in hair of cows from conventional and organic farms

The objective of this study was to determine the effect of different production systems on contents of 29 major and trace elements in cow’s hair. The experimental material consisted of 30 cows of Polish Holstein-Friesian...

The identification and quantification of factors determining soil compaction caused by single agricultural tyres on a field

In field research, the influence of factors determining soil compaction in an arable layer caused by agricultural tyres during the first pass was determined. The factors were the following: a normal load of tyres resulti...

Occurrence of mycotoxins in cereal grains from organic farming after a long storage time

Mycotoxin contamination of food and feed is a big problem, also with regard to cereal products from organic farming. For that reason screening of mycotoxins occurrence in cereal grains from organic farming after prolonge...

Technical and economic evaluation of a heating system based on air-to-water heat pumps with photovoltaic – micro-installation within the prosument program

For an exemplary single-family residential building, final energy consumption for heating and domestic hot water preparation was calculated using an air / water heat pump, consumption of electricity for household purpose...

Fertilizer value and energy value of multi-component digestate pulp and the possibility of its aggregation

The aim of the research was to indicate the possibility of using digestate which was obtained in the process of biogas production and the analysis of the effects of the aggregation process using rolling. The characterist...

Download PDF file
  • EP ID EP515012
  • DOI -
  • Views 76
  • Downloads 0

How To Cite

Wojciech Mueller, Przemysław Idziaszek, Sebastian Kujawa, Mateusz Łukomski (2018). Mapping of relational structures in graph database NEO4J. Journal of Research and Applications in Agricultural Engineering (ISSN 1642-686X), 63(4), 121-125. https://europub.co.uk/articles/-A-515012