Interface Design and Development of ETL in the Telecommunications Business Data Warehouse Plat Form

Abstract:

. This paper describes the design of the telecommunications data warehouse interface part and development process of the ETL. Use of the data warehouse organization and storage method, carry on data analysis and business decisions effectively for the telecommunications services.The interface mainly undertakes the tasks is standardizing transfer mode of data among the various production systems. ETL's process is the key of the whole data warehouse. In the Text, described in detail for Its function framework and software deployment, and according to the data interface specification to describe the Interface environment configuration. Through the establishment of this platform, the data of the Production systems can be harmonized. And provide a strong background support for development and display of the front, benefit the policy-making level more accurate grasp development situation of the enterprise.

• Periodical: Applied Mechanics and Materials (Volumes 513-517)
• Pages: 2236-2239
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.513-517.2236
• Online since: February 2014
• Authors: He Gu*, Yao Hong Zhao
• Keywords: Data Warehouse, Extraction Transformation Loading (ETL), Interface Design, Norms

References

[1] INMONW H. DataWarehouse [M]. 3rd ed. Beijing: ChinaMachine Press, (2003).

[2] MIAO Jia-jia, DENG Su, LIU Qing-bao. Overview on ETL Technology [J]. ComputerEngineering, 2004, 30 (3): 4-5, 21.

[3] WU Jian. Research and Design ofETL in Data Integration Platform [D]. Beijing: North China Electric PowerUniversity, (2007).

[4] Han Jia-wei MICHELINE KAMBER. DataMining Concepts and Techniques [M]. Beijin: ChinaMachine Press, (2001).

[5] INMONW H. Building the DataWarehouse [M]. Beijing: ChinaMachine Press, (2003).

[6] Zhao Shuang-ru. i Research and Implementation of a Universal ETL Tool [D]. Xi an: Xi , an University of Technology, (2007).