Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Computer Applications and Software》 2009-01
Add to Favorite Get Latest Update

STUDY AND DESIGN OF ETL BASED ON TELECOM DATA WAREHOUSE

Li Ying Hao Kegang Ge Wei(Institute of Software Engineering,Northwest University,Xi'an 710127,Shaanxi,China)  
Most companies in telecom industry have built their own data warehouse,and the most important process in building data warehouse is ETL.This paper introduces the design and part realization of an ETL system of data warehouse for a provincial telecom company based on the analysis of existing ETL system.The whole ETL system process can be edited by XML format,and realizes partial graphical interactive interface.To the character of the massive data in telecom system,the paper presents an approach for optimizing and improving the ETL capability which raises the efficiency.
【CateGory Index】: TP311.52
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【References】
Chinese Journal Full-text Database 4 Hits
1 CHE Yan-jing1,ZHANG Yue-qing2,HAN Xian-zhong1 (1.College of Information Science and Technology,Agricultural University of Hebei,Baoding 071001,China;2.Journal Publishing Department,Agricultural University of Hebei,Baoding 071001,China);Design and Realization of Transformation function in ETL[J];Journal of Agricultural University of Hebei;2010-03
2 Wang Rui1,Chen Li2(1.China Mobile Group Guangdong Co.,Ltd.,Guangzhou 510623,China;2.Department of Computer Engineering,Guangdong Communication Polytechnic,Guangzhou 510650,China);Building Method of Massive Data Warehouses Supporting Real-Time Queries in Telecom Industry[J];Telecommunications Science;2011-10
3 ZHANG Jun,GHEN Hong-gang (College of Computer Information and Science,Southwest University,Chongqing 400715,China);Research on real-time ETL system model based on multi-Agent[J];Information Technology;2010-02
4 ZHANG Qin-he,LI Min(Kunming University of Science and Technology,Yunnan Kunming,650093,China);Design and Implementation of ETL Strategy in Tele-Communication Based on Teradata Data Warehouse[J];Manufacture Information Engineering of China;2012-13
【Co-citations】
Chinese Journal Full-text Database 10 Hits
1 Yuan Man,Chen Xingtong(School of Computer and Information Technology,Northeast Petroleum University,Daqing 163318,P.R.China);Data Mapping Algorithm Between Heterogeneous Data Sources Based on Metadata-Driven[J];Journal of Northeast Forestry University;2011-12
2 REN Qing-dong,LI Tian-yang,YUAN Man,XU Han-wen(College of Computer and Information Technology,Northeast Petroleum University,Daqing,Heilongjiang 163318,China);Generalized data migration tool based on metadata-driven[J];Journal of Daqing Petroleum Institute;2011-01
3 XU Yue-Lin(Development of Mechano-electronic Engineering,Suzhou Institute of Industrial Technology,Suzhou Jiangsu 215104,China);Design Exploration of ETL Process of Data Warehouse System[J];Development & Innovation of Machinery & Electrical Products;2010-06
4 ZHANG Wen-feng2,PENG Hong1,XIE Fang-yong2,LIU Zhen-yu2(1.School of Computer Science and Engineering,South China University of Technology,Guangzhou 510640;2.School of Computer Software,South China University of Technology,Guangzhou 510006,China);On the Data Warehousing Techniques Introduced in Bank Credit Assessment Management Systems[J];Computer Engineering & Science;2009-06
5 Wu Junyong Guo Fuliang (Dept.of Information and Electric, Navy University of Engineering,Wuhan 430033);Research on Method of Data Warehouse Data Transformation[J];Computer & Digital Engineering;2004-06
6 CHEN Xian,CHEN Song-qiao (College of Information Science & Engineering,Central South University,Changsha Hunan 410083,China);Design and Implementation of General ETL Tool Based on Data Warehouse[J];Application Research of Computers;2004-08
7 MU Qing CHEN Song-qiao (School of Information Science & Engineering,Central South University,Changsha 410083,China);Designing and realization of security and auditing technique in exchange platform based on heterogeneous data's integrated and collecting[J];Application Research of Computers;2007-09
8 Qin Delin1 Wang Airong1 Chen Cheng2 Lin Zhijie3 Xiong Yun3 Zhu Yangyong3 1(Shanghai Medical Insurance Information Center,Shanghai 200040,China) 2(Wonders Information Co.,LTD.,Shanghai 201112,China) 3(School of Computer Science,Fudan University,Shanghai 200433,China);DESIGN AND IMPLEMENTATION OF A MEDICAL INSURANCE FUND RISK PREVENTION AND CONTROL DATA WAREHOUSE[J];Computer Applications and Software;2011-07
9 ZHOU Maowei, DENG Su*, HUANG Hongbin;An ETL Tool Design and Realization Based on Metadata[J];Science Technology and Engineering;2006-21
10 CONG Hui-gang,REN Qing-dong,LI Tian-yang,YUAN Man(College of Computer and Information Technology,Northeast Petroleum University,Daqing 163318,P.R.China);Implementation of Large Database Migration Tool Based on Metadata-driven[J];Science Technology and Engineering;2011-10
China Proceedings of conference Full-text Database 1 Hits
1 ;Research on ETL Development Methodology in Distributed Application System[A];[C];2005
【Co-references】
Chinese Journal Full-text Database 10 Hits
1 Liu Feng Jia Duo Li Xiaoli Xi Guozhu Yong lin(College of Physics and Electrpnic Enginering,Northwest Normal University,Lanzhou 730070,Gansu,China);Method of normalization[J];Journal of Anshun University;2008-03
2 Zhao Ruxing~(1,2) (1.North China University of Technology,Beijing 100041,China; 2.BeijingJing Polytechnic College,Beijing 100042,China);Using Data Mining Techniques to Establish Supporting System for Teaching Decision-making[J];Journal of Beijing Polytechnic College;2009-01
3 DENG Zhihong TANG Shiwei ZHANG Ming YANG Dongqing CHEN Jie (Department of Computer Science and Technology,National Laboratory on Machine Perception,Peking University,Beijing,100871);Overview of Ontology[J];Acta Scicentiarum Naturalum Universitis Pekinesis;2002-05
4 ZHANG Jing1,CHEN Xi-lai2(1.Network Center,Panzhihua University,Panzhihua 617000,China;2.College of Computers,UESTC,Chengdu 610054,China);Application of data integration of multi-source heterogeneous[J];Journal of Chengdu University of Information Technology;2009-03
5 HUANG De\|gen 1,2 , ZHU He\|he 2, WANG Kun\|lun 2, YANG Yuan\|sheng 2, ZHONG Wan\|xie 1 ( 1. Res. Inst. of Eng. Mech., Dalian Univ. of Technol., Dalian 116024, China; 2. Dept. of Comput. Sci. and Eng., Dalian Univ. of Technol., Dalian;Chinese automatic words segmentation based on maximum matching and second\|maximum matching[J];JOURNAL OF DALIAN UNIVERSITY OF TECHNOLOGY;1999-06
6 ;Research on the Technology of Predicting Customers Loss in Mobile Communication Industry[J];Computer Development & Applications;2005-10
7 ;Research on Heterogeneous Data Exchange based on XML[J];Computer Development & Applications;2010-08
8 GAO Chun-ying1,LU Jie1,CHEN Yan-xia2(1.Electronic Engineering Institute of the PLA, Hefei 230037,China;2.63880 Unit of the PLA, Luoyang 471003,China);Study of Technology Applied to Heterogeneous Database Integration Based on XML[J];Computer Knowledge and Technology;2006-05
9 LI Jin(Shanxi Unicom,Xi'an 710075,China);The Application of Data Mining Technology in Telecommunication Company[J];Computer Knowledge and Technology;2006-05
10 GUAN Li-juan (Zhanjiang Normal College,Zhanjiang 524048,China);Development and Prospect of Data ETL[J];Computer Knowledge and Technology(Academic Exchange);2007-06
【Secondary References】
Chinese Journal Full-text Database 10 Hits
1 Liu Yang(College of Mechanical Engineering,Beijing Institute of Petro-chemical Technology,Beijing 102617,China);Design and Implementation of Management System for Graduate Employment Information Based on B/S Model[J];Journal of Beijing Institute of Petro-Chemical Technology;2010-04
2 Cheng Lili (Taizhou Vocational and Technical College,Taizhou 318000,Zhejiang);Research on the Decision Support System of Network Shops Based on Data Warehouse[J];Computer & Telecommunication;2012-05
3 Pan Jun1,Cheng Jianhe2(1.Institute of Information Security,Wenzhou University,Wenzhou 325035,China; 2.Wenzhou Branch of China Telecom Co.,Ltd.,Wenzhou 325001,China);Design and Implementation of General-Purpose Data Service Platform for Telecom Company[J];Telecommunications Science;2013-02
4 PENG Bing,LUO Wei(Chenzhou Vocational Technology College,Chenzhou 423000,China);Research on the Application of Data Warehouse in Higher Vocational Colleges Students' Information Management Sys tem[J];Computer Knowledge and Technology;2013-04
5 Zhang Yafei;Yan Dong;Branch Four, China International Telecommunication Construction Group Design Institute Co., Ltd.;27th Institute, China Electronics Technology Group Corporation;;Design and Study of Data Application Sub-Layer of Smart Pipe System[J];Telecommunications Science;2013-09
6 YAO Zhiwei(Shihezi University Library,Shihezi 832003);Design of Information Support System in Xinjiang Constructing Station Troops[J];Agriculture Network Information;2011-06
7 LIU Shu-juan1,YUE Peng2(1.College of Computer and Information Science,Southwest University,Chongqing 400715,China;2.College of Telecommunications & Information Engineering,Chongqing University of Posts and Telecommunications,Chongqing 400065,China);Application of Data Warehouse and OLAP in Preference Data Analysis on Communication Line State Statistics[J];Computer and Modernization;2012-02
8 LIU Hong-ting(Lianyungang Technology College,Lianyungang 222006);Decision System Design on College Teaching Affairs Based on Data Warehouse[J];Journal of Lianyungang Technical College;2011-04
9 LI Shengze,HE Dingxiu,FAN Mingming(Dongguan Polytechnic Institute,Dongguan 523808,China);Study on Performance Evaluation Software of Financial Investment in S&T Based on Objective Weighting Method[J];Science and Technology Management Research;2013-11
10 LI Jingsuo;ZHAO Zhijun;Chinese Academy of Agricultural Sciences,Institute of Agricultural Economics and Development;;Study on the Factors Affecting the Performance of National Science and Technology Support Programs in Agriculture Field—Empirical Research Based on the Principal Components Analytic Method[J];Science and Technology Management Research;2015-20
【Secondary Citations】
Chinese Journal Full-text Database 10 Hits
1 Wu Jianqin Wu Jianlin Zhang Lei(Telecommunication Software Engineering Centre of Computer Science College of BUPT,Beijing100876);Design of Data Warehouse Architecture Based on CWM[J];Computer Engineering and Applications;2002-21
2 Xu Lizhen Liu An Dong Yisheng(Department of Computer Science and Engineering,Southeast University,Nanjing210096);Metadata Management for Data Warehouse[J];Computer Engineering and Applications;2002-24
3 Zhang Ning 1 Jia Ziyan 2 Shi Zhongzhi 21 (Graduate College,University of Science and Technology of China,Beijing100039) 2 (The Key Laboratory of Intelligent Information Processing,Institute of Computing Technology,Chinese Academy of Sciences,Beijing100080);Research on Technology of ETL in Data Warehouse[J];Computer Engineering and Applications;2002-24
4 Deng Shasha Chen Songqiao(Information Science and Engineering College of Central-South University,Changsha 410083);Research on Metadata Based on Model of Heterogeneous Data Extracting and Cleaning[J];Computer Engineering and Applications;2004-30
5 CHEN Yue-Guo WANG Jing-Chun (Department of Automation, Tsinghua University, Beijing 100084);A Review of Data Integration[J];Computer Science;2004-05
6 ZHONG Hua FENG Wen-Lan TAN Hong-Xing HUANG Tao (Key Laboratory of Computer Science,Institute oI Software,The Chinese Academy of Sciences, Bejing 100080) (Technology Center of Software Engineering,Institute of Software,The Chinese Academy of Sciences, Bejing 100080);Design and Implementation of ETL System for Data Integration[J];Computer Science;2004-09
7 LEI Qi NING Hong LI Shan-Shan WANG Chang-Jian(School of Computer,National University of Defense Technology,Changsha 410073);Research on Metadata Management System Based on CWM[J];Computer Science;2004-10
8 WANG Qiang,LIU Dongbo,WANG Jianxin (Institute of China Electronic System Engineering Company,Beijing 100039);Research on the Metadata Standard of Datawarehousing[J];Computer Engineering;2002-12
9 ZHANG Yingchao, DENG Su, ZHANG Weiming (Department of Management Science and Engineering,National University of Defense Technology, Changsha 410073);Research on Metadata Management of Data Warehouse[J];Computer Engineering;2003-01
10 XIAO Wan-xian,LIU Jiang-ning (School of Computer Science,National University of Defense Technology,Changsha 410073,China);Research on the Model of Enterprise Data Integration[J];Computer Engineering & Science;2004-05
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved