Performance comparison of the most popular relational and non-relational database management systems
Context. Database is an essential part of any software product. With an emphasis on application performance, database efficiency becomes one of the key factors to analyze in the process of technology selection. With a development of new data models and storage technologies, the necessity for a compa...
Main Author: | |
---|---|
Format: | Others |
Language: | English |
Published: |
Blekinge Tekniska Högskola, Institutionen för programvaruteknik
2018
|
Subjects: | |
Online Access: | http://urn.kb.se/resolve?urn=urn:nbn:se:bth-16112 |
id |
ndltd-UPSALLA1-oai-DiVA.org-bth-16112 |
---|---|
record_format |
oai_dc |
spelling |
ndltd-UPSALLA1-oai-DiVA.org-bth-161122018-04-24T05:43:48ZPerformance comparison of the most popular relational and non-relational database management systemsengKolonko, KamilBlekinge Tekniska Högskola, Institutionen för programvaruteknik2018Software EngineeringProgramvaruteknikContext. Database is an essential part of any software product. With an emphasis on application performance, database efficiency becomes one of the key factors to analyze in the process of technology selection. With a development of new data models and storage technologies, the necessity for a comparison between relational and non-relational database engines is especially evident in the software engineering domain. Objectives. This thesis investigates current knowledge on database performance measurement methods, popularity of relational and non-relational database engines, defines characteristics of databases, approximates their average values and compares the performance of two selected database engines.Methods. In this study a number of research methods are used, including literature review, a review of Internet sources, and an experiment. Literature datasets used in the research incorporate over 100 sources including IEEE Xplore and ACM Digital Library. YCSB Benchmark was used as a direct performance comparison method in an experiment to compare OracleDB’s and MongoDB’s performance. Results. A list of database performance measurement methods has been defined as a result of the literature review. Two most popular database management engines, one relational and one non-relational has been identified. A set of database characteristics and a database performance comparison methodology has been identified. Performance of two selected database engines has been measured and compared. Conclusions. Performance comparison between two selected database engines indicated superior results for MongoDB under the experimental conditions. This database proved to be more efficient in terms of average operation latency and throughput for each of the measured workloads. OracleDB however, presented stable results in each of the category leaving the final choice of database to the specifics of a software engineering project. Activities required for the definition of database performance comparison methodology proved to be challenging and require study extension. Student thesisinfo:eu-repo/semantics/bachelorThesistexthttp://urn.kb.se/resolve?urn=urn:nbn:se:bth-16112application/pdfinfo:eu-repo/semantics/openAccess |
collection |
NDLTD |
language |
English |
format |
Others
|
sources |
NDLTD |
topic |
Software Engineering Programvaruteknik |
spellingShingle |
Software Engineering Programvaruteknik Kolonko, Kamil Performance comparison of the most popular relational and non-relational database management systems |
description |
Context. Database is an essential part of any software product. With an emphasis on application performance, database efficiency becomes one of the key factors to analyze in the process of technology selection. With a development of new data models and storage technologies, the necessity for a comparison between relational and non-relational database engines is especially evident in the software engineering domain. Objectives. This thesis investigates current knowledge on database performance measurement methods, popularity of relational and non-relational database engines, defines characteristics of databases, approximates their average values and compares the performance of two selected database engines.Methods. In this study a number of research methods are used, including literature review, a review of Internet sources, and an experiment. Literature datasets used in the research incorporate over 100 sources including IEEE Xplore and ACM Digital Library. YCSB Benchmark was used as a direct performance comparison method in an experiment to compare OracleDB’s and MongoDB’s performance. Results. A list of database performance measurement methods has been defined as a result of the literature review. Two most popular database management engines, one relational and one non-relational has been identified. A set of database characteristics and a database performance comparison methodology has been identified. Performance of two selected database engines has been measured and compared. Conclusions. Performance comparison between two selected database engines indicated superior results for MongoDB under the experimental conditions. This database proved to be more efficient in terms of average operation latency and throughput for each of the measured workloads. OracleDB however, presented stable results in each of the category leaving the final choice of database to the specifics of a software engineering project. Activities required for the definition of database performance comparison methodology proved to be challenging and require study extension. |
author |
Kolonko, Kamil |
author_facet |
Kolonko, Kamil |
author_sort |
Kolonko, Kamil |
title |
Performance comparison of the most popular relational and non-relational database management systems |
title_short |
Performance comparison of the most popular relational and non-relational database management systems |
title_full |
Performance comparison of the most popular relational and non-relational database management systems |
title_fullStr |
Performance comparison of the most popular relational and non-relational database management systems |
title_full_unstemmed |
Performance comparison of the most popular relational and non-relational database management systems |
title_sort |
performance comparison of the most popular relational and non-relational database management systems |
publisher |
Blekinge Tekniska Högskola, Institutionen för programvaruteknik |
publishDate |
2018 |
url |
http://urn.kb.se/resolve?urn=urn:nbn:se:bth-16112 |
work_keys_str_mv |
AT kolonkokamil performancecomparisonofthemostpopularrelationalandnonrelationaldatabasemanagementsystems |
_version_ |
1718632465859346432 |