CFP last date
20 December 2024
Reseach Article

Data Relationship Query in Relational DB, NoSQL DB and Graph DB

by Kay Thi Yar, Khin Mar Lar Tun
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 105 - Number 17
Year of Publication: 2014
Authors: Kay Thi Yar, Khin Mar Lar Tun
10.5120/18473-9917

Kay Thi Yar, Khin Mar Lar Tun . Data Relationship Query in Relational DB, NoSQL DB and Graph DB. International Journal of Computer Applications. 105, 17 ( November 2014), 36-40. DOI=10.5120/18473-9917

@article{ 10.5120/18473-9917,
author = { Kay Thi Yar, Khin Mar Lar Tun },
title = { Data Relationship Query in Relational DB, NoSQL DB and Graph DB },
journal = { International Journal of Computer Applications },
issue_date = { November 2014 },
volume = { 105 },
number = { 17 },
month = { November },
year = { 2014 },
issn = { 0975-8887 },
pages = { 36-40 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume105/number17/18473-9917/ },
doi = { 10.5120/18473-9917 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:38:00.813699+05:30
%A Kay Thi Yar
%A Khin Mar Lar Tun
%T Data Relationship Query in Relational DB, NoSQL DB and Graph DB
%J International Journal of Computer Applications
%@ 0975-8887
%V 105
%N 17
%P 36-40
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Every nation has vast amount of census data and analysis of these data is the value for nation as source citations, correlating and corroborating sources, relevance or findings contradictions. These census data may relate in any form based on family group records, friendship, co-worker and etc. In this paper, our nation, Myanmar's census data is used as source citations for searching relationship between two distinct persons based on unique National Registration Card (NRC) Number. The Myanmar census data involve person name, date of birth, gender, occupation, parent names, relationship with householder, NRC number and detail parent's family records including jobs and etc. NRC number is the unique identification number for every citizen in Myanmar. The aim of this paper is to observe the efficient data storage form for those related data among three types of database structure; relational DB, NoSQL DB, graph DB. The observation is done by retrieving data relationship from these databases using their query form. In relational database, personnel data is stored as table structure while in NoSQL databases like key-values store, column-family store and document store, personnel data is stored as key-values pair, column oriented and document oriented structure respectively. In graph database, personnel data is stored as graph structure with persons as nodes and relationship between them as edges. Then the query processing time is compared based on retrieving related data from those databases by using their relevant query system and find out which query process can produce the optimal running time. The experimental results show that graph database is more powerful in retrieving relationship over relational and NoSQL databases and it can provide better performance when handling in highly interconnected data compared to relational and NoSQL databases.

References
  1. R. D. Virgilio, et al. 2013. Converting Relational to Graph Database. In Proceedings of the First International Workshop on Graph Data Management Experience and Systems (GRADES 2013), June 23, 2013 - New York, NY, USA.
  2. R. Cattell, 2010. Relational Databases, Object Databases, Key-Value Stores, Document Stores, and Extensible Record Stores: A Comparison.
  3. A Nayak, et al, 2013. Type of NOSQL Databases and its Comparison with Relational Databases. In International Journal of Applied Information Systems (IJAIS) – ISSN: 2249-0868 Foundation of Computer Science FCS, New York, USA Volume 5– No. 4, March 2013 – www. ijais. org.
  4. C. Hadjigeorgiou, et al, 2013. RDBMS vs NoSQL: Performance and Scaling Comparison.
  5. S. K. Gajendran. A Survey on NoSQL Databases.
  6. C. J. M. Tauro, et al. A Comparative Analysis of Different NoSQL Databases on Data Model, Query Model and Replication Model. In Proceedings of the International Conference on "Emerging Research in Computing, Information, Communication and Applications" ERCICA 2013, ISBN: 9789351071020.
  7. C. Vicknair, et al. 2010. A Comparison of a Graph Database and a Relational Database. ACMSE '10, April 15-17, 2010, Oxford, MS, USA
  8. A. B. M. Moniruzzaman, 2013. NoSQL Database: New Era of Databases for Big data Analytics - Classification, Characteristics and Comparison. International Journal of Database Theory and Application, Vol. 6, No. 4. 2013.
  9. I. Robinson, et al. 2013. Graph Databases. June 2013: First Edition.
  10. M. Buerli, 2012. The Current State of Graph Databases. Department of Computer Science, Cal Poly San Luis Obispo, mbuerli@calpoly. edu.
  11. R. Angles, et al. 2008. Survey of Graph Database Models. ACM Computing Surveys, Vol. 40, No. 1, Article 1, Publication date: February 2008.
  12. F. Holzschuher, 2013. Performance of Graph Query Languages. EDBT/ICDT '13 March 18 - 22 2013, Genoa, Italy.
  13. S. Jouili, et al. An empirical comparison of graph databases.
  14. Hull, R. AND King, R. 1987. Semantic database modeling: Survey, applications, and research issues. ACM Comput. Surv. 19, 3, 201-260.
Index Terms

Computer Science
Information Sciences

Keywords

Relational Database NoSQL Databases Graph Database Data Model Query Model.