Please wait a minute...
New Technology of Library and Information Service  2011, Vol. 27 Issue (1): 88-93    DOI: 10.11925/infotech.1003-3513.2011.01.14
article Current Issue | Archive | Adv Search |
CWM-based ETL Metadata System Model Design
Zhou Jing1, Zhao Ying1, Yang Xin2
1. Public Administration School,Sichuan University,Chengdu 610064, China;
2. Chongqing Rural Commercial Bank, Chongqing 400020, China
Download:
Export: BibTeX | EndNote (RIS)      
Abstract  

In order to prevent and control the existing mismanagement problems in ETL, and ensure the efficient implementation of the data warehouse, the paper designs CWM-based ETL metadata system model. This model can describe the specific steps of data transform, and the specific modules are designed according to this model design system, thus the process of ETL management can be achieved effectively.

Key wordsCWM      ETL      Metadata      Data warehouse     
Received: 22 November 2010      Published: 12 February 2011
: 

TP392

 

Cite this article:

Zhou Jing, Zhao Ying, Yang Xin. CWM-based ETL Metadata System Model Design. New Technology of Library and Information Service, 2011, 27(1): 88-93.

URL:

https://manu44.magtech.com.cn/Jwk_infotech_wk3/EN/10.11925/infotech.1003-3513.2011.01.14     OR     https://manu44.magtech.com.cn/Jwk_infotech_wk3/EN/Y2011/V27/I1/88


[1] 曹志伟.支持ETL进化的元数据管理与应用. 北京:对外经济贸易大学, 2006.

[2] 胡细平.全过程元数据驱动的实时BI基础平台研究
[J]. 图书馆学研究 ,2010(22):10-16.

[3] 赵晓非.ETL工具的元数据集成与管理研究
[J]. 武汉理工大学学报 ,2010,32(16):115-118.

[4] 高晓东,汪恒杰,胡大斌.基于CWM的多数据源协同平台设计与实现
[J]. 控制工程 ,2006,13(5):485-487.

[5] 郑洪源,周良.基于CWM的标准ETL的设计与实现
[J]. 吉林大学学报:信息科学版 ,2006,24(1):50-54.

[6] 雷启明.基于CWM的商场数据仓库ETL系统架构研究
[J]. 商场现代化 ,2008(26):39-40.

[7] 程跟上,郑洪源,丁秋林.一种标准的ETL的设计思想及其实现
[J]. 计算机应用研究 ,2005,22(3):101-103.

[8] Poole J, Chang D, Tollert D,et al. Common Warehouse Metamodel Developer’s Guide
[M]. New York: John Wiley & Sons Inc, 2003:69-72.

[9] OMG(Object Management Group). Common Warehouse Metamodel (CWM) Specification. Version 1.1
[S]. Object Management Group, Inc., Needham, MA,March 2003.

[10] 程跟上. 基于公共仓库模型的ETL系统研究与实现. 南京:南京航空航天大学, 2005: 18-19.

[11] Mazón J N, Trujillo J. An MDA Approach for the Development of Data Warehuses
[J].Decision Support Systems, 2008,45(1):41-58.

[12] 刘丽娟. 基于CWM的ETL元数据管理系统研究与实现. 西安:西北大学, 2008.

[1] Chang Zhijun,Qian Li,Xie Jing,Wu Zhenxin,Zhang Hu,Yu Qianqian,Wang Ying,Wang Yongji. Big Data Platform for Sci-Tech Literature Based on Distributed Technology[J]. 数据分析与知识发现, 2021, 5(3): 69-77.
[2] Shen Zhihong,Zhao Zihao,Wang Haibo. Big Data Technology Stack Shifting: From SQL Centric to Graph Centric[J]. 数据分析与知识发现, 2020, 4(7): 50-65.
[3] Xuhui Li,Tao Yu,Ting Li,Yiwen Li,Jinguang Gu. An Evolutionary Schema for Metadata Description[J]. 数据分析与知识发现, 2020, 4(1): 76-88.
[4] Jinzhu Zhang,Yiming Hu. Extracting Titles from Scientific References in Patents with Fusion of Representation Learning and Machine Learning[J]. 数据分析与知识发现, 2019, 3(5): 68-76.
[5] Jiang Lin,Wang Dongbo. Automatically Detecting and Tagging Foreign Language Citation Metadata[J]. 数据分析与知识发现, 2017, 1(1): 47-54.
[6] Qianqian Yu,Jianyong Zhang. Practices of NSTL Integrating and Using Third-party Metadata[J]. 现代图书情报技术, 2016, 32(1): 97-102.
[7] Zhai Dongsheng, Cai Liwei, Zhang Jie, Feng Xiuzhen. The Study of Patent Data Warehouse-based Technical Efficiency Map Mining Method——Taking 3D Printing Technology as an Example[J]. 现代图书情报技术, 2015, 31(7-8): 131-138.
[8] Liu Feng, Zhang Xiaolin. Review on the Scientific Metadata Standards and Research on Its Generic Design[J]. 现代图书情报技术, 2015, 31(12): 3-12.
[9] Wang Hui, Michael Witt, Dou Tianfang. Purdue University Research Repository and Scientific Data Management Services Based on PURR[J]. 现代图书情报技术, 2015, 31(1): 9-16.
[10] Tan Xueqing, He Shan. Research Review on Music Personalized Recommendation System[J]. 现代图书情报技术, 2014, 30(9): 22-32.
[11] Dong Kun. Research of Personalized Book Recommender System of University Library Based on Collaborative Filter[J]. 现代图书情报技术, 2011, (11): 44-47.
[12] Cheng Yanyan. Comparative Research on International Electronic Records Metadata Packaging Methods—VEO and METS[J]. 现代图书情报技术, 2011, 27(10): 7-11.
[13] Zhai Dongsheng, He Wenhui. Design and Implementation of Data Integration over Heterogeneous Patent Sources[J]. 现代图书情报技术, 2010, 26(9): 67-73.
[14] Shen Yunyun, Xiao Long, Feng Ying. Study on General Metadata Application Rules for Digital Library[J]. 现代图书情报技术, 2010, 26(12): 1-8.
[15] Zhang Chunhong, Tang Yong, Shao Ke. Digitalization Standards and the Applications of Objects Resources[J]. 现代图书情报技术, 2010, 26(12): 9-14.
  Copyright © 2016 Data Analysis and Knowledge Discovery   Tel/Fax:(010)82626611-6626,82624938   E-mail:jishu@mail.las.ac.cn