首页> 外文会议>International conference on very large databases >Offering a Precision-Performance Tradeoff for Aggregation Queries over Replicated Data
【24h】

Offering a Precision-Performance Tradeoff for Aggregation Queries over Replicated Data

机译:为复制数据提供精密性能权限,用于聚合查询

获取原文

摘要

Strict consistency of replicated data is infeasible or not required by many distributed applications, so current systems often permit stale replication, in which cached copies of data values are allowed to become out of date. Queries over cached data return an answer quickly, but the stale answer may be unboundedly imprecise. Alternatively, queries over remote master data return a precise answer, but with potentially poor performance. To bridge the gap between these two extremes, we propose a new class of replication systems called TRAPP (Tradeoff in Replication Precision and Performance). TRAPP systems give each user fine-grained con5trol over the trade-off between precision and performance: Caches store ranges that are guaranteed to bound the current data values, instead of storing stale exact values. Users supply a quantitative precision constraint along with each query. To answer a query, TRAPP systems automatically select a combination of locally cached bounds and exact master data stored remotely to deliver a bounded answer consisting of a range that is no wider than the specified precision constraint, that is guaranteed to contain the precise answer, and that is computed as quicly as possible. This paper defines the architecture of TRAPP replication systems and covers some mechanics of caching data ranges. It then focuses on queries with aggregation, presenting optimization algorithms for answering queries with precision constraints, and reporting on performance experiments that demonstrate the fine-grained control of the precision-performance tradeoff offered by TRAPP systems.
机译:许多分布式应用程序的严格一致性是不可行的,因此,许多分布式应用程序不需要,因此当前系统通常允许陈旧的复制,其中允许数据值缓存的数据值副本变为日期。通过缓存数据查询快速返回答案,但陈旧的答案可能是不合适的。或者,对远程主数据的查询返回精确的答案,但具有潜在的性能差。为了弥合这两个极端之间的差距,我们提出了一类名为Trapp的新类复制系统(复制精度和性能的权衡)。 Trapp Systems在精度和性能之间的权衡中为每个用户提供细粒度的Con5Trol:缓存存储范围,保证绑定当前数据值,而不是存储陈旧的精确值。用户提供定量精度约束以及每个查询。为了回答查询,TRAPP系统会自动选择存储器远程存储的本地缓存界限和精确主数据的组合,以提供由不宽的范围组成的界限答案,该范围是保证包含精确答案的规定的精度约束。这可以尽可能地计算。本文定义了Trapp复制系统的体系结构,涵盖了缓存数据范围的一些机制。然后,它专注于具有聚合的查询,提出了用于应答有精确约束的查询的优化算法,并报告演示Trapp系统提供的精密性能权衡的细粒度控制的性能实验。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号