The application of Sybase Data Warehouse technology in China Unicom Operation Analysis System

Application background

China Unicom has a national scale of public telecommunications network, operating a variety of basic telecommunications business and value-added telecommunications services, the formation of mobile (GSM, CDMA), 193 long-distance, VoIP, 165 (Internet and E-commerce), paging, local calls, value-added services, such as a variety of business coexistence and common development pattern. How to give full play to Unicom's comprehensive advantages, to achieve flexible marketing strategy, to provide customers with more targeted satisfaction services; At the same time, to maximize the allocation and optimization of their resources, reduce operating costs, to enhance the core competitiveness of Unicom, has become an urgent problem to be solved. In this process, the response speed of market strategy is an important means to maintain competitiveness, and the formulation of market response strategy needs rich, real and timely management information to provide support. Hainan Unicom, under the unified planning of China Unicom Headquarter, adopts Sybase's data warehouse products and completes the Unified Management Information Service subsystem.

Hainan Unified Management Information Service subsystem is based on the query/statistical operating data as the core, the data originates from the data (including electronic and manual data) in each production subsystem of the service support system, and provides the business information service of customer and business analysis level for other systems of the enterprise through information display (including providing data interface access mode). including statistics and analysis, decision support, such as for the ERP system for business management in the management of statistical information to provide data sources.

Application Requirements

As we all know, the telecom industry data can be called a huge amount of data, the database, data Warehouse management software requirements are very high, mainly embodied in the massive data storage capacity and processing speed requirements. The application of this system in the field of data warehouse needs to be preserved, processing a large amount of historical data, in which the data quantity of CDR is the largest. In order to adapt to this demand, Lixin Communication Software Co., Ltd. suggested that Hainan Unicom selected a professional data Warehouse management software SybaseIQ12.5 to build enterprise management Information Data Warehouse system.

System Solutions

The Unified Management Information Service system consists of data acquisition module, Data Warehouse generating module, Data Warehouse interface module, Headquarters data file generation module, report generation module, metadata management module, System Management module and information model of the system. The information model of the system directs the construction and running process of the whole product. The overall structure of China Unicom's unified Management Information Service system is shown in the following illustration:

Chart: Unified management Information System structure diagram

Each function module and system Information model of the system below are described as follows:

System Information Model: This product information model includes four parts, respectively:

(1) Information Model of Data Warehouse (DW), such as Data Warehouse dimension table and fact table;

(2) System Management information model, such as: System User table, User rights table, etc.;

(3) Operational data Storage (ODS) information model;

(4) Meta-data information model.

Data Acquisition Module: Define the external business operating system for the content and format of the original data in this product, the external business operating system transmits the raw data to the data buffer specified by the product, the Data acquisition module collects data from it according to the dispatch rules and the format specification, and puts the information into staging area ( Temporary data Interchange area), as the data source for ODS.

Data Warehouse Generation module: Data Warehouse Generation module completes two ETL process, the first time from staging area to the business data ETL to OD, the second time according to the definition of the peacekeeping dimension defined by the Data Warehouse, the slightly integrated business data in ODS is integrated into the data warehouse with different granularity.

Data File Transfer module: This system provides two kinds of operating information access interface: One is to generate the interface data file according to the external Data requirement format specification, and the data transmission module completes the data transmission between the system and the external statistical analysis application system; The other is the way to open the Data Warehouse connection on the basis of the product providing data Warehouse metadata. In order to maintain the headquarters and the provincial branch business Information Service integration, this product encapsulates the provincial branch business information Services and Unicom headquarters data interface, according to the headquarters data requirements, the development of extraction rules, from the data Warehouse to extract the corresponding data into the interface data file, by the data File transfer module to send to Headquarters.

Data Warehouse Connection Management module: The products provide data Warehouse metadata to external statistical analysis application system to open Data Warehouse connection for external system to use data in Data Warehouse, Data Warehouse connection management module to control the access data of external system.

System Management module: mainly includes the management of data storage, data collection management, database production management (two times ETL rule management, Data update scheduling management, etc.), data transmission management, metadata management, log management and security management.

Report Generation module: The module features include report data generation, report generation, report publishing. The data extracted from the Data Warehouse/ods will generate/Update statistical report data, generate/update cubes and publish cubes for OLAP analysis.

Report Viewing module: The system allows authorized users to view the required report information from the remote side via the Web or client, and allows for online data analysis and synthesis; Including user browsing permission verification, report display and so on.