Comparative analysis of the performance of selected database management system
Currently, in the era of large amounts of generated data, a significant challenge is fast data processing. The aim of the article is to conduct a comparative analysis of the performance of relational and non-relational databases using MS SQL Server, MongoDB, and CouchDB as examples. The comparison...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Lublin University of Technology
2024-06-01
|
| Series: | Journal of Computer Sciences Institute |
| Subjects: | |
| Online Access: | https://ph.pollub.pl/index.php/jcsi/article/view/5927 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1832570007813357568 |
|---|---|
| author | Piotr Marcin Tracz Małgorzata Plechawska-Wójcik |
| author_facet | Piotr Marcin Tracz Małgorzata Plechawska-Wójcik |
| author_sort | Piotr Marcin Tracz |
| collection | DOAJ |
| description |
Currently, in the era of large amounts of generated data, a significant challenge is fast data processing. The aim of the article is to conduct a comparative analysis of the performance of relational and non-relational databases using MS SQL Server, MongoDB, and CouchDB as examples. The comparison was carried out based on developed research scenarios designed to examine the execution time of CRUD operations. A performance ranking of databases was established based on the obtained results, with SQL Server taking the first place, MongoDB the second, and CouchDB the third. For the operations of deletion, downloading, and updating of data, MS SQL Server proved to be the most efficient database. Only in the operation of inserting data did MongoDB turn out to be the most efficient database.
|
| format | Article |
| id | doaj-art-778b8c09b8654b5bb4e7363cf441311b |
| institution | Kabale University |
| issn | 2544-0764 |
| language | English |
| publishDate | 2024-06-01 |
| publisher | Lublin University of Technology |
| record_format | Article |
| series | Journal of Computer Sciences Institute |
| spelling | doaj-art-778b8c09b8654b5bb4e7363cf441311b2025-02-02T18:01:29ZengLublin University of TechnologyJournal of Computer Sciences Institute2544-07642024-06-013110.35784/jcsi.5927Comparative analysis of the performance of selected database management systemPiotr Marcin Tracz0Małgorzata Plechawska-Wójcik1Lublin University of TechnologyLublin University of Technology Currently, in the era of large amounts of generated data, a significant challenge is fast data processing. The aim of the article is to conduct a comparative analysis of the performance of relational and non-relational databases using MS SQL Server, MongoDB, and CouchDB as examples. The comparison was carried out based on developed research scenarios designed to examine the execution time of CRUD operations. A performance ranking of databases was established based on the obtained results, with SQL Server taking the first place, MongoDB the second, and CouchDB the third. For the operations of deletion, downloading, and updating of data, MS SQL Server proved to be the most efficient database. Only in the operation of inserting data did MongoDB turn out to be the most efficient database. https://ph.pollub.pl/index.php/jcsi/article/view/5927database management systemnon-relational databasesrelational databasesperformance |
| spellingShingle | Piotr Marcin Tracz Małgorzata Plechawska-Wójcik Comparative analysis of the performance of selected database management system Journal of Computer Sciences Institute database management system non-relational databases relational databases performance |
| title | Comparative analysis of the performance of selected database management system |
| title_full | Comparative analysis of the performance of selected database management system |
| title_fullStr | Comparative analysis of the performance of selected database management system |
| title_full_unstemmed | Comparative analysis of the performance of selected database management system |
| title_short | Comparative analysis of the performance of selected database management system |
| title_sort | comparative analysis of the performance of selected database management system |
| topic | database management system non-relational databases relational databases performance |
| url | https://ph.pollub.pl/index.php/jcsi/article/view/5927 |
| work_keys_str_mv | AT piotrmarcintracz comparativeanalysisoftheperformanceofselecteddatabasemanagementsystem AT małgorzataplechawskawojcik comparativeanalysisoftheperformanceofselecteddatabasemanagementsystem |