Design And Realization Of The Shaanxi Telecom Integrated Data Warehouse Platform

With the rapid update of telecommunications technology development, facing increasingly fierce competition in the overall telecommunications market, telecommunications companies on information technology has set a higher request IT support systems for telecommunications companies gradually integrated business system, functions to deal with professional, business resource sharing and centralized platform, unified management and effective support for precision management system, support from the traditional telecom business operator to integrated information service providers in transition. Building an integrated data warehouse platform, will be stored in different information support system for business data integration, and follow a unified enterprise data model to carry out the washing organize, in accordance with the theme of the domain of data mining information, collate and display, for business managers scientific decision-making to provide true and reliable and timely management information, as an important issue has been raised.This paper is based on an integrated data warehouse technology in the telecommunications industry developments, combined with Shaanxi Telecom data warehouse platform, an integrated construction project, a comprehensive study of the production data warehouse required the construction of the system during the course of the design and realization of the related technologies, in particular, Data Extraction, Transformation, Load (ETL) technology is studied. Shaanxi paper outlines the first comprehensive data warehouse platform for telecommunications in the context of the building, demonstrates the need for system analysis of the system goals and business needs. On the basis of the integrated data warehouse platform for the overall planning, including the functional structure, logical architecture, physical architecture, integration with other systems analysis of the relationship. Then focus on an integrated platform for building data warehouse ETL process, an analysis of relevant technologies, combined with the actual proposed Shaanxi Telecom specific load ETL strategy, the interface of the ETL approach, data is loaded for the analysis of hierarchical structure design. Finally the realization of the system and introduced the testing process. Thesis program designed by the system at a later stage in both the application process, Shaanxi Telecom data warehouse platform, an integrated line of business to change the original operation mode of data analysis provided a more detailed demands of the more appropriate, appropriate mining China Telecom the overall requirements of the market, precision-to-business management and business transformation to provide strong technical support.