Work

Fragment Allocations for Partially Replicated Databases Considering Data Modifications and Changing Workloads

Year: 2024

Type: conference-paper

Abstract: Columnar database systems can process complex mixed workloads on a single node. In case of increasing and peak analytical processing demand, we can offload read-only queries to replicas. Partial replication, i.e., duplicating only data subsets to additional nodes, is more cost-efficient than full replication for two primary reasons: (i) Partial replicas require less storage and can be set up faster. (ii) Partial replicas must synchronize only stored data subsets, allowing better scalability. However, determining which queries to offload is challenging for larger workloads because queries access overlapping data subsets and cause synchronization costs.

Source: ACM International Conference on Information and Knowledge Management (CIKM)

DOI: 10.1145/3627673.3679767

Authors: Stefan Halfpap, Rainer Schlosser

Institutions: Berlin Institute for the Foundations of Learning and Data, Technische Universität Berlin, Hasso Plattner Institute

Language: English

Topic: Advanced Database Systems and Queries

Subfield: Computer Networks and Communications

Field: Computer Science

Domain: Physical Sciences

Open Access status: hybrid

OpenAlex ID: W4403582696

FWCI:

Cites: 31

Cited by:

Related to: 10