| 一种可靠的数据仓库中ETL策略与架构设计 |
| |
| 引用本文： | 尤玉林,张宪民.一种可靠的数据仓库中ETL策略与架构设计[J].计算机工程与应用,2005,41(10):172-174,229. |
| |
| 作者姓名： | 尤玉林 张宪民 |
| |
| 作者单位： | 上海交通大学图像处理与模式识别研究所,上海,200030 |
| |
| 摘 要： | 作为数据仓库系统的关键部件,ETL完成数据抽取、清洗、转换和装载的工作,它是构建数据仓库的重要环节,同时也是构建数据仓库过程中出现问题最多的环节,所以针对这点,该文给出了一个可靠的同时易于扩展的ETL策略和架构。文章首先简单地介绍了数据仓库技术和ETL技术,包括ETL的相关概念、ETL在数据仓库中的功能和重要地位;然后重点介绍了这种ETL的具体策略和架构设计。
|
| 关 键 词： | 数据仓库 ETL 数据抽取 数据转换 数据清洗 数据装载 |
| 文章编号： | 1002-8331-(2005)10-0172-03 |
A Reliable Strategy and Design of Architecture of ETL in Data Warehouse |
| |
| You Yulin,Zhang Xianmin.A Reliable Strategy and Design of Architecture of ETL in Data Warehouse[J].Computer Engineering and Applications,2005,41(10):172-174,229. |
| |
| Authors: | You Yulin Zhang Xianmin |
| |
| Abstract: | As the key component in the data warehouse system,ETL supports the processing about data extracting,cleaning,transforming and loading.It is one of the most important steps in building the data warehouse,at the same time,there are a lot of bugs about ETL in building the data warehouse.To avoid those potential bugs,this paper puts forward a reliable and easily distensible strategy and architecture of ETL.This paper briefly introduces the technology of data warehouse and ETL,including the concepts related with data warehouse and ETL,ETL's functions and the important location in data warehouse system,and then it emphasizes the details about this strategy and design of architecture of ETL. |
| |
| Keywords: | data warehouse ETL data extract data transform data clean data loading |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
