Back to Search
Start Over
Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases
- Source :
- Applied Sciences, Volume 11, Issue 15, Applied Sciences, Vol 11, Iss 6794, p 6794 (2021)
- Publication Year :
- 2021
- Publisher :
- Multidisciplinary Digital Publishing Institute, 2021.
-
Abstract
- 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<br />based on these, a detailed analysis and several conclusions are presented to support a decision for choosing a specific approach.
- Subjects :
- Technology
Java
QH301-705.5
Computer science
Relational database
QC1-999
database management system (DBMS)
02 engineering and technology
CRUD operations
document-based MySQL
computer.software_genre
NoSQL
Relational database management system
relational MySQL
020204 information systems
0202 electrical engineering, electronic engineering, information engineering
General Materials Science
Biology (General)
Architecture
QD1-999
Instrumentation
computer.programming_language
Fluid Flow and Transfer Processes
Data processing
Database
Physics
Process Chemistry and Technology
General Engineering
Response time
InformationSystems_DATABASEMANAGEMENT
020207 software engineering
relational
Engineering (General). Civil engineering (General)
Computer Science Applications
Chemistry
TA1-2040
Performance improvement
computer
Subjects
Details
- Language :
- English
- ISSN :
- 20763417
- Database :
- OpenAIRE
- Journal :
- Applied Sciences
- Accession number :
- edsair.doi.dedup.....a6b0199a7c22f4ac16b1b09d70725086
- Full Text :
- https://doi.org/10.3390/app11156794