互联网 qkzz.net
全刊杂志网:首页 > 女性 > 文章正文
刊社推荐

基于结构图的ETL过程建模方法


□ 张忠平 赵瑞珍

   (燕山大学 信息科学与工程学院 计算机应用技术系, 河北 秦皇岛 066004)

  

  摘要:ETL是数据仓库获得高质量数据的重要环节,在数据仓库建设过程中占有极其重要的地位。为了便于ETL过程的设计、维护和修改,提出一种基于结构图的ETL过程建模方法,并依据该方法完成了ETL概念模型的设计。通过图形化ETL过程中的元素和关联,该模型清晰直观地反映了数据的来源和流向、源数据与目标数据之间的映射和转换关系,辅助设计人员更好地进行ETL过程的设计和ETL过程的编码实现,使整个ETL设计过程更加方便、灵活。

  关键词:数据仓库; 抽取转换加载; 结构图; 模型

  中图分类号:TP311文献标志码:A

  文章编号:1001-3695(2008)11-3354-03

  

  Architecture graph-based approach for modeling ETL process

  

  ZHANG Zhong-ping, ZHAO Rui-zhen

  

  (Dept. of Computer Application Technology, College of Information Science & Engineering, Yanshan University, Qinhuangdao Hebei 066004, China)

  

  Abstract:ETL is an important part for the data warehouse to gain data with high quality, and it plays a key role in building the data warehouse system. The paper proposed a methodology for modeling ETL process based on an architecture graph, with the goal of facilitating the designment, maintenance and modification of the ETL process. On the basis of this modeling approach, the paper completed the design of ETL conceptual model. By representing the elements and relationships of the ETL process diagrammatically, it expressed the data’s coming and going, as well as their mapping and transformation relationships clearly and intuitively. It also supported the ETL designer to design the ETL process and develope the code efficiently, and improved the flexibility and reliability of the ETL process designment greatly.

......
很抱歉,暂无全文,若需要阅读全文或喜欢本刊物请联系《计算机应用研究》杂志社购买。
欢迎作者提供全文,请点击编辑
分享:
 

了解更多资讯,请关注“木兰百花园”
分享:
 
精彩图文


关键字
支持中国杂志产业发展,请购买、订阅纸质杂志,欢迎杂志社提供过刊、样刊及电子版。
关于我们 | 网站声明 | 刊社管理 | 网站地图 | 联系方式 | 中图分类法 | RSS 2.0订阅 | IP查询
全刊杂志赏析网 2017