Google scholar arxiv informatics ads IJAIS publications are indexed with Google Scholar, NASA ADS, Informatics et. al.

Call for Paper

-

August Edition 2018

International Journal of Applied Information Systems solicits high quality original research papers for the August 2018 Edition of the journal. The last date of research paper submission is July 16, 2018.

TripleFetchQL: A Platform for Integrating Relational and NoSQL Databases

Oluwafemi E. Ooju, Sahalu B. Junaidu, S.E. Abdullahi. Published in Software Engineering

International Journal of Applied Information Systems
Year of Publication: 2016
Publisher: Foundation of Computer Science (FCS), NY, USA
Authors: Oluwafemi E. Ooju, Sahalu B. Junaidu, S.E. Abdullahi
10.5120/ijais2016451513
Download full text
  1. Oluwafemi E Ooju, Sahalu B Junaidu and S E Abdullahi. Article: TripleFetchQL: A Platform for Integrating Relational and NoSQL Databases. International Journal of Applied Information Systems 10(5):54-57, February 2016. BibTeX

    @article{key:article,
    	author = "Oluwafemi E. Ooju and Sahalu B. Junaidu and S.E. Abdullahi",
    	title = "Article: TripleFetchQL: A Platform for Integrating Relational and NoSQL Databases",
    	journal = "International Journal of Applied Information Systems",
    	year = 2016,
    	volume = 10,
    	number = 5,
    	pages = "54-57",
    	month = "February",
    	note = "Published by 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.

Reference

  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.

Keywords

ACID, CAP, NOSQL, TFQL