• 主题
高级搜索  >
历史搜索 清空历史
首页> 外文会议>Knowledge-Based Systems for Safety Critical Applications >A comparison of three methods for join view maintenance in parallel RDBMS
【24h】

A comparison of three methods for join view maintenance in parallel RDBMS

机译：并行RDBMS中维护联接视图的三种方法的比较

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

摘要

In a typical data warehouse, materialized views are used to speed up query execution. Upon updates to the base relations in the warehouse, these materialized views must also be maintained. The need to maintain these materialized views can have a negative impact on performance that is exacerbated in parallel RDBMSs, since simple single-node updates to base relations can give rise to expensive all-node operations for materialized view maintenance. We present a comparison of three materialized join view maintenance methods in a parallel RDBMS, which we refer to as the naive, auxiliary relation, and global index methods. The last two methods improve performance at the cost of using more space. The results of this study show that the method of choice depends on the environment, in particular, the update activity on base relations and the amount of available storage space.
机译：在典型的数据仓库中，实例化视图用于加速查询执行。在更新仓库中的基本关系时，还必须维护这些物化视图。维护这些实例化视图的需求可能会对并行RDBMS中加剧的性能产生负面影响，因为对基本关系进行简单的单节点更新可能会增加用于实例化视图维护的昂贵的全节点操作。我们对并行RDBMS中的三种实例化联接视图维护方法进行了比较，我们将它们称为朴素，辅助关系和全局索引方法。后两种方法以占用更多空间为代价来提高性能。这项研究的结果表明，选择方法取决于环境，尤其是基于基本关系的更新活动和可用存储空间的数量。

著录项

相似文献

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

客服邮箱：kefu@zhangqiaokeyan.com

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

  • 客服微信

  • 服务号