当前位置: X-MOL 学术arXiv.cs.IR › 论文详情
Our official English website, www.x-mol.net, welcomes your feedback! (Note: you will need to create a separate account there.)
Towards application-specific query processing systems
arXiv - CS - Information Retrieval Pub Date : 2020-09-21 , DOI: arxiv-2009.09671
Dimitrios Vasilas (DELYS, SU), Marc Shapiro (DELYS, SU), Bradley King, Sara Hamouda (DELYS, SU)

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.

中文翻译:

面向特定应用的查询处理系统

数据库系统使用查询处理子系统来实现基于查询的高效数据检索。设计任何查询密集型应用程序的一个重要方面是调整查询系统以适应应用程序的要求和工作负载特征。然而,传统数据库系统提供的配置参数并未涵盖由用户和数据的地理分布引起的设计决策和权衡。在本文中,我们提出了一种新型查询系统架构的愿景,该架构通过支持在每个用例的基础上设计和部署查询系统来解决这一挑战。我们提出了一种称为查询处理单元的分布式抽象,它封装了原始查询处理任务,并展示了如何将其用作组装查询系统的构建块。使用这种方法,应用程序架构师可以通过控制查询系统的架构及其状态的位置来构建专门针对其用例的查询系统。我们通过将其应用于可以灵活地将其状态放置在数据中心或边缘的查询系统的设计来证明这种方法的表现力,并表明状态放置决策会影响查询响应时间和查询结果之间的权衡新鲜。
更新日期:2020-09-22
down
wechat
bug