Skip to Main content Skip to Navigation
Conference papers

Towards application-specific query processing systems

Abstract : Database systems use query processing subsystems for enabling efficient query-based data retrieval. An essential aspect of designing any query-intensive application is tuning the query system to fit the application's requirements and workload characteristics. However, the configuration parameters provided by traditional database systems do not cover the design decisions and trade-offs that arise from the geo-distribution of users and data. In this paper, we present a vision towards a new type of query system architecture that addresses this challenge by enabling query systems to be designed and deployed in a per use case basis. We propose a distributed abstraction called Query Processing Unit that encapsulates primitive query processing tasks, and show how it can be used as a building block for assembling query systems. Using this approach, application architects can construct query systems specialized to their use cases, by controlling the query system's architecture and the placement of its state. We demonstrate the expressiveness of this approach by applying it to the design of a query system that can flexibly place its state in the data center or at the edge, and show that state placement decisions affect the trade-off between query response time and query result freshness.
Complete list of metadata

https://hal.archives-ouvertes.fr/hal-02943380
Contributor : Dimitrios Vasilas <>
Submitted on : Monday, September 21, 2020 - 9:36:10 AM
Last modification on : Tuesday, March 23, 2021 - 9:28:03 AM
Long-term archiving on: : Thursday, December 3, 2020 - 1:30:09 PM

Files

double-column.pdf
Files produced by the author(s)

Identifiers

  • HAL Id : hal-02943380, version 1
  • ARXIV : 2009.09671

Citation

Dimitrios Vasilas, Marc Shapiro, Bradley King, Sara Hamouda. Towards application-specific query processing systems. BDA 2020 - 36ème Conférence sur la Gestion de Données – Principes, Technologies et Applications, Oct 2020, Paris / Virtual, France. ⟨hal-02943380⟩

Share

Metrics

Record views

91

Files downloads

64