baner - AGH
baner - BG
C   Z   A   S   O   P   I   S   M   A        E   L   E   K   T   R   O   N   I   C   Z   N   E        A   G   H

Graph representation of geological stratum.

Przemysław Lisowski

Vol. 42, 1 (2016), s. 92-93

Full text: pdfPDF


Geology, geophysics and environmental protection sciences provide large amounts of data. These data can be stored in various structures. Most of them are stored in files. It is possible to store these data in databases. One example of databases for earth sciences is a Geokarpat database (Kotlarczyk et al. 1997). This database was developed over many years (Piórkowski & Gajda 2009). Other geological databases are, for example, database MIDAS (MIDAS 2015) and central database of the geological data (CBDG 2015). Solutions listed above are based on the relational data model. This model is not perfect for data analysis, as there are a lot of complicated relationships between the entities (Dominguez-Sal et al. 2010). A typical use of SQL in this case requires the creation of multiple joins and a large amount of calculations. Graph data model is gaining popularity because it allows representation similar to the natural network model of relationships between data (Horzyk 2013). Applications of this model within the earth sciences are extensive, including solutions for GIS systems. One of example graph application is the creation of a virtual generator of the city using database Neo4j (Płuciennik & Płuciennik-Psota 2014). Graph structure reproduces biological structure of memory well (Horzyk 2013). Based on this advantage, there are new opportunities to store and analyze geological data. The use of graphs to record those data enables data analyses in similar manner like in associative neural networks (Horzyk 2013). Geological stratum often has a complex structure, for example: around area of tectonic faults (often multiple faults in history), intrusive rocks in stratum. Possibilities of using graph databases for storing geological data were checked. This study focuses on proposing a graph representation of geological stratum. The proposed graph structure was implemented in the graph database. Presentation of the history of geological stratum in relational databases is difficult. Studies show an example of stratum graph model, which enables data mining of stratum history in easy method, because graph database systems are designed to make search queries to find similarity in data. Additionally, the results of this study demonstrated useful query. Moreover, software and possible methods of construction of graph models were studied. As shown by the results, an analysis of complex models of geological stratum can be less complicated. Research shows that finding dependences in the graph representation of the geological layers can be beneficial in geological analyses.