Back to search

Institutional Repository of Vilnius University

Skaidymo metodų vertinimas skirtingiems duomenų bazių tipams /

Abstract

dc:description

This 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.*

Chain of custody

source
Harvested from
Vilnius University
Base URL
epublications.vu.lt/oai
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
related terms
citation

Zagzin, Anton,. Skaidymo metodų vertinimas skirtingiems duomenų bazių tipams /. Institutional Repository of Vilnius University, 2025. https://repository.vu.lt/VU:ELABAETD239032757&prefLang=en_US