{"id":{"repo_id":"vilnius","oai_identifier":"oai:vu.lt:elaba:308335960"},"canonical_url":"https://search.ndltd.org/etd/vilnius/oai:vu.lt:elaba:308335960","repository":{"repo_id":"vilnius","name":"Vilnius University","base_url":"https://epublications.vu.lt/oai"},"display":{"title":"Duomenų skaidymo efektyvumo palyginimas „PostgreSQL Citus” ir „Apache Cassandra” duomenų bazių valdymo sistemose /","abstract":"This work analyzes the data sharding efficiency in PostgreSQL Citus and Apache Cassandra database management systems. The theoretical analysis uncovers architectural differences between relational and widecolumn models, distributed system architectures, data structures utilised by DBMS, as well as their respective sharding methods. The practical evaluation was conducted using a customdesigned experimental orchestration framework combining the Yahoo! Cloud Serving Benchmark (YCSB) and DigitalOcean cloud technologies. The empirical research revealed that Cassandra achieved on average about 2.5–3 times higher throughput (up to 19 times higher for range queries) and 2 to 4 times lower latency compared to PostgreSQL Citus, handled write operations more effectively (data loading was about 13 times faster), and maintained better availability during network topology changes. Conversely, while both systems showed degraded performance during range queries, PostgreSQL Citus demonstrated significantly faster (about 6 times) data rebalancing when adding new nodes to the cluster, though with a more noticeable throughput drop during the process.","abstract_html":"This work analyzes the data sharding efficiency in PostgreSQL Citus and Apache Cassandra database management systems. The theoretical analysis uncovers architectural differences between relational and widecolumn models, distributed system architectures, data structures utilised by DBMS, as well as their respective sharding methods. The practical evaluation was conducted using a customdesigned experimental orchestration framework combining the Yahoo! Cloud Serving Benchmark (YCSB) and DigitalOcean cloud technologies. The empirical research revealed that Cassandra achieved on average about 2.5–3 times higher throughput (up to 19 times higher for range queries) and 2 to 4 times lower latency compared to PostgreSQL Citus, handled write operations more effectively (data loading was about 13 times faster), and maintained better availability during network topology changes. Conversely, while both systems showed degraded performance during range queries, PostgreSQL Citus demonstrated significantly faster (about 6 times) data rebalancing when adding new nodes to the cluster, though with a more noticeable throughput drop during the process.","abstract_has_math":false,"creators":["Arelis, Konstantinas,"],"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:ELABAETD308335960&prefLang=en_US","outbound_label":"Repository record","outbound_source":"dc:identifier","record_url":"https://repository.vu.lt/VU:ELABAETD308335960&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%3A308335960","prefix":"oai_dc"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:creator","label":"Author","values":["Arelis, Konstantinas,"]}]},{"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:308335960/308335960.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:ELABAETD308335960&prefLang=en_US"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description","label":"Description","values":["This work analyzes the data sharding efficiency in PostgreSQL Citus and Apache Cassandra database management systems. The theoretical analysis uncovers architectural differences between relational and widecolumn models, distributed system architectures, data structures utilised by DBMS, as well as their respective sharding methods. The practical evaluation was conducted using a customdesigned experimental orchestration framework combining the Yahoo! Cloud Serving Benchmark (YCSB) and DigitalOcean cloud technologies. The empirical research revealed that Cassandra achieved on average about 2.5–3 times higher throughput (up to 19 times higher for range queries) and 2 to 4 times lower latency compared to PostgreSQL Citus, handled write operations more effectively (data loading was about 13 times faster), and maintained better availability during network topology changes. Conversely, while both systems showed degraded performance during range queries, PostgreSQL Citus demonstrated significantly faster (about 6 times) data rebalancing when adding new nodes to the cluster, though with a more noticeable throughput drop during the process."]},{"key":"dc:format","label":"Dc Format","values":["application/pdf"]},{"key":"dc:title","label":"Title","values":["Duomenų skaidymo efektyvumo palyginimas „PostgreSQL Citus” ir „Apache Cassandra” duomenų bazių valdymo sistemose /","Comparison of data sharding efficiency in postgresql citus and apache cassandra database management systems."]}]}],"canonical_facts":{"dc:creator":["Arelis, Konstantinas,"],"dc:date":["2026"],"dc:description":["This work analyzes the data sharding efficiency in PostgreSQL Citus and Apache Cassandra database management systems. The theoretical analysis uncovers architectural differences between relational and widecolumn models, distributed system architectures, data structures utilised by DBMS, as well as their respective sharding methods. The practical evaluation was conducted using a customdesigned experimental orchestration framework combining the Yahoo! Cloud Serving Benchmark (YCSB) and DigitalOcean cloud technologies. The empirical research revealed that Cassandra achieved on average about 2.5–3 times higher throughput (up to 19 times higher for range queries) and 2 to 4 times lower latency compared to PostgreSQL Citus, handled write operations more effectively (data loading was about 13 times faster), and maintained better availability during network topology changes. Conversely, while both systems showed degraded performance during range queries, PostgreSQL Citus demonstrated significantly faster (about 6 times) data rebalancing when adding new nodes to the cluster, though with a more noticeable throughput drop during the process."],"dc:format":["application/pdf"],"dc:identifier":["https://repository.vu.lt/VU:ELABAETD308335960&prefLang=en_US"],"dc:language":["lit"],"dc:publisher":["Institutional Repository of Vilnius University"],"dc:relation":["https://epublications.vu.lt/object/elaba:308335960/308335960.pdf"],"dc:rights":["info:eu-repo/semantics/openAccess"],"dc:title":["Duomenų skaidymo efektyvumo palyginimas „PostgreSQL Citus” ir „Apache Cassandra” duomenų bazių valdymo sistemose /","Comparison of data sharding efficiency in postgresql citus and apache cassandra database management systems."],"dc:type":["info:eu-repo/semantics/bachelorThesis"]},"updated_at":"2026-11-19T10:12:59Z"}