Performance Analysis of NoSQL and Relational Databases with CouchDB and MySQL for Application’s Data Storage

Applied Sciences - Tập 10 Số 23 - Trang 8524
Cornelia Győrödi1, Diana V. Dumşe-Burescu2, Doina Zmaranda1, Robert Győrödi1, Gianina Gabor1, George Pecherle1
1Department of Computer Science and Information Technology, University of Oradea, 410087 Oradea, Romania
2Faculty of Electrical Engineering and Information Technology, Department of Computer Science and Information Technology, University of Oradea, 410087 Oradea, Romania

Tóm tắt

In the current context of emerging several types of database systems (relational and non-relational), choosing the type and database system for storing large amounts of data in today’s big data applications has become an important challenge. In this paper, we aimed to provide a comparative evaluation of two popular open-source database management systems (DBMSs): MySQL as a relational DBMS and, more recently, as a non-relational DBMS, and CouchDB as a non-relational DBMS. This comparison was based on performance evaluation of CRUD (CREATE, READ, UPDATE, DELETE) operations for different amounts of data to show how these two databases could be modeled and used in an application and highlight the differences in the response time and complexity. The main objective of the paper was to make a comparative analysis of the impact that each specific DBMS has on application performance when carrying out CRUD requests. To perform the analysis and to ensure the consistency of tests, two similar applications were developed in Java, one using MySQL and the other one using CouchDB database; these applications were further used to evaluate the time responses for each database technology on the same CRUD operations on the database. Finally, a comprehensive discussion based on the results of the analysis was performed that centered on the results obtained and several conclusions were revealed. Advantages and drawbacks for each DBMS are outlined to support a decision for choosing a specific type of DBMS that could be used in a big data application.

Từ khóa


Tài liệu tham khảo

Kumawat, 2016, Correlation of NOSQL & SQL Database, IOSR J. Comput. Eng. (IOSR-JCE), 18, 70

Drake, M. (2019, August 09). A Comparison of NoSQL Database Management Systems and Models. Available online: https://www.digitalocean.com/community/tutorials/a-comparison-of-nosql-database-management-systems-and-models.

Truica, C.O., Radulescu, F., Boicea, A., and Bucur, I. (2015, January 27–29). Performance Evaluation for CRUD Operations in Asynchronously Replicated Document Oriented Database. Proceedings of the 20th International Conference on Control Systems and Computer Science, Bucharest, Romania.

Feuerstein, S., and Pribyl, B. (2016). Oracle PL/SQL Programming, 6th Revised ed., O’Reilly Media.

Gupta, S., and Rani, R. (2020, July 14). Data Transformation and Query Analysis of Elasticsearch and CouchDB Document Oriented Databases. Available online: http://hdl.handle.net/10266/4215.

Azarmi, B. (2016). Early Big Data with NoSQL. Scalable Big Data Architecture, Apress.

Meier, A., and Kaufmann, M. (2019). SQL & NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management, Springer Vieweg.

Anderson, J.C., Lehnardt, J., and Slater, N. (2010). CouchDB: The Definitive Guide, O’Reilly Media. [1st ed.].

Näsholm, P. (2012). Extracting Data from NoSQL Databases. A Step Towards Interactive Visual Analysis of NoSQL Data. [Master’s Thesis, Chalmers University of Technology, University of Gothenburg].

Eyada, 2020, Performance Evaluation of IoT Data Management Using MongoDB Versus MySQL Databases in Different Cloud Environments, IEEE Access, 8, 110656, 10.1109/ACCESS.2020.3002164

Bicevska, 2017, Towards NoSQL-based data warehouse solutions, Proc. Comput. Sci., 104, 104111, 10.1016/j.procs.2017.01.080

Li, 2019, An integration approach of hybrid databases based on SQL in cloud computing environment, Softw. Pract. Exp., 49, 401, 10.1002/spe.2666

Sotoc, 2015, A comparative study of relational and non-relational database models in a Web-based application, IJACSA, 6, 7883

Seda, P., Hosek, J., Masek, P., and Pokorny, J. (2018, January 22–25). Performance Testing of NoSQL and RDBMS for Storing Big Data in e-Applications. Proceedings of the 3rd International Conference on Intelligent Green Building and Smart Grid (IGBSG), Yi-Lan, Taiwan.

(2020, June 14). IntelliJ Idea Application. Available online: https://www.jetbrains.com/idea/.

(2019, November 17). MySQL Workbench: SQL Development. Available online: https://www.mysql.com/products/workbench/.

(2020, June 14). MySql Java Connector Library. Available online: https://mvnrepository.com/artifact/mysql/mysql-connector-java.

(2020, June 14). Ektorp Library. Available online: https://mvnrepository.com/artifact/org.ektorp/org.ektorp.

(2020, June 13). A Guide to OkHttp. Available online: https://www.baeldung.com/guide-to-okhttp.

Thông tin
Thông tin xuất bản

Applied Sciences

Tập 10 Số 23

8524

Thông tin tác giả