Comparative Case Study: An Evaluation of Performance Computation between SQL and NoSQL Database
Keywords:
SQL, NoSQL Database, MySQL, MongoDB.
Abstract
Data has always been the company's most valuable resource because it can be used for analysis, decision-making, and judgement. Hard data handling necessitates the use of complicated cache and accessibility concepts. The effectiveness of SQL and NoSQL database systems for producing scientific data is examined in this study. SQL databases and NoSQL databases are the most popular and structured types of database solutions. Another name for the SQL database is RDBMS (Relational Database Management System). Associations or tables are used to organize the data. A NoSQL database is a non-relational database management system. NoSQL databases, a new type of database system, were created to address this issue by providing an unstructured platform and scalability for large data applications. The term "NoSQL" refers to more than just SQL. Wide column stores, documents, graph databases, and key-value pairs are a few NoSQL database types that do not have the necessary standard structure. Additionally, in RDBMS, it might scale horizontally rather than vertically. To compare SQL and NoSQL databases, the data is organized in unstructured tables or relationships. Both are open source. The experiment assessed and supported database loading, response, and retrieval times for both SQL and NoSQL databases to discover if a database is smoother, more efficient, and performant.
References
[1] Roman Ceresnak1, Michal Kvet2, "Comparison of query performance in relational a non-relation databases", 13th International Scientific Conference on Sustainable, Modern and Safe Transport (TRANSCOM 2019), High Tatras, Novy Smokovec – Grand Hotel Bellevue, Slovak Republic, May 29-31, 2019
[2] Nagarajan Madhavan1, 2019, https://medium.com/@itIsMadhavan/sql-vs-nosql-databases-whats-the-difference-a05492b48d99
[3] Elad Israeli1, Eldad Farkash2, Aviad Harell3, Guy Boyangu4, Adi Azaria5, 2004, https://www.sisense.com/glossary/relational-database/
[4] SQL and NoSQL Database, https://qph.fs.quoracdn.net/main-qimg-548fdcb1dec7865303859def292f1f30
[5] Imtiaz Rashid: “Term Paper on Database Management System”.
[6] Don Chamberlin: “SQL”, IBM Almaden Research Center, San Jose, CA.
[7] Mohammad Muhtashim1, 2006, https://www.tutorialspoint.com/sql/sql-overview.htm
[8] MySQ Relational Database Management System (RDMS), https://i.ytimg.com/vi/cW-rgspRrX8/hqdefault.jpg
[9] SQL Database languages, https://csharpcorner.azureedge.net/UploadFile/BlogImages/01032017000551AM/image002.png
[10] Dwight Merriman1, Eliot Horowitz2, Kevin Ryan3, 2007, https://docs.mongodb.com/manual/core/data-modeling-introduction/#document-structure
[11] MongoDB Relational Database Management System (RDMS), https://image.slidesharecdn.com/mongodbrdbmsmigrationwebinar-140202060406-phpapp02/95/migrating-from-relational-databases-to-mongodb-10-638.jpg?cb=1391321199
[12] Lourenço, J., Cabral, B., Carreiro, P., Vieira, M. and Bernardino, J. (2015). Choosing the right NoSql database for the job: a quality attribute evaluation. Journal of Big Data, 2(1).
[13] Mehmood, N., Culmone, R. and Mostarda, L. (2017). Modeling temporal aspects of sensor data for MongoDB NoSql database. Journal of Big Data, 4(1).
[14] Sanchez-de-Madariaga, R., Muñoz, A., Lozano-Rubí, R., Serrano-Balazote, P., Castro, A., Moreno, O. and Pascual, M. (2017). Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSql approaches. BMC Medical Informatics and Decision Making, 17(1).
[15] Sneha Binani1, Ajinkya Gutti2, Shivam Upadhyay3, "SQL vs. NoSQL vs. NewSQL- A Comparative Study", Communications on Applied Electronics (CAE) – ISSN : 2394-4714 Foundation of Computer Science FCS, New York, USA Volume 6 – No.1, October 2016.
[16] Nidamanuri Amani1, Yelchuri Rajesh2,"Comparative Study of Open-Source NOSQL Document-Based Databases", 2020 Information and Communication Technology for Intelligent Systems (ICTIS).
[17] Zakariyaa Ait El Mouden1, Abdeslam Jakimi2, Moha Hajar3, Mohamed Boutahar4, "Graph Schema Storage in SQL Object-Relational Database and NoSQL Document-Oriented Database: A Comparative Study", 2019 Innovation in Information Systems and Technologies to Support Learning Research.
[18] Wisal Khan1, Waqas Ahmad2, Bin Luo, Ejaz Ahmed3, "SQL Database with physical database tuning technique and NoSQL graph database comparisons", 2019 IEEE 3rd Information Technology, Networking, Electronic and Automation Control Conference (ITNEC).
[19] Fatima Yassine1, Mamoun Adel Awad2, "Migrating from SQL to NOSQL Database: Practices and Analysis", 2018 International Conference on Innovations in Information Technology (IIT).
[20] Sunita1 Ghotiya2, Juhi Mandal3, Saravanakumar Kandasamy1, "Migration from relational to NoSQL database", 2017 IOP Conference Series: Materials Science and Engineering.
[21] Jitender Kumar1, Varsha Garg2, "Security analysis of unstructured data in NOSQL MongoDB database", 2017 International Conference on Computing and Communication Technologies for Smart Nation (IC3TSN).
[22] Cornelia Győrödi1, Robert Győrödi2, George Pecherle3, Andrada Olah4, "A comparative study: MongoDB vs. MySQL", 2015 13th International Conference on Engineering of Modern Electric Systems (EMES).
[23] Matthew Aslett: "451 Research delivers market sizing estimates for NoSQL, NewSQL and MySQL ecosystem” May 22nd, 2012
[24] Shiwei Yu: "ACID Properties in Distributed Databases", 20096
[25] Ryan Betts: “SQL Time-Tested and still flourishing”, VoltDB, Bedford.
[26] Jenny Richards, Advantages and Disadvantages of NoSQL databases – what you should know, Hadoop360, September 24, 2015,
[27] Venkat Gudivada, Dhana Rao and Vijay Raghavan: "NoSQL Systems for Big Data Management”, June 2014, Conference: 2014 IEEE World Congress on Services, At Anchorage, Alaska.
[28] A B M Moniruzzaman: "NewSQL: Towards Next Generation Scalable RDBMS for Online Transaction Processing (OLTP) for Big Data Management", Nov 2014.
[29] Hoff, Todd: "Google Spanner's Most Surprising Revelation: NoSQL is Out and NewSQL is In". Retrieved 2012-10-07.
[30] Stonebraker, Michael "NewSQL: An Alternative to NoSQL and Old SQL for New OLTP Apps". Communications of the ACM Blog. , 2012
[31] Vinay Jain "Rise of NewSQL". International Journal for Research in Emerging Science and Technology.
[32] Scholz, J.: Coping with Dynamic, Unstructured Data Sets – NoSQL: a Buzzwordor a Savior? In: Schrenk, M., Popovich, V.V., Zeile, P. Proc. REAL CORP 2011May, 1–9 (2011).
[33] Stonebraker, M. et al.: C-store: a Column-Oriented DBMS. In: Proc. 31st VLDBConference. pp. 553–564 (2005).
[34] Zaki, A.K.: NoSQL Databases?: New millenium database for big data, big users,cloud computing and its security challenges. 403–409 (2014).
[35] The Vertica RAnalytic Database Technical Overview White Paper (2010).
[36] Abadi, D. et al.: Integrating Compression and Execution in Column-Oriented Database Systems. In: Proc. 2006 ACM SIGMOD Int. Conf. Manag. data – SIG-MOD’06. pp. 671 (2006).
[37] Abadi, D.J. et al.: Column-Oriented Database Systems. In: Proc. VLDB ’09.pp. 1664–1665 (2009).
[38] Abadi, D.J., Madden, S.R.: Column-Stores vs. Row-Stores?: How Different Are They Really? In: SIGMOD’08. pp. 967–980 (2008).
[39] Angles, R., Gutierrez, C.: Survey of graph database models. ACM Comput. Surv.40(1), 1–39 (2008).
[40] Harizopoulos, S. et al.: Performance Tradeoffs in Read-Optimized Databases. In: Proc. VLDB Endowment. pp. 487–498 (2006).
[41] Kyurkchiev, H., Kaloyanova, K.: Performance Study of Analytical Queries of Oracleand Vertica. In: Proc. 7th ISGT Int. Conf. pp. 127 – 139 2013)
[42] Lamb, A. et al.: The Vertica Analytic Database?: C-Store 7 Years Later. In: Proc.VLDB Endowment. pp. 1790–1801 (2012).
[43] Mitreva, E., Kaloyanova, K.: NoSQL Solutions to Handle Big Data. In: Proc. Doc-toral Conference in MIE. pp. 77–86 (2013).
[44] Neil, B.O. et al.: The Star Schema Benchmark and Augmented Fact Table Indexing Outline of Talk. In: Nambiar, R., Poess, M. (eds.) Performance Evaluation and Benchmarking. LNCS, vol. 5895, pp. 237–252. Springer, Heidelberg (2009).
[45] Padhy, R.P. et al.: RDBMS to NoSQL: Reviewing some next-generation non-relational database’s. Int. J. Adv. Eng. Sci. Technol. 11, 15–30 (2011).
[46] Redmond, E., Wilson, J.R.: Seven Databases in Seven Weeks. The Pragmatic Book-shelf (2012).
[2] Nagarajan Madhavan1, 2019, https://medium.com/@itIsMadhavan/sql-vs-nosql-databases-whats-the-difference-a05492b48d99
[3] Elad Israeli1, Eldad Farkash2, Aviad Harell3, Guy Boyangu4, Adi Azaria5, 2004, https://www.sisense.com/glossary/relational-database/
[4] SQL and NoSQL Database, https://qph.fs.quoracdn.net/main-qimg-548fdcb1dec7865303859def292f1f30
[5] Imtiaz Rashid: “Term Paper on Database Management System”.
[6] Don Chamberlin: “SQL”, IBM Almaden Research Center, San Jose, CA.
[7] Mohammad Muhtashim1, 2006, https://www.tutorialspoint.com/sql/sql-overview.htm
[8] MySQ Relational Database Management System (RDMS), https://i.ytimg.com/vi/cW-rgspRrX8/hqdefault.jpg
[9] SQL Database languages, https://csharpcorner.azureedge.net/UploadFile/BlogImages/01032017000551AM/image002.png
[10] Dwight Merriman1, Eliot Horowitz2, Kevin Ryan3, 2007, https://docs.mongodb.com/manual/core/data-modeling-introduction/#document-structure
[11] MongoDB Relational Database Management System (RDMS), https://image.slidesharecdn.com/mongodbrdbmsmigrationwebinar-140202060406-phpapp02/95/migrating-from-relational-databases-to-mongodb-10-638.jpg?cb=1391321199
[12] Lourenço, J., Cabral, B., Carreiro, P., Vieira, M. and Bernardino, J. (2015). Choosing the right NoSql database for the job: a quality attribute evaluation. Journal of Big Data, 2(1).
[13] Mehmood, N., Culmone, R. and Mostarda, L. (2017). Modeling temporal aspects of sensor data for MongoDB NoSql database. Journal of Big Data, 4(1).
[14] Sanchez-de-Madariaga, R., Muñoz, A., Lozano-Rubí, R., Serrano-Balazote, P., Castro, A., Moreno, O. and Pascual, M. (2017). Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSql approaches. BMC Medical Informatics and Decision Making, 17(1).
[15] Sneha Binani1, Ajinkya Gutti2, Shivam Upadhyay3, "SQL vs. NoSQL vs. NewSQL- A Comparative Study", Communications on Applied Electronics (CAE) – ISSN : 2394-4714 Foundation of Computer Science FCS, New York, USA Volume 6 – No.1, October 2016.
[16] Nidamanuri Amani1, Yelchuri Rajesh2,"Comparative Study of Open-Source NOSQL Document-Based Databases", 2020 Information and Communication Technology for Intelligent Systems (ICTIS).
[17] Zakariyaa Ait El Mouden1, Abdeslam Jakimi2, Moha Hajar3, Mohamed Boutahar4, "Graph Schema Storage in SQL Object-Relational Database and NoSQL Document-Oriented Database: A Comparative Study", 2019 Innovation in Information Systems and Technologies to Support Learning Research.
[18] Wisal Khan1, Waqas Ahmad2, Bin Luo, Ejaz Ahmed3, "SQL Database with physical database tuning technique and NoSQL graph database comparisons", 2019 IEEE 3rd Information Technology, Networking, Electronic and Automation Control Conference (ITNEC).
[19] Fatima Yassine1, Mamoun Adel Awad2, "Migrating from SQL to NOSQL Database: Practices and Analysis", 2018 International Conference on Innovations in Information Technology (IIT).
[20] Sunita1 Ghotiya2, Juhi Mandal3, Saravanakumar Kandasamy1, "Migration from relational to NoSQL database", 2017 IOP Conference Series: Materials Science and Engineering.
[21] Jitender Kumar1, Varsha Garg2, "Security analysis of unstructured data in NOSQL MongoDB database", 2017 International Conference on Computing and Communication Technologies for Smart Nation (IC3TSN).
[22] Cornelia Győrödi1, Robert Győrödi2, George Pecherle3, Andrada Olah4, "A comparative study: MongoDB vs. MySQL", 2015 13th International Conference on Engineering of Modern Electric Systems (EMES).
[23] Matthew Aslett: "451 Research delivers market sizing estimates for NoSQL, NewSQL and MySQL ecosystem” May 22nd, 2012
[24] Shiwei Yu: "ACID Properties in Distributed Databases", 20096
[25] Ryan Betts: “SQL Time-Tested and still flourishing”, VoltDB, Bedford.
[26] Jenny Richards, Advantages and Disadvantages of NoSQL databases – what you should know, Hadoop360, September 24, 2015,
[27] Venkat Gudivada, Dhana Rao and Vijay Raghavan: "NoSQL Systems for Big Data Management”, June 2014, Conference: 2014 IEEE World Congress on Services, At Anchorage, Alaska.
[28] A B M Moniruzzaman: "NewSQL: Towards Next Generation Scalable RDBMS for Online Transaction Processing (OLTP) for Big Data Management", Nov 2014.
[29] Hoff, Todd: "Google Spanner's Most Surprising Revelation: NoSQL is Out and NewSQL is In". Retrieved 2012-10-07.
[30] Stonebraker, Michael "NewSQL: An Alternative to NoSQL and Old SQL for New OLTP Apps". Communications of the ACM Blog. , 2012
[31] Vinay Jain "Rise of NewSQL". International Journal for Research in Emerging Science and Technology.
[32] Scholz, J.: Coping with Dynamic, Unstructured Data Sets – NoSQL: a Buzzwordor a Savior? In: Schrenk, M., Popovich, V.V., Zeile, P. Proc. REAL CORP 2011May, 1–9 (2011).
[33] Stonebraker, M. et al.: C-store: a Column-Oriented DBMS. In: Proc. 31st VLDBConference. pp. 553–564 (2005).
[34] Zaki, A.K.: NoSQL Databases?: New millenium database for big data, big users,cloud computing and its security challenges. 403–409 (2014).
[35] The Vertica RAnalytic Database Technical Overview White Paper (2010).
[36] Abadi, D. et al.: Integrating Compression and Execution in Column-Oriented Database Systems. In: Proc. 2006 ACM SIGMOD Int. Conf. Manag. data – SIG-MOD’06. pp. 671 (2006).
[37] Abadi, D.J. et al.: Column-Oriented Database Systems. In: Proc. VLDB ’09.pp. 1664–1665 (2009).
[38] Abadi, D.J., Madden, S.R.: Column-Stores vs. Row-Stores?: How Different Are They Really? In: SIGMOD’08. pp. 967–980 (2008).
[39] Angles, R., Gutierrez, C.: Survey of graph database models. ACM Comput. Surv.40(1), 1–39 (2008).
[40] Harizopoulos, S. et al.: Performance Tradeoffs in Read-Optimized Databases. In: Proc. VLDB Endowment. pp. 487–498 (2006).
[41] Kyurkchiev, H., Kaloyanova, K.: Performance Study of Analytical Queries of Oracleand Vertica. In: Proc. 7th ISGT Int. Conf. pp. 127 – 139 2013)
[42] Lamb, A. et al.: The Vertica Analytic Database?: C-Store 7 Years Later. In: Proc.VLDB Endowment. pp. 1790–1801 (2012).
[43] Mitreva, E., Kaloyanova, K.: NoSQL Solutions to Handle Big Data. In: Proc. Doc-toral Conference in MIE. pp. 77–86 (2013).
[44] Neil, B.O. et al.: The Star Schema Benchmark and Augmented Fact Table Indexing Outline of Talk. In: Nambiar, R., Poess, M. (eds.) Performance Evaluation and Benchmarking. LNCS, vol. 5895, pp. 237–252. Springer, Heidelberg (2009).
[45] Padhy, R.P. et al.: RDBMS to NoSQL: Reviewing some next-generation non-relational database’s. Int. J. Adv. Eng. Sci. Technol. 11, 15–30 (2011).
[46] Redmond, E., Wilson, J.R.: Seven Databases in Seven Weeks. The Pragmatic Book-shelf (2012).
Published
2023-02-23
How to Cite
Khan, M., Zaman, F., Adnan, M., Imroz, A., Rauf, M., & Phul, Z. (2023). Comparative Case Study: An Evaluation of Performance Computation between SQL and NoSQL Database. Journal of Software Engineering, 1(2), 14-23. Retrieved from http://sjhse.smiu.edu.pk/sjhse/index.php/SJHSE/article/view/42
Section
Articles
