基于数据仓库技术的MMS业务系统的设计与实现
|
摘要
随着彩信手机保有量和渗透率不断提高、彩信手机兼容性问题的逐步淡化,彩信业务已从成长期快速进入了成熟期,迎来一个新的发展高峰期,彩信(MMS)业务系统也随之成为了移动运营商关注的焦点,其网络规模也不断扩大。
伴随时间的增长、规模以及网络复杂性的扩大,MMS业务系统的数据信息开始呈现爆炸式增长趋势,业务系统也开始产生诸多问题。一方面,系统内数据庞大芜杂,数据存储多源异构性的特点导致数据采集、整理、分析的任务日益繁重;另一方面,海量数据得不到有效利用,不能为决策系统提供细致深入的数据分析支持,形成信息孤岛,无法发挥在信息网络中的强大作用。
这时,就需要建立一种体系化的信息存贮环境,将分析决策所需的大量数据从传统的操作环境中分离出来,使分散的、不一致的数据转换成集成的、统一的数据,不同用户都可以在此单一的环境之下,通过运用其中的数据,发现全新的视野和新的问题、新的分析与想法,进而发展出制度化的决策系统。
本文通过对原有MMS业务系统的网元结构、数据源以及用户需求进行分析,发现基于数据仓库技术来实现MMS业务系统可以达到统一数据并有效利用数据为决策系统提供数据分析支持的目的。
本文主要做了以下几点工作:
(1)介绍了本人参与的某省移动MMS业务系统项目以及本人负责的数据处理模块。通过参与分析MMS业务系统的现状及特点,提出了基于数据仓库技术的系统解决方案,设计并实现了系统的数据仓库逻辑模型和数据处理流程。
(2)根据数据仓库的设计方法,结合MMS业务系统的需求分析,为该系统确定了“业务流量分析”和“服务质量分析”的主题。依据主题参与设计并实现了数据关系的逻辑模型,解决了原有系统中存在的海量数据信息孤岛的问题。
(3)针对数据多源异构性的特点,对系统中的数据来源进行了分析,设计并实现了数据处理流程,达到了数据集成、统一的目的。
本文参与实现的MMS业务系统已在某省移动运营商投入使用,利用数据仓库技术,深层次地挖掘、分析生产业务数据以及相关环境数据,能够自动快速获取其中有用的决策信息,为电信企业提供快速、准确和便捷的决策支持。
With MMS and the total number of mobile phone penetration rate continuously improve, MMS phone compatibility issues gradually weaken, MMS business has been growing rapidly into the mature stage, ushering in a new development at its peak, MMS (MMS) operational system will become a mobile operator focus, the scale of its network have also expanded.
With time the growth, size and complexity of the network and the expansion of MMS business information system data indicate the explosive growth trends, business systems are also starting to many problems. On the one hand, the huge data system, data storage Heterogeneous result of the characteristics of data collection, collation, analysis of the increasingly onerous task; On the other hand, massive data is not effectively use, not for the decision-making system to provide in-depth and meticulous data analysis support, the formation of islands of information, the information can not play a powerful role in the network.
Then, on the need to establish a system of information storage environment, will analyze large amounts of data needed for decision-making from the traditional separation of the operating environment, it was scattered, inconsistent data into integrated, unified data, different Users can be in this single environment, through the use of the data and found that a new vision and new problems, new ideas and analysis, and develop a systematic decision-making system. Based on the original system of MMS business network structure, data sources and user needs analysis, based on data warehouse technology to achieve MMS business system can achieve the data and make effective use of data for decision-making system to provide data analysis support purposes.
This paper mainly focuses on the following aspects:
(1) Introduce the participation of the provinces mobile MMS business systems projects, and I am responsible for the data processing module. MMS business through participation in the analysis of the status and characteristics of system was proposed based on the MMS data warehouse technology business solutions, designed and implemented the system logical model of data warehouse and data processing.Heterogeneous data for the characteristics of the system of data sources for the analysis of participation in the design and realization of the data processing to the data integration, unity of purpose and resolve of the original system data scattered, inconsistent problems.
(2) According to the data warehouse design method, combining the needs of MMS business systems analysis, the system has defined "business flow analysis" and "quality of service analysis" theme. Based on the theme involved in the design and realization of the logic of relations between the data model, the original system to resolve the island's massive data problem.
(3) Heterogeneous data for the characteristics of the system of data sources for the analysis, design and realization of the data processing to the data integration, unity of purpose.
伴随时间的增长、规模以及网络复杂性的扩大,MMS业务系统的数据信息开始呈现爆炸式增长趋势,业务系统也开始产生诸多问题。一方面,系统内数据庞大芜杂,数据存储多源异构性的特点导致数据采集、整理、分析的任务日益繁重;另一方面,海量数据得不到有效利用,不能为决策系统提供细致深入的数据分析支持,形成信息孤岛,无法发挥在信息网络中的强大作用。
这时,就需要建立一种体系化的信息存贮环境,将分析决策所需的大量数据从传统的操作环境中分离出来,使分散的、不一致的数据转换成集成的、统一的数据,不同用户都可以在此单一的环境之下,通过运用其中的数据,发现全新的视野和新的问题、新的分析与想法,进而发展出制度化的决策系统。
本文通过对原有MMS业务系统的网元结构、数据源以及用户需求进行分析,发现基于数据仓库技术来实现MMS业务系统可以达到统一数据并有效利用数据为决策系统提供数据分析支持的目的。
本文主要做了以下几点工作:
(1)介绍了本人参与的某省移动MMS业务系统项目以及本人负责的数据处理模块。通过参与分析MMS业务系统的现状及特点,提出了基于数据仓库技术的系统解决方案,设计并实现了系统的数据仓库逻辑模型和数据处理流程。
(2)根据数据仓库的设计方法,结合MMS业务系统的需求分析,为该系统确定了“业务流量分析”和“服务质量分析”的主题。依据主题参与设计并实现了数据关系的逻辑模型,解决了原有系统中存在的海量数据信息孤岛的问题。
(3)针对数据多源异构性的特点,对系统中的数据来源进行了分析,设计并实现了数据处理流程,达到了数据集成、统一的目的。
本文参与实现的MMS业务系统已在某省移动运营商投入使用,利用数据仓库技术,深层次地挖掘、分析生产业务数据以及相关环境数据,能够自动快速获取其中有用的决策信息,为电信企业提供快速、准确和便捷的决策支持。
With MMS and the total number of mobile phone penetration rate continuously improve, MMS phone compatibility issues gradually weaken, MMS business has been growing rapidly into the mature stage, ushering in a new development at its peak, MMS (MMS) operational system will become a mobile operator focus, the scale of its network have also expanded.
With time the growth, size and complexity of the network and the expansion of MMS business information system data indicate the explosive growth trends, business systems are also starting to many problems. On the one hand, the huge data system, data storage Heterogeneous result of the characteristics of data collection, collation, analysis of the increasingly onerous task; On the other hand, massive data is not effectively use, not for the decision-making system to provide in-depth and meticulous data analysis support, the formation of islands of information, the information can not play a powerful role in the network.
Then, on the need to establish a system of information storage environment, will analyze large amounts of data needed for decision-making from the traditional separation of the operating environment, it was scattered, inconsistent data into integrated, unified data, different Users can be in this single environment, through the use of the data and found that a new vision and new problems, new ideas and analysis, and develop a systematic decision-making system. Based on the original system of MMS business network structure, data sources and user needs analysis, based on data warehouse technology to achieve MMS business system can achieve the data and make effective use of data for decision-making system to provide data analysis support purposes.
This paper mainly focuses on the following aspects:
(1) Introduce the participation of the provinces mobile MMS business systems projects, and I am responsible for the data processing module. MMS business through participation in the analysis of the status and characteristics of system was proposed based on the MMS data warehouse technology business solutions, designed and implemented the system logical model of data warehouse and data processing.Heterogeneous data for the characteristics of the system of data sources for the analysis of participation in the design and realization of the data processing to the data integration, unity of purpose and resolve of the original system data scattered, inconsistent problems.
(2) According to the data warehouse design method, combining the needs of MMS business systems analysis, the system has defined "business flow analysis" and "quality of service analysis" theme. Based on the theme involved in the design and realization of the logic of relations between the data model, the original system to resolve the island's massive data problem.
(3) Heterogeneous data for the characteristics of the system of data sources for the analysis, design and realization of the data processing to the data integration, unity of purpose.
引文
[1]W.H.Inmon,Building the Data Warehouse.3nd ed.American,John Wiley&Sons,2003
[2]R.Kimball,The Data Warehouse Toolkit,John Wiley &Sons,1996
[3]杨文川,数据仓库技术在统计行业应用的研究与实现,计算机科学,第29卷8月增刊(NDBC 2002)
[4]段云峰,吴唯宁,李剑威等,数据仓库及其再电信领域中的应用,北京,电子工业出版社,2003,1-2
[5]童兴,陈珊珊,奚建春,电信企业中商务智能的研究与应用,天津通信技术,2003,9-13
[6]宋中山,数据仓库技术研究与应用,计算机工程与应用,2003,181-183
[7]陈京民,数据仓库与数据挖掘技术,北京,电子工业出版社,2002,55-57
[8]陈文伟,决策支持系统及其开发(第二版),北京,清华大学出版社,2000,11-13
[9]吴基传,世界电信业的分析与思考,新华出版社,2002,3-5
[10](美)Ponniah,P.著,段云峰,李剑威,韩洁等译,数据仓库基础,北京,电子工业出版社,2004
[11]周根贵,数据仓库与数据挖掘,杭州,浙江大学出版社,2004
[12]王丽珍,周丽华,陈红梅等,数据仓库与数据挖掘原理及应用,北京,科学出版社,2005
[13]颜端武,王曰芬,数据仓库的数据组织及其联机分析处理实现,情报科学,2003,21(11),1217-1220
[14]N.Damas,徐德智,数据仓库设计方法研究,企业技术开发,2004,23(2),7-9
[15]萨师煊,王珊.数据库系统概论(第三版)[M],北京,高等教育出版社,2000.
[16]林宇,数据仓库原理与实践,北京,人民邮电出版社,2003
[17]彭木根,数据仓库技术与实现,北京,电子工业出版社,2002
[18]张维明.数据仓库原理与应用,北京,电子工业出版社,2002
[19]W.Richard Stevens,UNIX网络编程卷2:进程间通信,北京,清华大学出版社,2002
[20]祁国辉,OLAP技术的发展与方向,数据仓库之路,2003
[21]李军,利用数据挖掘实现电信行业客户流失分析,数据仓库之路,2001
[22]段云峰,吴唯宁,中国的移动经营分析系统介绍,电信技术,2001
[23]陈东鹏,数据仓库技术在移动通信领域的应用,网络世界,2001
[24]陈宁,数据仓库中ETL技术的研究,计算机工程与应用,2002,38(24),213-216
[25]中国移动通信有限公司,05-中国移动数据网管二期技术规范 第五部分 省级数据需求分册,2006
[2]R.Kimball,The Data Warehouse Toolkit,John Wiley &Sons,1996
[3]杨文川,数据仓库技术在统计行业应用的研究与实现,计算机科学,第29卷8月增刊(NDBC 2002)
[4]段云峰,吴唯宁,李剑威等,数据仓库及其再电信领域中的应用,北京,电子工业出版社,2003,1-2
[5]童兴,陈珊珊,奚建春,电信企业中商务智能的研究与应用,天津通信技术,2003,9-13
[6]宋中山,数据仓库技术研究与应用,计算机工程与应用,2003,181-183
[7]陈京民,数据仓库与数据挖掘技术,北京,电子工业出版社,2002,55-57
[8]陈文伟,决策支持系统及其开发(第二版),北京,清华大学出版社,2000,11-13
[9]吴基传,世界电信业的分析与思考,新华出版社,2002,3-5
[10](美)Ponniah,P.著,段云峰,李剑威,韩洁等译,数据仓库基础,北京,电子工业出版社,2004
[11]周根贵,数据仓库与数据挖掘,杭州,浙江大学出版社,2004
[12]王丽珍,周丽华,陈红梅等,数据仓库与数据挖掘原理及应用,北京,科学出版社,2005
[13]颜端武,王曰芬,数据仓库的数据组织及其联机分析处理实现,情报科学,2003,21(11),1217-1220
[14]N.Damas,徐德智,数据仓库设计方法研究,企业技术开发,2004,23(2),7-9
[15]萨师煊,王珊.数据库系统概论(第三版)[M],北京,高等教育出版社,2000.
[16]林宇,数据仓库原理与实践,北京,人民邮电出版社,2003
[17]彭木根,数据仓库技术与实现,北京,电子工业出版社,2002
[18]张维明.数据仓库原理与应用,北京,电子工业出版社,2002
[19]W.Richard Stevens,UNIX网络编程卷2:进程间通信,北京,清华大学出版社,2002
[20]祁国辉,OLAP技术的发展与方向,数据仓库之路,2003
[21]李军,利用数据挖掘实现电信行业客户流失分析,数据仓库之路,2001
[22]段云峰,吴唯宁,中国的移动经营分析系统介绍,电信技术,2001
[23]陈东鹏,数据仓库技术在移动通信领域的应用,网络世界,2001
[24]陈宁,数据仓库中ETL技术的研究,计算机工程与应用,2002,38(24),213-216
[25]中国移动通信有限公司,05-中国移动数据网管二期技术规范 第五部分 省级数据需求分册,2006
© 2004-2018 中国地质图书馆版权所有 京ICP备05064691号 京公网安备11010802017129号 地址：北京市海淀区学院路29号 邮编：100083 电话：办公室：(+86 10)66554848；文献借阅、咨询服务、科技查新：66554700 |