ABSTRACT
With the influx of Web 3.0 the focus in Big Data Analytics has shifted towards modelling highly interconnected data and analysing relationships between them. Graph databases befit the requirements of Big Data Analytics yet organizations still depend on relational databases. A major roadblock in the industry wide adoption of graph databases is that a standard query language is still in its inception stage hence withholding interoperability between the two technologies. In this research we propose a tool FLUX for translating relational database queries to graph database queries.
- Averbuch Alex and Martinez Norbert. 2013. LDBC Use case analysis and choke point analysis. http://ldbcouncil.org/sites/default/files/LDBC_D3.3.1.pdf Accessed: 2019-03-01.Google Scholar
- Renzo Angles, Marcelo Arenas, Pablo Barceló, Peter Boncz, George Fletcher, Claudio Gutierrez, Tobias Lindaaker, Marcus Paradies, Stefan Plantikow, Juan Sequeda, et al. 2018. G-CORE: A core for future graph query languages. In Proceedings of the 2018 International Conference on Management of Data. 1421--1432.Google ScholarDigital Library
- Renzo Angles, Marcelo Arenas, Pablo Barceló, Aidan Hogan, Juan Reutter, and Domagoj Vrgoč. 2017. Foundations of modern query languages for graph databases. ACM Computing Surveys (CSUR) 50, 5 (2017), 1--40.Google ScholarDigital Library
- Renzo Angles, Peter Boncz, Josep Larriba-Pey, Irini Fundulaki, Thomas Neumann, Orri Erling, Peter Neubauer, Norbert Martinez-Bazan, Venelin Kotsev, and Ioan Toma. 2014. The linked data benchmark council: a graph and RDF industry benchmarking effort. ACM SIGMOD Record 43, 1 (2014), 27--31.Google ScholarDigital Library
- Thiago Henrique Dias Araujo, Barbara Tieko Agena, Kelly Rosa Braghetto, and Renata Wassermann. 2017. OntoMongo-Ontology-Based Data Access for NoSQL. ONTOBRAS 1908 (2017), 55--66.Google Scholar
- Nikos Bikakis, Nektarios Gioldasis, Chrisa Tsinaraki, and Stavros Christodoulakis. 2009. Querying xml data with sparql. In International conference on database and expert systems applications. Springer, 372--381.Google ScholarDigital Library
- Peter Boncz, Irini Fundulaki, Andrey Gubichev, Josep Larriba-Pey, and Thomas Neumann. 2013. The linked data benchmark council project. Datenbank-Spektrum 13, 2 (2013), 121--129.Google ScholarCross Ref
- Diego Calvanese, Giuseppe De Giacomo, Maurizio Lenzerini, and Moshe Y Vardi. 2000. Answering regular path queries using views. In Proceedings of 16th International Conference on Data Engineering (Cat. No. 00CB37073). IEEE, 389--398.Google ScholarCross Ref
- Diego Calvanese, Giuseppe De Giacomo, Maurizio Lenzerini, and Moshe Y Vardi. 2000. Containment of conjunctive regular path queries with inverse. KR 2000 (2000), 176--185.Google Scholar
- Stefano Ceri and Georg Gottlob. 1985. Translating SQL into relational algebra: Optimization, semantics, and equivalence of SQL queries. IEEE Transactions on software engineering 4 (1985), 324--345.Google ScholarDigital Library
- Donald D Chamberlin and Raymond F Boyce. 1974. SEQUEL: A structured English query language. In Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control. 249--264.Google Scholar
- Sandeep Chanda and Damien Foggon. 2013. The Future of Relational Databases. In Beginning ASP. NET 4.5 Databases. Springer, 27--47.Google Scholar
- Artem Chebotko, Shiyong Lu, Hasan M Jamil, and Farshad Fotouhi. 2006. Semantics preserving SPARQL-to-SQL query translation for optional graph patterns. Wayne State University, Tech. Rep. TR-DB-052006-CLJF (2006).Google Scholar
- Edgar F Codd. 2002. A relational model of data for large shared data banks. In Software pioneers. Springer, 263--294.Google Scholar
- David Dominguez-Sal, Norbert Martinez-Bazan, Victor Muntes-Mulero, Pere Baleta, and Josep Lluis Larriba-Pey. 2010. A discussion on the design of graph database benchmarks. In Technology Conference on Performance Evaluation and Benchmarking. Springer, 25--40.Google Scholar
- Matthias Droop, Markus Flarer, Jinghua Groppe, Sven Groppe, Volker Linnemann, Jakob Pinggera, Florian Santner, Michael Schier, Felix Schöpf, Hannes Staffler, et al. 2007. Translating xpath queries into sparql queries. In OTM Confederated International Conferences" On the Move to Meaningful Internet Systems". Springer, 9--10.Google ScholarCross Ref
- Wenfei Fan, Jeffrey Xu Yu, Hongjun Lu, Jianhua Lu, and Rajeev Rastogi. 2005. Query translation from XPath to SQL in the presence of recursive DTDs. In VLDB. 337--348.Google Scholar
- Peter Gulutzan and Trudy Pelzer. 1999. SQL-99 complete, really. CMP books.Google Scholar
- Alan Halverson, Vanja Josifovski, Guy Lohman, Hamid Pirahesh, and Mathias Mörschel. 2004. ROX: relational over XML. In Proceedings of the Thirtieth international conference on Very large data bases-Volume 30. 264--275.Google Scholar
- Jelle Hellings. 2018. On Tarski's Relation Algebra: querying trees and chains and the semi-join algebra.Google Scholar
- Jelle Hellings, Yuqing Wu, Marc Gyssens, and Dirk Van Gucht. 2018. The power of Tarski's relation algebra on trees. In International Symposium on Foundations of Information and Knowledge Systems. Springer, 244--264.Google ScholarCross Ref
- Moath Jarrah, Bahaa Al-khatieb, Naseem Mahasneh, Baghdad Al-khateeb, and Yaser Jararweh. 2020. GDBApex: A graph-based system to enable efficient transformation of enterprise infrastructures. Software: Practice and Experience (2020).Google Scholar
- Ross D King, Jem Rowland, Stephen G Oliver, Michael Young, Wayne Aubrey, Emma Byrne, Maria Liakata, Magdalena Markham, Pinar Pir, Larisa N Soldatova, et al. 2009. The automation of science. Science 324, 5923 (2009), 85--89.Google Scholar
- Mohamed Nadjib Mami, Damien Graux, Harsh Thakkar, Simon Scerri, Sören Auer, and Jens Lehmann. 2019. The query translation landscape: a survey. arXiv preprint arXiv:1910.03118 (2019).Google Scholar
- Erik Meijer and Gavin Bierman. 2011. A co-relational model of data for large shared data banks. Commun. ACM 54, 4 (2011), 49--58.Google ScholarDigital Library
- OpenCypher. 2018. OpenCypher. https://www.opencypher.org/ Accessed: 2018-10-01.Google Scholar
- Jaroslav Pokornỳ. 2015. Graph Databases: Their Power and Limitations. In 14th Computer Information Systems and Industrial Management (CISIM). Springer, 58--69.Google Scholar
- Jyothsna Rachapalli, Vaibhav Khadilkar, Murat Kantarcioglu, and Bhavani Thuraisingham. 2011. RETRO: a framework for semantics preserving SQL-to-SPARQL translation. The University of Texas at Dallas 800 (2011), 75080--3021.Google Scholar
- Marko A Rodriguez and Peter Neubauer. 2010. Constructions from dots and lines. Bulletin of the American Society for Information Science and Technology 36, 6 (2010), 35--41.Google ScholarCross Ref
- Marko A Rodriguez and Peter Neubauer. 2012. The graph traversal pattern. In Graph Data Management: Techniques and Applications. IGI Global, 29--46.Google Scholar
- Chandan Sharma and Roopak Sinha. 2019. A Schema-First Formalism for Labeled Property Graph Databases: Enabling Structured Data Loading and Analytics. In Proceedings of the 6th IEEE/ACM International Conference on Big Data Computing, Applications and Technologies. 71--80.Google ScholarDigital Library
- Chandan Sharma, Roopak Sinha, and Paulo Leitao. 2019. IASelect: Finding Bestfit Agent Practices in Industrial CPS Using Graph Databases. In 2019 IEEE 17th International Conference on Industrial Informatics (INDIN), Vol. 1. IEEE, 1558--1563.Google Scholar
- Avi Silberschatz, Michael Stonebraker, and Jeff Ullman. 1991. Database systems: Achievements and opportunities. Commun. ACM 34, 10 (1991), 110--120.Google ScholarDigital Library
- Benjamin A Steer, Alhamza Alnaimi, Marco ABFG Lotz, Felix Cuadrado, Luis M Vaquero, and Joan Varvenne. 2017. Cytosm: Declarative property graph queries without data migration. In Proceedings of the Fifth International Workshop on Graph Data-management Experiences & Systems. 1--6.Google ScholarDigital Library
- Wen Sun, Achille Fokoue, Kavitha Srinivas, Anastasios Kementsietsidis, Gang Hu, and Guotong Xie. 2015. Sqlgraph: An efficient relational-based property graph store. In Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data. 1887--1901.Google ScholarDigital Library
- Igor V Tetko, Ola Engkvist, Uwe Koch, Jean-Louis Reymond, and Hongming Chen. 2016. BIGCHEM: Challenges and opportunities for big data analysis in chemistry. Molecular informatics 35, 11--12 (2016), 615--621.Google Scholar
- Harsh Thakkar, Dharmen Punjani, Yashwant Keswani, Jens Lehmann, and Sören Auer. 2018. A Stitch in Time Saves Nine-SPARQL querying of Property Graphs using Gremlin Traversals. arXiv preprint arXiv:1801.02911 (2018).Google Scholar
- JV Tucker and K Stephenson. 2003. Data, syntax and semantics.Google Scholar
- Ted Wilmes. 2016. Gremlin to SQL. https://github.com/twilmes/sql-gremlin Accessed: 2020--03-01.Google Scholar
- Chun Zhang, Jeffrey Naughton, David DeWitt, Qiong Luo, and Guy Lohman. 2001. On supporting containment queries in relational database management systems. In Proceedings of the 2001 ACM SIGMOD international conference on Management of data. 425--436.Google ScholarDigital Library
Index Terms
- FLUX: from SQL to GQL query translation tool
Recommendations
Vishleshan: Performance Comparison and Programming Process Mining Algorithms in Graph-Oriented and Relational Database Query Languages
IDEAS '15: Proceedings of the 19th International Database Engineering & Applications SymposiumProcess-Aware Information System (PAIS) are IT systems that manages, supports business processes and generate large event logs from execution of business processes. Process Mining consists of analyzing event logs generated by PAISs and discover business ...
Graph Model for the Identification of Multi-target Drug Information for Culinary Herbs
Bioinformatics and Biomedical EngineeringAbstractDrug discovery strategies based on natural products are re-emerging as a promising approach. Due to its multi-target therapeutic properties, natural compounds in herbs produce greater levels of efficacy with fewer adverse effects and toxicity than ...
Query processing over object views of relational data
This paper presents an approach to object view management for relational databases. Such a view mechanism makes it possible for users to transparently work with data in a relational database as if it was stored in an object-oriented (OO) database. A ...
Comments