首页> 外文会议>Twenty-Seventh International Conference on Very Large Data Bases, 27th, Sep 11-14th, 2001, Roma, Italy >Aggregate Maintenance for Data Warehousing in Informix Red Brick~(~R) Vista~(TM)
【24h】

Aggregate Maintenance for Data Warehousing in Informix Red Brick~(~R) Vista~(TM)

机译:Informix Red Brick〜(〜R)Vista〜(TM)中数据仓库的总体维护

获取原文
获取原文并翻译 | 示例

摘要

Dramatic performance gains can be realized in decision support DBMSs by leveraging pre-computed aggregates (i.e., materialized aggregate views). Informix Red Brick Vista provides a comprehensive solution for aggregate computation and management in data warehousing environments through the effective use of precomputed aggregates. Vista's transparent rewrite, advisor, and maintenance components allow users to maximize the benefits of precomputed aggregates while minimizing the costs associated with creating and maintaining them. In this paper, we provide an overview of Vista's maintenance subsystem. We describe optimizations used to make maintenance highly efficient, and discuss how Vista's focus on star schemas and data warehousing environments influenced the maintenance subsystem.
机译:通过利用预先计算的聚合(即物化聚合视图),可以在决策支持DBMS中实现显着的性能提升。 Informix Red Brick Vista通过有效使用预先计算的聚合为数据仓库环境中的聚合计算和管理提供了全面的解决方案。 Vista的透明重写,顾问程序和维护组件使用户能够最大程度地发挥预计算聚合的优势,同时将与创建和维护聚合相关的成本降至最低。在本文中,我们提供了Vista维护子系统的概述。我们将介绍用于提高维护效率的优化方法,并讨论Vista对星型架构和数据仓库环境的关注如何影响维护子系统。

著录项

相似文献

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

客服邮箱:kefu@zhangqiaokeyan.com

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

  • 服务号