SQL “+” NoSQL, A Merger with Great Capabilities

International Journal of Computer Trends and Technology (IJCTT)          
© 2018 by IJCTT Journal
Volume-62 Number-1
Year of Publication : 2018
Authors : Wumi Ajayi
DOI :  10.14445/22312803/IJCTT-V62P102


MLA Style: Wumi Ajayi "SQL “+” NoSQL, A Merger with Great Capabilities" International Journal of Computer Trends and Technology 62.1 (2018): 14-20.

APA Style:Wumi Ajayi (2018). SQL “+” NoSQL, A Merger with Great Capabilities. International Journal of Computer Trends and Technology, 62(1), 14-20.

Analysis of SQL and NoSQL databases is presented here with an intention of prescribing how they can work together for better capabilities. The work begins with short background on the basic terms (data, database and database management system) used in the database paradigm. Next a review of some closely related work is presented; followed by an analysis of the two databases with special attention on query structure, standards and characteristics. Then special features that could make then work together were presented before concluding on recommendation. To aid smooth reading and understanding, the work is presented in sections.

[1] Aslett, M. (2011). Retrieved Dec 28, 2017, from https://cs.brown.edu/courses/cs227/archives/2012/papers/newsql/aslett-newsql.pdf.
[2] Birgen, C. (2014). Advance Process Simulation, SQL Vs Nosql. University Of Science And Technology. Retrieved Dec 2017, from: http://folk.ntnu.no/preisig/HAP_Specials/AdvancedSimulation_files/2014/AdvSim-2014__Birgen_Cansu_Databases.pdf
[3] Elmasri, R. and Navathe, S. (2011). Fundamentals of Database Systems (6 ed.). (Addison-Wesley, Ed.) Pearson.
[4] FIXSTARS. (2017). NoSQL Database Architectural Comparison. (revision 1.00).
[5] Gessert, F., Wingerath, W., Friedrich, S., and Ritter, N. (2016). NoSQL database systems: a survey and decision guidance. Springer.
[6] GIGASPACES (2011) NoSQL, NewSQL and Beyond: The answer to SPRAINed relational databases, retrieved from https://blogs.the451group.com/information_management/2011/04/15/nosql-newsql-and-beyond/
[7] Halvorsen, H.P. (2016). Software Project management, retrieved from https://home.usn.no/hansha/documents/software/software_development/topics/resources/Software%20Project%20Management%20Overview.pdf
[8] Hare, K. (2011). A Comparison of SQL and NoSQL Databases. JCC Consulting Inc. ISO/IEC JTC1 SC32 WG3
[9] Hoffer, J.A., Prescott, M.B. and Topi, H. (2009). Modern Database Management (9 ed.). US: Prentice Hall. Retrieved from http://fkee.uthm.edu.my/helmy1299/class../dec2213/Present_Bab_8.pdf
[10] Kumar, L., Rajawat, S., and Joshi, K. (2015). Comparative analysis of NoSQL (MongoDB) with MySQL Database. International Journal of Modern Trends in Engineering and research IJMTER, 120-127.
[11] Pozzani, G. (2013). Introduction to NoSQL. Retrieved from http://profs.sci.univr.it/~pozzani/attachments/nosql%20-%2001%20 %20introduction.pdf
[12] Sharma, S. (n.d.). An Extended Classification and Comparison of NoSQL Big Data Models. Retrieved from https://arxiv.org/ftp/arxiv/papers/1509/1509.08035.pdf
[13] Silberschatz, A., Korth, H.F. and Sudarshan, S. (2011). Database System Concepts (6 ed.). India: Mcgraw-hill.

Databases, NoSQL, SQL, Database Integration, MongoDB, MySQL