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

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