• 主题
高级搜索  >
历史搜索 清空历史
首页> 外文会议>British National Conference on Databases(BNCOD 23); 20060718-23; Belfast(GB) >Efficient Update of Data Warehouse Views with Generalised Referential Integrity Differential Files
【24h】

Efficient Update of Data Warehouse Views with Generalised Referential Integrity Differential Files

机译：使用广义参照完整性差异文件高效更新数据仓库视图

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

摘要

Data warehouse (DW) views provide an efficient access to information integrated from source data. When changes are made to the source data, the corresponding views may be outdated. Thus, the maintenance of DW views is crucial for the currency of information. Recently, a method was proposed to use referential integrity differential files (RIDFs) to self-maintain DW views that contain select-project-joins over relations modelled in a star schema. However, it is not uncommon for applications to have relations that are modelled in other schemas such as a snowflake schema or a galaxy schema. In this paper, we generalise the concept of RIDFs; we propose a method that uses generalised RIDFs to self-maintain the DW views that contain joins over relations modelled in the star schema as well as non-star schemas. Our method computes new views by using only the old materialised views and files that keep the truly relevant tuples in the "delta". Consequently, it avoids accessing the underlying source data, and hence leads to efficient update of DW views.
机译：数据仓库（DW）视图提供对从源数据集成的信息的有效访问。当对源数据进行更改时，相应的视图可能已过时。因此，维护DW视图对于信息的流通至关重要。最近，有人提出了一种使用参照完整性差异文件（RIDF）来自我维护DW视图的方法，该DW视图包含在星型模式中建模的关系上的select-project-joins。但是，应用程序具有在其他模式（例如雪花模式或星系模式）中建模的关系并不少见。在本文中，我们概括了RIDF的概念。我们提出了一种使用广义RIDF来自我维护DW视图的方法，该视图包含星型和非星型中建模的关系的联接。我们的方法仅使用旧的实例化视图和文件将真正相关的元组保留在“增量”中，从而计算新视图。因此，它避免了访问底层的源数据，从而导致DW视图的有效更新。

著录项

相似文献

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

客服邮箱：kefu@zhangqiaokeyan.com

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

  • 客服微信

  • 服务号