| 元数据驱动ETL的研究 |
| |
| 引用本文： | 宿芳,寿永熙,苏依拉.元数据驱动ETL的研究[J].计算机工程与应用,2012,48(6):114-118,125. |
| |
| 作者姓名： | 宿芳 寿永熙 苏依拉 |
| |
| 作者单位： | 内蒙古工业大学信息工程学院,呼和浩特,010051 |
| |
| 基金项目： | 内蒙古自然科学基金（No.20080404MS0904）. |
| |
| 摘 要： | 对原始数据的提取、转换、加载(ETL)是数据仓库开发的重要步骤。一个稳定而可靠的ETL系统取决于它的总体设计。在原有ETL基础上,提出了元数据驱动ETL的思想,利用包引擎和SQL引擎以及相关算法,对传统ETL的方法进行改进,目的是提高ETL系统的稳定性和可靠性,使用户通过对元数据的维护来控制ETL的执行过程。
|
| 关 键 词： | 抽取、转换和加载(ETL) 数据仓库 元数据 SQL引擎 包引擎 |
Research on metadata driven ETL |
| |
| SU Fang
,
SHOU Yongxi
,
SU Yila.Research on metadata driven ETL[J].Computer Engineering and Applications,2012,48(6):114-118,125. |
| |
| Authors: | SU Fang SHOU Yongxi SU Yila |
| |
| Affiliation: | College of Information Engineering, Inner Mongolia University of Technology, Hohhot 010051, China |
| |
| Abstract: | With the development of data warehouse, ETL（Extract, Transformation and Load） are so important steps in processing data while building a data warehouse. A stable and reliable ETL system is depended on the overall design. Base on the traditional ETL, this paper is mainly about metadata driven ETL. Using SQL engine, package engine and related algorithm to solve the problem, the aim is to improve the ETL System＇ s stability and reliability, and enable users to control the process by maintaining metadata. |
| |
| Keywords: | Extract Transformation and Load（ETL） data warehouse metadata SQL engine package engine |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
