Institutional Repository of Vilnius University
Skaidymo metodų vertinimas skirtingiems duomenų bazių tipams /
Abstract
dc:descriptionThis thesis presents a systematic, empirical comparison of two horizontal sharding strategies—hash-based and range-based—implemented in PostgreSQL with the Citus extension and in MongoDB. Using a multi-tenant Point-of-Sale data schema and a uniform Docker/OpenNebula environment, the authors defined clear performance, consistency, and throughput criteria and executed extensive Apache JMeter load tests (CRUD and burst-load scenarios) across single-node and sharded clusters. Results demonstrate that range-based sharding consistently delivers lower 95th-percentile response times, higher query‐per‐second rates, and minimal error rates under both steady and spiking loads, while hash-based sharding offers strong load balancing for isolated operations. Accordingly, the paper provides data-driven guidelines for selecting the appropriate sharding method based on query patterns and system requirements.
Degree
thesis:*- Grantor dc:publisher
- Institutional Repository of Vilnius University
- Year dc:date
- 2025
Author and committee
dc:creator, dc:contributor.*- Author dc:creator
-
- Zagzin, Anton,
Rights
dc:rights- Statement dc:rights
-
- info:eu-repo/semantics/openAccess
- Language dc:language
- lit
Identifiers
dc:identifier.*- Repository record dc:identifier
- https://repository.vu.lt/VU:ELABAETD239032757&prefLang=en_US