CFP last date
15 March 2024
Reseach Article

TripleFetchQL: A Platform for Integrating Relational and NoSQL Databases

by Oluwafemi E. Ooju, Sahalu B. Junaidu, S.E. Abdullahi
International Journal of Applied Information Systems
Foundation of Computer Science (FCS), NY, USA
Volume 10 - Number 5
Year of Publication: 2016
Authors: Oluwafemi E. Ooju, Sahalu B. Junaidu, S.E. Abdullahi
10.5120/ijais2016451513

Oluwafemi E. Ooju, Sahalu B. Junaidu, S.E. Abdullahi . TripleFetchQL: A Platform for Integrating Relational and NoSQL Databases. International Journal of Applied Information Systems. 10, 5 ( February 2016), 54-57. DOI=10.5120/ijais2016451513

@article{ 10.5120/ijais2016451513,
author = { Oluwafemi E. Ooju, Sahalu B. Junaidu, S.E. Abdullahi },
title = { TripleFetchQL: A Platform for Integrating Relational and NoSQL Databases },
journal = { International Journal of Applied Information Systems },
issue_date = { February 2016 },
volume = { 10 },
number = { 5 },
month = { February },
year = { 2016 },
issn = { 2249-0868 },
pages = { 54-57 },
numpages = {9},
url = { https://www.ijais.org/archives/volume10/number5/867-2016451513/ },
doi = { 10.5120/ijais2016451513 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2023-07-05T19:02:40.789820+05:30
%A Oluwafemi E. Ooju
%A Sahalu B. Junaidu
%A S.E. Abdullahi
%T TripleFetchQL: A Platform for Integrating Relational and NoSQL Databases
%J International Journal of Applied Information Systems
%@ 2249-0868
%V 10
%N 5
%P 54-57
%D 2016
%I Foundation of Computer Science (FCS), NY, USA
Abstract

There has been an unprecedented growth and increase in the domain unstructured/semi-structured data is increasing over the years. While relational database systems remain popular and relevant, they are incapable of handling the growth level of unstructured data in the area of web applications. Conflating the benefits of a simple NoSQL storage engine with the relational databases and the unique ability of presenting query results from the duo to users at minimal costs have been a critical challenge in the research community. So far so good there has been a tremendous works such as using SQL with an extension of NQP on transformed NoSQL data which is store as SQL virtual relation, querying Apache Cassandra with SQL after altering the data structure, querying both world of relational and NoSQL and produced two results instead of single output. The TripleFetchQL system developed enables users to query relational and NoSQL databases and presents query results as if they were querying the familiar relational database alone. Furthermore, TripleFetchQL provide applications the ability of leveraging the benefits of relational and NoSQL databases at the small cost of learning the simple syntax of the TripleFetchQL system.

References
  1. Adeyi, T. S., Abdullahi, S. E., & Junaidu, S. B. (2013). DualFetchQL System: A Platform for Integrating Relational and NoSQL Databases. IJERT Vol. 2, Issue 12, December, 1973 - 1981.
  2. Brewer, E. A. (2012). CAP twelve years later: how the ‘rules’ have changed. Computer, Vol. 45 No. 2, 22 - 29.
  3. Codd, E. F. (1970). A relational model of data for large shared data banks. Communications of the ACM, 13(6), 377-387.
  4. Desire, A. (2014). Can SQL and NoSQL databases live happily together? An Article Retrieved: http://www.techradar.com/news/internet/web/can-sql-and-nosql-databases-live-happily-together--1278322/1.
  5. Ferreira, L. (2012). Bridging the Gap between SQL and NoSQL: SQL and ACID over a VLSD. Master Thesis, Universidade do Minho.
  6. Nance et al. NOSQL VS RDBMS - WHY THERE IS ROOM FOR BOTH. Proceedings of the Southern Association for Information Systems Conference, Savannah, GA, USA, March 8th–9th, 2013
  7. Pramod, J. S., & Martin, F. (2012). NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Retrieved: http://www.thoughtworks.com/insights/blog/nosql-databases-overview.
  8. Roijackers, J. (2012). Bridging SQL and NoSQL. Master Thesis. Eindhoven University of Technology.
  9. Roijackers, J., & Fletcher, G. H. (2013). On bridging relational and document-centric data stores. BNCOD' 13 Proceeding of the 29th British National Conference on Big Data., 135 - 148.
  10. Smith, S. (2013, October 13). Why NoSQL database is used by Facebook, Google and LinkedIn Application? Retrieved from http://blog.outsourcing-partners.com/2012/10/why-nosql-database-is-used-by-facebook-google-and-linkedin-applications/.
  11. Stonebraker, M., Madden, S., Abadi, D. J., Harizopoul, S., Hachem, N., & Helland, P. (2007). The end of an architectural era: (it's time for a complete rewrite)," in Proceedings of the 33rd international conference on Very large data bases.
  12. Strauch, C. (2011). NoSQL Databases - NoSQL Introduction and Overview. Paper retrieved: http://highscalability.com/blog/2011/4/13/paper-nosql-databases-nosql-introduction-and-overview.html.
  13. Varley, I. T. (2009). No Relation: The Mixed Blessings of Non-Relational Databases. Master Thesis in The University of Texasat Austin. Retrieved: http://ianvarley.com/UT/MR/Varley_MastersReport_Full_2009-08-07.pdf.
Index Terms

Computer Science
Information Sciences

Keywords

ACID CAP NOSQL TFQL