运营数据存储系统的设计与实现

发布时间：2018-06-11 23:03

本文选题：运营数据存储 + 数据仓库　；参考：《南京邮电大学》2012年硕士论文

【摘要】：随着通信市场竞争的加剧,通信企业对数据综合应用有了更高的要求,所以推动了本ODS系统的建设。本系统将对湖北联通众多应用系统在数据整合、数据存储、数据应用、数据共享这几个方面提供合理的架构及技术,满足用户数据分析的需要。本文首先对ODS系统原理进行介绍,包括系统目标、架构等,并分析了业界主流ODS实现方式。在ODS具体设计与实现过程中,主要遵循与现有系统数据模型相结合原则,并充分注意开放性、灵活性和可扩展性。本系统采用DSG产品实现数据库快速复制,然后利用ORACLE ODI工具实现数据抽取、清洗、加载与转化,通过ODI可视化组件完成数据流程管理,提高数据质量。本系统的成功上线,在湖北联通业务系统和数据仓库之间形成一个隔离层,并转移一部分业务系统细节查询的功能,降低业务系统压力,满足了湖北联通用户经营决策需求,达到了设计目标。
[Abstract]:With the increasing competition in the communication market, the communication enterprises have higher requirements for the comprehensive application of data, so the construction of this ODS system has been promoted. This system will provide reasonable structure and technology for many application systems of Hubei Unicom in data integration, data storage, data application and data sharing. Firstly, this paper introduces the principle of ODS system, including the system goal, architecture and so on, and analyzes the mainstream ODS implementation methods in the industry. In the process of ODS design and implementation, we mainly follow the principle of combining with the existing system data model, and pay full attention to openness, flexibility and expansibility. This system adopts DSG product to realize database fast copy, then uses Oracle ODI tool to realize data extraction, cleaning, loading and transformation, completes data flow management through ODI visual component, and improves data quality. An isolation layer is formed between Hubei Unicom business system and data warehouse, and a part of the service system details query function is transferred to reduce the pressure of the business system, meet the needs of Hubei Unicom user management decision-making, and achieve the design goal.
【学位授予单位】：南京邮电大学
【学位级别】：硕士
【学位授予年份】：2012
【分类号】：TP333

【相似文献】