【作者】 于红蕾；

【导师】 华庆一；

【作者基本信息】 西北大学 ， 计算机软件与理论， 2007， 硕士

【摘要】 计算机和数据库技术的应用，使电信企业在发展过程中积聚了大量业务数据。如何把这些数据进行合理组合，对其进行科学的分析以发现潜在的价值，对理论还是实践都是一个意义重大的课题。数据仓库作为一个面向主题的、集成的、时变的、非易失的数据集合，使用OLAP分析工具，可以有效解决具有多因素、多层次的数据分析问题，支持管理部门的统计分析和决策过程，因此被广泛研究和应用。本论文分析了陕西电信各业务系统的现状，描述了一个统计分析系统主要的需求和数据源，并对系统体系结构设计做了改进。通过对数据仓库常用设计模式及其优缺点详细的分析，针对“自顶向下”和“自底向上”模式设计的缺点，本论文提出在系统结构设计时采用二者结合的方式，既能满足各个部门在较短时间内建立本部门统计分析的要求，又解决了数据集市之间数据不一致问题，实现实时操作、共享设计和结构。本课题分析并实现了数据仓库技术在一个统计分析系统中的应用，以客户情况分析和业务发展情况分析主题为实例，说明了本系统的功能及为企业带来的效益，证明了数据仓库技术是数据密集型应用系统的一种有效解决方案，能很好地解决历史数据组织问题。最后，论文对本系统工作进行了总结，还进一步指出数据仓库建设中还需要解决的问题。更多还原

【Abstract】 With the application of computer and database technology, telecom enterprises have accumulated a plenty of business data in the process of development. It is a significant topic in both theory and practice to assemble these data reasonably and analyze scientifically to explore their potential values. Data Warehouse is a subject-oriented, integrated, time-variant, and nonvolatile collection of data, which provides a potential solution for those problems with multi-factors and multi-hierarchies effectively by OLAP tools, so it is being researched and applied widely.This paper analyses the various service systems in Shaanxi Telecom, describes the main requirements and data origin of a statistics and analysis system, and improves the design of system architecture. After analyzing the common model and their advantages and disadvantages, the thesis puts forward an integrated model of "The Top Down Model" and "The Down Top Model" to solve the problems of only using one of them. This integrated model not only satisfies the departments’ requirements on statistics and analysis in a few months, but also solves the variance of data and realizes operating on real time and sharing common design and structure.This thesis analyses and realizes the application of data warehouse technology in a statistics and analysis system, and explains the functions and benefits for the enterprise through some cases, such as customer instance analysis and turnover development analysis. The system proves that data warehouse technology is an effective way in the data compression application system which can organize the structure of historical data effectively.Finally, this thesis is summarized, and some questions are pointed out about this solution.更多还原