ABSTRACT
Relational databases have been around for many decades and are the database technology of choice for most traditional data-intensive storage and retrieval applications. Retrievals are usually accomplished using SQL, a declarative query language. Relational database systems are generally efficient unless the data contains many relationships requiring joins of large tables. Recently there has been much interest in data stores that do not use SQL exclusively, the so-called NoSQL movement. Examples are Google's BigTable and Facebook's Cassandra. This paper reports on a comparison of one such NoSQL graph database called Neo4j with a common relational database system, MySQL, for use as the underlying technology in the development of a software system to record and query data provenance information.
- R. Angles and C. Gutierrez. Survey of graph database models. ACM Comput. Surv., 40(1):1--39, 2008. Google ScholarDigital Library
- F. Chang, J. Dean, S. Ghemawat, W. C. Hsieh, D. A. Wallach, M. Burrows, T. Chandra, A. Fikes, and R. E. Gruber. Bigtable: A distributed storage system for structured data. ACM Trans. Comput. Syst., 26(2):1--26, 2008. Google ScholarDigital Library
- G. DeCandia, D. Hastorun, M. Jampani, G. Kakulapati, A. Lakshman, A. Pilchin, S. Sivasubramanian, P. Vosshall, and W. Vogels. Dynamo: amazon's highly available key-value store. SIGOPS Oper. Syst. Rev., 41(6):205--220, 2007. Google ScholarDigital Library
- T. Ivarsson. {neo} security. http://lists.neo4j.org/pipermail/user/2009-November/001955.html, 2009.Google Scholar
- M. Kleppmann. Should you go beyond relational databases? http://carsonified.com/blog/dev/should-you-go-beyond-relational-databases/, 2009.Google Scholar
- A. Lakshman. Cassandra - a structured storage system on a p2p network. http://www.facebook.com/note.php?note_id=24413138919, 2008.Google Scholar
- Neo4j. Home. http://neo4j.org, 2009.Google Scholar
- Project Voldemort. Project voldemort: A distributed database. http://project-voldemort.com/, 2009.Google Scholar
Recommendations
Migration of data from relational database to graph database
ICIST '18: Proceedings of the 8th International Conference on Information Systems and TechnologiesRelational databases have been widely used in many applications until today and they have met needs for data-intensive domains and transactions, but today data is growing faster than ever and extracting information from this huge data is becoming more ...
Query-based Performance Comparison of Graph Database and Relational Database
SoICT '22: Proceedings of the 11th International Symposium on Information and Communication TechnologyA graph database is a type of NoSQL database that uses graph structure for semantic queries with nodes, edges, and properties to represent and store data. It has been applied in many fields, such as education, health, business, and social network, with ...
Model Transformation From Object Relational Database to NoSQL Document Database
NISS '19: Proceedings of the 2nd International Conference on Networking, Information Systems & SecurityWith the high increase of data growing, NoSQL databases play a key role in storing large amount of data, to gain flexibility and scalability many industries are now replacing their relational and object relational databases by adopting NoSQL database ...
Comments