En prestandajämförelse av databashanteringssystem över olika workloads
2022 (svensk)Independent thesis Basic level (degree of Bachelor), 20 poäng / 30 hp
OppgaveAlternativ tittel
A performance comparison of database management systems across different workloads (engelsk)
Abstract [en]
This study conducted an experiment on NoSQL and NewSQL database management systems where the average throughput of Cassandra, CockroachDB, MongoDB, and VoltDB was compared using five workloads composed of different proportions of read and update queries. How much these different workload compositions affect throughput for each individual database management system was also investigated.
The results showed that VoltDB had the highest throughput overall, and its throughput was affected the least by the workloads’ composition. MongoDB had similar high throughput consistency across workloads but at a much lower throughput level, and its throughput was affected much more by the workload compositions than VoltDB. Cassandra had extremely high throughput for 100 percent update workloads,even beating VoltDB in certain cases, but showed underwhelming results for all other workloads. CockroachDB’s throughput was by far the worst at workloads that had any update queries, but was comparable and sometimes even better than Cassandra and MongoDB with 100 percent read workloads. CockroachDB’s throughput proved to be the most affected by the query composition of workloads.
sted, utgiver, år, opplag, sider
2022. , s. 44
Emneord [en]
Database, benchmarking, performance, NoSQL, NewSQL, throughput, Cassandra, CockroachDB, MongoDB, VoltDB
HSV kategori
Identifikatorer
URN: urn:nbn:se:his:diva-21372OAI: oai:DiVA.org:his-21372DiVA, id: diva2:1675058
Fag / kurs
Informationsteknologi
Utdanningsprogram
Computer Science - Specialization in Systems Development
Veileder
Examiner
2022-06-222022-06-222022-06-22bibliografisk kontrollert