...
  • 主题
高级搜索  >
历史搜索 清空历史
首页> 外文期刊>Frontiers of computer science >Incremental join view maintenance on distributed log-structured storage
【24h】

Incremental join view maintenance on distributed log-structured storage

机译：增量连接在分布式日志结构存储上的维护

获取原文
获取原文并翻译 | 示例
           
页面导航
  • 摘要
  • 著录项
  • 相似文献
  • 相关主题

摘要

Modern database systems desperate for the ability to support highly scalable transactions and efficient queries simultaneously for real-time applications. One solution is to utilize query optimization techniques on the on-line transaction processing (OLTP) systems. The materialized view is considered as a panacea to decrease query latency. However, it also involves the significant cost of maintenance which trades away transaction performance. In this paper, we examine the design space and conclude several design features for the implementation of a view on a distributed log-structured merge-tree (LSM-tree), which is a well-known structure for improving data write performance. As a result, we develop two incremental view maintenance (IVM) approaches on LSM-tree. One avoids join computation in view maintenance transactions. Another with two optimizations is proposed to decouple the view maintenance with the transaction process. Under the asynchronous update, we also provide consistency queries for views. Experiments on TPC-H benchmark show our methods achieve better performance than straightforward methods on different workloads.
机译：现代数据库系统绝望的是能够为实时应用程序同时支持高度可扩展的事务和高效查询。一种解决方案是利用在线交易处理（OLTP）系统上的查询优化技术。物化视图被认为是减少查询延迟的灵割。但是，它还涉及贸易交易表现的大量维护成本。在本文中，我们检查了设计空间，并在分布式日志结构合并树（LSM树）上的视图结束了几个设计特征，这是一种众所周知的结构，用于提高数据写性能。因此，我们在LSM树上开发了两个增量视图维护（IVM）方法。一个避免在查看维护交易中加入计算。提出了另外两个优化，以通过交易过程将视图维护分离。在异步更新下，我们还提供了视图的一致性查询。 TPC-H基准的实验表明我们的方法比不同工作负载的直接方法实现了更好的性能。

著录项

相似文献

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

客服邮箱：kefu@zhangqiaokeyan.com

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

  • 客服微信

  • 服务号