{"id":{"repo_id":"vilnius","oai_identifier":"oai:vu.lt:elaba:308336502"},"canonical_url":"https://search.ndltd.org/etd/vilnius/oai:vu.lt:elaba:308336502","repository":{"repo_id":"vilnius","name":"Vilnius University","base_url":"https://epublications.vu.lt/oai"},"display":{"title":"Didelių duomenų skaidymo našumo analizė rakto - reikšmės ir reliacinėse duomenų bazėse /","abstract":"This bachelor's thesis presents a comparative performance analysis of horizontal database sharding using a relational PostgreSQL system (with the Citus extension) and a key-value Redis Cluster system. The study employs a shopping cart management scenario simulating high-throughput e-commerce workloads in a Docker-containerised environment. Experimental results demonstrated that Redis Cluster achieved nearly three times higher average throughput (2475,41~req/s) compared to PostgreSQL (841.60~req/s) and maintained stability up to 2,000 concurrent users. However, a fundamental difference in reliability was observed between the two systems: PostgreSQL guaranteed 100% data integrity, while Redis Cluster recorded an error rate of 1.53% due to rejected ACID transactions. The thesis concludes that Redis Cluster is superior for maximum throughput, whereas PostgreSQL remains the necessary choice for systems where absolute data reliability is the priority.","abstract_html":"This bachelor&#x27;s thesis presents a comparative performance analysis of horizontal database sharding using a relational PostgreSQL system (with the Citus extension) and a key-value Redis Cluster system. The study employs a shopping cart management scenario simulating high-throughput e-commerce workloads in a Docker-containerised environment. Experimental results demonstrated that Redis Cluster achieved nearly three times higher average throughput (2475,41~req/s) compared to PostgreSQL (841.60~req/s) and maintained stability up to 2,000 concurrent users. However, a fundamental difference in reliability was observed between the two systems: PostgreSQL guaranteed 100% data integrity, while Redis Cluster recorded an error rate of 1.53% due to rejected ACID transactions. The thesis concludes that Redis Cluster is superior for maximum throughput, whereas PostgreSQL remains the necessary choice for systems where absolute data reliability is the priority.","abstract_has_math":false,"creators":["Černovas, Dominykas,"],"institution":"Institutional Repository of Vilnius University","degree_name":null,"degree_level":null,"degree_discipline":null,"degree_department":null,"school":null,"contributors":[],"advisors":[],"committee_chairs":[],"committee_members":[],"year":2026,"date_issued":"2026","date_published":"2026","updated_at":"2026-11-19T10:12:59Z","subjects":[],"languages":["lit"],"rights":["info:eu-repo/semantics/openAccess"],"rights_urls":[],"identifier_entries":[],"person_identifier_entries":[]},"links":{"outbound_url":"https://repository.vu.lt/VU:ELABAETD308336502&prefLang=en_US","outbound_label":"Repository record","outbound_source":"dc:identifier","record_url":"https://repository.vu.lt/VU:ELABAETD308336502&prefLang=en_US","record_label":"Repository record","record_kind":"record","record_source":"dc:identifier","download_url":null,"download_label":null,"download_source":null,"access_status":"open","embargo_until":null,"access_note":null},"source_record":{"url":"https://epublications.vu.lt/oai?verb=GetRecord&metadataPrefix=oai_dc&identifier=oai%3Avu.lt%3Aelaba%3A308336502","prefix":"oai_dc"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:creator","label":"Author","values":["Černovas, Dominykas,"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date","label":"Dc Date","values":["2026"]},{"key":"dc:publisher","label":"Institution","values":["Institutional Repository of Vilnius University"]},{"key":"dc:relation","label":"Dc Relation","values":["https://epublications.vu.lt/object/elaba:308336502/308336502.pdf"]},{"key":"dc:type","label":"Dc Type","values":["info:eu-repo/semantics/bachelorThesis"]}]},{"id":"language_rights","label":"Language and Rights","entries":[{"key":"dc:language","label":"Dc Language","values":["lit"]},{"key":"dc:rights","label":"Dc Rights","values":["info:eu-repo/semantics/openAccess"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["https://repository.vu.lt/VU:ELABAETD308336502&prefLang=en_US"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description","label":"Description","values":["This bachelor's thesis presents a comparative performance analysis of horizontal database sharding using a relational PostgreSQL system (with the Citus extension) and a key-value Redis Cluster system. The study employs a shopping cart management scenario simulating high-throughput e-commerce workloads in a Docker-containerised environment. Experimental results demonstrated that Redis Cluster achieved nearly three times higher average throughput (2475,41~req/s) compared to PostgreSQL (841.60~req/s) and maintained stability up to 2,000 concurrent users. However, a fundamental difference in reliability was observed between the two systems: PostgreSQL guaranteed 100% data integrity, while Redis Cluster recorded an error rate of 1.53% due to rejected ACID transactions. The thesis concludes that Redis Cluster is superior for maximum throughput, whereas PostgreSQL remains the necessary choice for systems where absolute data reliability is the priority."]},{"key":"dc:format","label":"Dc Format","values":["application/pdf"]},{"key":"dc:title","label":"Title","values":["Didelių duomenų skaidymo našumo analizė rakto - reikšmės ir reliacinėse duomenų bazėse /","A sharding performance comparison in key-value and relational databases."]}]}],"canonical_facts":{"dc:creator":["Černovas, Dominykas,"],"dc:date":["2026"],"dc:description":["This bachelor's thesis presents a comparative performance analysis of horizontal database sharding using a relational PostgreSQL system (with the Citus extension) and a key-value Redis Cluster system. The study employs a shopping cart management scenario simulating high-throughput e-commerce workloads in a Docker-containerised environment. Experimental results demonstrated that Redis Cluster achieved nearly three times higher average throughput (2475,41~req/s) compared to PostgreSQL (841.60~req/s) and maintained stability up to 2,000 concurrent users. However, a fundamental difference in reliability was observed between the two systems: PostgreSQL guaranteed 100% data integrity, while Redis Cluster recorded an error rate of 1.53% due to rejected ACID transactions. The thesis concludes that Redis Cluster is superior for maximum throughput, whereas PostgreSQL remains the necessary choice for systems where absolute data reliability is the priority."],"dc:format":["application/pdf"],"dc:identifier":["https://repository.vu.lt/VU:ELABAETD308336502&prefLang=en_US"],"dc:language":["lit"],"dc:publisher":["Institutional Repository of Vilnius University"],"dc:relation":["https://epublications.vu.lt/object/elaba:308336502/308336502.pdf"],"dc:rights":["info:eu-repo/semantics/openAccess"],"dc:title":["Didelių duomenų skaidymo našumo analizė rakto - reikšmės ir reliacinėse duomenų bazėse /","A sharding performance comparison in key-value and relational databases."],"dc:type":["info:eu-repo/semantics/bachelorThesis"]},"updated_at":"2026-11-19T10:12:59Z"}