作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2009, Vol. 35 ›› Issue (2): 39-41. doi: 10.3969/j.issn.1000-3428.2009.02.014

• 软件技术与数据库 • 上一篇    下一篇

数据仓库跨版本透明查询系统的设计

鲍 蓉   

  1. (徐州工程学院信电工程学院,徐州 221008)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2009-01-20 发布日期:2009-01-20

Design of Cross-versions Transparent Query System in Data Warehouse

BAO Rong   

  1. (Department of Information & Electronic Engineering, Xuzhou Institute of Technology, Xuzhou 221008)
  • Received:1900-01-01 Revised:1900-01-01 Online:2009-01-20 Published:2009-01-20

摘要: 针对传统数据仓库系统中多维模式进化历史的挥发性问题,提出用版本元数据来记录数据仓库进化过程中的每一种多维模式状态,给出版本元数据结构,设计了跨版本透明查询系统及相应的查询算法。查询分解算法将用户基于一种模式结构提出的查询请求分解为在各个数据仓库版本上计算的子查询,集成算法将子查询结果进行必要的汇总和转换。

关键词: 数据仓库, 模式进化, 模式版本, 透明查询

Abstract: Aiming at the volatility of schema evolution histories in traditional data warehouse system, this paper proposes an idea that using version metadata keeps the multidimensional schemas history. In this paper, version metadata structure has been presented. Cross-versions transparent query system and corresponding algorithms are designed. The query split algorithm decomposes the query command proposed on one schema into several sub-queries on data warehouse versions, and the integration algorithm integrates the results of sub-queries by necessary gather and transform.

Key words: data warehouse, schema evolution, schema version, transparent query

中图分类号: