Design And Implementation Of Operational Data Storage System

With the telecommunication market competition, data comprehensive application is in great demands, so to promote the construction of ODS system. The System of Hubei Unicom will provide reasonable structure and technology in the aspects of data integration, data storage, data application, data sharing to meet user data analysis needs.Based on the principle of ODS are introduced, including the system target, structure, and analyzes the industry’s leading way of ODS implementation. In the process of ODS design and implementation, the existing system data model is combinated, and system openness, flexibility and scalability is concerned. The system uses DSG products to achieve fast database replication, and then use the ORACLE ODI tools to achieve data extraction, clear, loading and transformation, through the ODI visualization component to complete data flow management, improve the quality of data.With the success of the system in Hubei Unicom, an isolation layer is built between business system and data warehouse, and part of functions of the details of the query is transferred, reduce business system pressure, and meet the Hubei Unicom business decision-making needs, achieves the goal of design.