Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases
Databases are an important part of today’s applications where large amounts of data need to be stored, processed, and accessed quickly. One of the important criteria when choosing to use a database technology is its data processing performance. In this paper, some methods for optimizing the database...
| Main Authors: | , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
MDPI AG
2021-07-01
|
| Series: | Applied Sciences |
| Subjects: | |
| Online Access: | https://www.mdpi.com/2076-3417/11/15/6794 |
| _version_ | 1827686748234186752 |
|---|---|
| author | Cornelia A. Győrödi Diana V. Dumşe-Burescu Robert Ş. Győrödi Doina R. Zmaranda Livia Bandici Daniela E. Popescu |
| author_facet | Cornelia A. Győrödi Diana V. Dumşe-Burescu Robert Ş. Győrödi Doina R. Zmaranda Livia Bandici Daniela E. Popescu |
| author_sort | Cornelia A. Győrödi |
| collection | DOAJ |
| description | Databases are an important part of today’s applications where large amounts of data need to be stored, processed, and accessed quickly. One of the important criteria when choosing to use a database technology is its data processing performance. In this paper, some methods for optimizing the database structure and queries were applied on two popular open-source database management systems: MySQL as a relational DBMS, and document-based MySQL as a non-relational DBMS. The main objective of this paper was to conduct a comparative analysis of the impact that the proposed optimization methods have on each specific DBMS when carrying out CRUD (CREATE, READ, UPDATE, DELETE) requests. To perform the analysis and performance evaluation of CRUD operations for different amounts of data, a case study testing architecture based on Java was developed and used to show how the databases’ proposed optimization methods can influence the performance of the application, and to highlight the differences in response time and complexity. The results obtained show the degree to which the proposed optimization methods contributed to the application’s performance improvement in the case of both databases; based on these, a detailed analysis and several conclusions are presented to support a decision for choosing a specific approach. |
| first_indexed | 2024-03-10T09:19:09Z |
| format | Article |
| id | doaj.art-becd9d7ed31f4b959c984f988774722a |
| institution | Directory Open Access Journal |
| issn | 2076-3417 |
| language | English |
| last_indexed | 2024-03-10T09:19:09Z |
| publishDate | 2021-07-01 |
| publisher | MDPI AG |
| record_format | Article |
| series | Applied Sciences |
| spelling | doaj.art-becd9d7ed31f4b959c984f988774722a2023-11-22T05:19:42ZengMDPI AGApplied Sciences2076-34172021-07-011115679410.3390/app11156794Performance Impact of Optimization Methods on MySQL Document-Based and Relational DatabasesCornelia A. Győrödi0Diana V. Dumşe-Burescu1Robert Ş. Győrödi2Doina R. Zmaranda3Livia Bandici4Daniela E. Popescu5Department of Computers and Information Technology, University of Oradea, 410087 Oradea, RomaniaFaculty of Electrical Engineering and Information Technology, University of Oradea, 410087 Oradea, RomaniaDepartment of Computers and Information Technology, University of Oradea, 410087 Oradea, RomaniaDepartment of Computers and Information Technology, University of Oradea, 410087 Oradea, RomaniaDepartment of Electrical Engineering, Faculty of Electrical Engineering and Information Technology, University of Oradea, 410087 Oradea, RomaniaDepartment of Computers and Information Technology, University of Oradea, 410087 Oradea, RomaniaDatabases are an important part of today’s applications where large amounts of data need to be stored, processed, and accessed quickly. One of the important criteria when choosing to use a database technology is its data processing performance. In this paper, some methods for optimizing the database structure and queries were applied on two popular open-source database management systems: MySQL as a relational DBMS, and document-based MySQL as a non-relational DBMS. The main objective of this paper was to conduct a comparative analysis of the impact that the proposed optimization methods have on each specific DBMS when carrying out CRUD (CREATE, READ, UPDATE, DELETE) requests. To perform the analysis and performance evaluation of CRUD operations for different amounts of data, a case study testing architecture based on Java was developed and used to show how the databases’ proposed optimization methods can influence the performance of the application, and to highlight the differences in response time and complexity. The results obtained show the degree to which the proposed optimization methods contributed to the application’s performance improvement in the case of both databases; based on these, a detailed analysis and several conclusions are presented to support a decision for choosing a specific approach.https://www.mdpi.com/2076-3417/11/15/6794database management system (DBMS)CRUD operationsNoSQLrelationaldocument-based MySQLrelational MySQL |
| spellingShingle | Cornelia A. Győrödi Diana V. Dumşe-Burescu Robert Ş. Győrödi Doina R. Zmaranda Livia Bandici Daniela E. Popescu Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases Applied Sciences database management system (DBMS) CRUD operations NoSQL relational document-based MySQL relational MySQL |
| title | Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases |
| title_full | Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases |
| title_fullStr | Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases |
| title_full_unstemmed | Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases |
| title_short | Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases |
| title_sort | performance impact of optimization methods on mysql document based and relational databases |
| topic | database management system (DBMS) CRUD operations NoSQL relational document-based MySQL relational MySQL |
| url | https://www.mdpi.com/2076-3417/11/15/6794 |
| work_keys_str_mv | AT corneliaagyorodi performanceimpactofoptimizationmethodsonmysqldocumentbasedandrelationaldatabases AT dianavdumseburescu performanceimpactofoptimizationmethodsonmysqldocumentbasedandrelationaldatabases AT robertsgyorodi performanceimpactofoptimizationmethodsonmysqldocumentbasedandrelationaldatabases AT doinarzmaranda performanceimpactofoptimizationmethodsonmysqldocumentbasedandrelationaldatabases AT liviabandici performanceimpactofoptimizationmethodsonmysqldocumentbasedandrelationaldatabases AT danielaepopescu performanceimpactofoptimizationmethodsonmysqldocumentbasedandrelationaldatabases |