Integration of Relational and Graph Databases Functionally

Pokorný, Jaroslav

doi:10.2478/fcds-2019-0021

Cited by 10 publications

(5 citation statements)

References 17 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…It is then possible to express queries through such integrated heterogeneous databases by a single query expression expressed in a typed version of lambda calculus. A more user-friendly version of the language can serve as a powerful query tool in practice, queries sent to integrated systems and translated into queries in SQL and Cypher [11,12]. An automated method for modeling relational databases that uses SQL triggers and foreign keys to efficiently answer positive semantic questions about instances based to Web Semantic ontologies.…”

Section: Related Workmentioning

confidence: 99%

Design and Analysis of Query Models Database Preservation Information Systems Digitization of History and Endowments; Case Study of History and Waqf of Sumedang Larang Kingdom Indonesia

Sudrajat¹,

Ruchjana²,

Abdullah³

et al. 2023

Preprint

View full text Add to dashboard Cite

Historical and Endowment Properties are different from Heritage and cultural Properties, as Historical and Endowment properties are governed by a unique set of laws that Waqf recipients must abide by. Property that is entrusted is usually in the form of buildings, land or valuables which in preservation is not limited to time as long as the property can be utilized. Reliable information technology is needed to ensure data security both digitally and physically, while the rapid development of information technology demands information openness and this will be a challenge in itself. The objectives of this study include examining the collection of historical databases and endowments, the relationship between digital data and physical data and management organizations. The method of how to design a query model to display data is then analyzed whether the data conforms to the rules in waqf management. The results are expected to bring up accurate data between digital data and physical data and if there are differences into findings for the next analysis.

show abstract

Section: Related Workmentioning

confidence: 99%

Design and Analysis of Query Models Database Preservation Information Systems Digitization of History and Endowments; Case Study of History and Waqf of Sumedang Larang Kingdom Indonesia

Sudrajat¹,

Ruchjana²,

Abdullah³

et al. 2023

Preprint

View full text Add to dashboard Cite

show abstract

“…To solve this problems, graph databases, which is a form of an object relational mapping [7] (ORM) is required to provide data mapping to all models of objects. These databases can be implemented with the help Neo4j which is a relational database system developed using graph theory techniques.…”

Section: Related Literaturementioning

confidence: 99%

“…MATCH (Visitors:User)-[r:VIEWS]->(home:Page {page: "https://www.ettrading.com/"}) RETURN home.page AS url, count(r) AS visits; Table II displayed the number of the website visitors that are "bouncers". This means that of the twelve visits, five (5) persons did not have any business with the website whilst seven (7) persons were true visitors and interested in the products advertised.…”

Section: Code: Match (N) Return N;mentioning

confidence: 99%

Analysis of Cyber Activities of Potential Business Customers Using Neo4j Graph Databases

2022

IJMLC

View full text Add to dashboard Cite

Data analysis is an important aspect of business performance. With the application of artificial intelligence within databases, selecting a suitable database engine for an application design is also very crucial for business data analysis. The application of business intelligence (BI) software into some relational databases such as Neo4j has proved highly effective in terms of customer data analysis. Yet what remains of great concern is the fact that not all business organizations have the neo4j business intelligence software to implement for customer data analysis. Further, those with the BI software lack personnel with the requisite expertise to use it effectively with the neo4j database. The purpose of this research is to demonstrate how Neo4j program code alone can be use to analyze e-commerce website customer visits. As neo4j database engine is optimized for handling data relations with capabilities of building high performance, scalable systems for connected nodes, it will ensure that business owners who advertised their products at websites using neo4j as a database are able to determine the number of visitors so as to know which products are regularly visited for the necessary decision making. It will also help in knowing the best customer segments in relation to specific goods so as to place more emphasis on their advertisement on the said websites.

show abstract

“…The crucial differences between relational and A Systematic Approach for Converting Relational to Graph Databases Đukić, Marija; Pantelić, Ognjen; Pajić Simović, Ana; Krstović, Stefan; and Jejić, Olga A graph databases are [12]: 1. Relational database structure is stricter than graph structure, 2.…”

Section: Introductionmentioning

confidence: 99%

A Systematic Approach for Converting Relational to Graph Databases

Đukić,

Pantelić,

Pajić Simović

et al. 2024

IPSI TIR

View full text Add to dashboard Cite

In database design, a system can be abstracted into three conceptual elements: a collection of entities, the relationships among them, and the attributes describing each entity. The database serves as a system for storing data through the mentioned conceptual elements. Different database design approaches are customized to suit particular use cases e.g. the comparison between graph databases and relational databases. Graph databases are particularly wellsuited for handling data with dense relationships, as they are designed to store and represent complex networks of interconnected data. Relational databases pose a challenge in scenarios where the graph would be better suited. The migration process involves restructuring the data and adapting the application logic which can be resource-intensive and time-consuming. Current solutions for database migration are often too generalized, resulting in a lack of effectiveness in addressing common migration cases. These solutions fail to provide the necessary level of specificity required to overcome the challenges that arise during the migration process. This paper proposes a structured approach for transferring data from a relational to a graph database. The proposed approach introduces strategies dedicated to the conversion of specific relational elements, such as associations, specializations, and many-to-many relationships. The approach was tested using Microsoft’s Northwind sample database. Upon transferring the data from a relational to a graph database, the paper reports that queries produced identical results, indicating that the details of the data were accurately preserved during the migration. Following an experimental analysis, the results indicate that the proposed approach exhibits better performance, as evidenced by shorter query execution times. These findings affirm the feasibility and veracity of the proposed approach.

show abstract

Integration of Relational and Graph Databases Functionally

Cited by 10 publications

References 17 publications

Design and Analysis of Query Models Database Preservation Information Systems Digitization of History and Endowments; Case Study of History and Waqf of Sumedang Larang Kingdom Indonesia

Design and Analysis of Query Models Database Preservation Information Systems Digitization of History and Endowments; Case Study of History and Waqf of Sumedang Larang Kingdom Indonesia

Analysis of Cyber Activities of Potential Business Customers Using Neo4j Graph Databases

A Systematic Approach for Converting Relational to Graph Databases

Contact Info

Product

Resources

About