一种构造数据仓库的基本时间轮转模型

在分析数据仓库建立的一般方法基础上,提出了一种用于构建数据仓库的基本时间轮转模型·介绍了基本时间轮转机制的概念及实现原理,分析了时间轮转模型的特征;结合具体实例,详细描述了基于粗时间集的基本时间轮转模型构造方法及基于该模型基础上的相关行为·实践证明,与传统的数据仓库构造策略比较,时间轮转机制可有效保证数据汇总的幂等性,并对联机分析处理、数据挖掘和决策支持系统具有更好的可用性,在数据抽取效率、数据存储效力和系统构造便利性等方面也有较大提高·

Basic Time Rotation Model Used for Constructing Data Warehouse

Analyzing some conventional ways to construct data warehouse, a new time rotation model that can be used to construct data warehouse is developed. The concept and implementation principle of basic time rotation mechanism are introduced and characteristics of this model are analyzed. The method of constructing a basic time rotation model based on rough time set and related operations are also described in detail with its application exemplified. Compared with conventional DW construction strategies, the time rotation mechanism can provide efficiently the idempotency for data totaling and is more serviceable for on-line analytical processing, data mining and decision supporting system. The data extraction efficiency, data storage efficacy and operation convenience of DW constructed using the time rotation model will be improved obviously.