数据仓库数据加载技术

Data Loading Technology of Data Warehouse

数据仓库中的数据不是传统数据库中数据的简单堆积 ,其数据的组织必须方便基于数据仓库基础之上的数据挖掘和商业智能工作 ,为决策者提供访问、分析及共享信息的能力 ,从而发挥数据仓库的真正功效。成功构造一个数据仓库的关键在于自始至终理解用户需要 ,紧紧围绕用户目标这一主题进行数据的搜集和存储。首先分析数据仓库的特点以及拥有的数据类别及组成 ,重点介绍如何从现有数据库中有效地将数据引导至数据仓库的方法和策略 ,具体给出了数据仓库中

Data warehouse is not the simply data accumulation of operational database. For exerting the function of data warehouse, the construction of data warehouse should be convenient for the data mining and business intelligent work, supply information access, analyze, and share for decision maker. The key to constructing a successful data warehouse is to fully understand the demand of end users from beginning to the end, search and storage data surround users motive closely. This paper first analyzes the data warehouse characteristic and the sort of data component, emphasizes in effective data loading methods and strategies from operational database to data warehouse, gives five sorts data loading methods.