利用数据仓库技术实现电信业务经营分析
摘要
本文从总体的角度阐述如何从工程上实施一个商务智能项目。结合本人目前正在参与的统一经营分析系统的开发，总结了一些经验和方法。主要是从整个系统的架构方面后台技术的一系列的流程以及相应的技术。着重介绍了数据仓库后台数据的组织方式和MOLAP方式下运用相关工具进行建模的方法。结合统一经营分析系统的建设，对整个系统的架构进行了分析，说明。给出了系统架构图，系统流程，数据流程等分析结果。并对主题模型和ETL做出了详细的分析。给出了建立主题模型的应用流程以及相应的技术问题的探讨。并在模型优化上做了初步的讨论。给出了实际工程中所采用的方法。
This paper will expatiate on how to actualize a project of BI(Business Intelligence) in a engineering from the globe point of view.Combine the unite analytical system of prosecution that I am working on,I sum up some experience and methods to resolve problems.It expatiates the technic and flows that used to construct the Data Warehouse from background,especially about the data structure and how to build model by using tools under the schema of MOLAP.Combine the unite analytical system of prosecution,we analyse the structure of the system. We offer the results such as picture of system structure, system data flows etc. Giving the particular analyse on theme model and ETL. Talking about relevant technical problems on how to build the theme model and discuss the way of optimize the model and offer the way that we used actually.
This paper will expatiate on how to actualize a project of BI(Business Intelligence) in a engineering from the globe point of view.Combine the unite analytical system of prosecution that I am working on,I sum up some experience and methods to resolve problems.It expatiates the technic and flows that used to construct the Data Warehouse from background,especially about the data structure and how to build model by using tools under the schema of MOLAP.Combine the unite analytical system of prosecution,we analyse the structure of the system. We offer the results such as picture of system structure, system data flows etc. Giving the particular analyse on theme model and ETL. Talking about relevant technical problems on how to build the theme model and discuss the way of optimize the model and offer the way that we used actually.
引文
[1] 章兴，陈珊珊，奚建春．电信企业中商务智能的研究与应用．天津通信技术．2003(4)：9-13
[2] 刘建国．商业智能及其应用．商业研究．2003(22)：173-175
[3] Blaha, M. Data warehouses and decision support systems. Ieee Computer Magazine (m-c).2001 34 (12): 38-39
[4] W.H. Inmon. Building the Data Warehouse. 3nd ed. American: John Wiley & Sons, 2003-3-1
[5] 宋中山．数据仓库技术研究与应用．计算机工程与应用．2003 33：181-183
[6] 缪翀莺．数据仓库——商业智能的基石．广东通信技术．2003 23(7)：21-27
[7] 颜端武，王日芬．数据仓库的数据组织及其联机分析处理实现．情报科学．2003 21(11)：1217-1220
[8] 饶元，冯博琴．数据仓库的存储优化设计．计算机工程与应用．2003 36：197-200
[9] 吴建芹，吴建林，张雷．基于CWM的企业数据仓库体系结构设计．计算机工程与应用．2002 21：202-204
[10] 陈宇翔，鲍鸿．数据集市技术．微机发展．2002(6)：23-25
[11] Joseph. M. Firestone, Ph.D. Data Warehouses and Data Marts. Executive Information System Inc. 1997 (3)
[12] Marc Demarest. Building the Data Mart. DBMS Magazine. 1999 7 (8): 44
[13] 李静，宋瀚涛．创建企业级数据仓库的关键技术．计算机应用研究．2001(5)：90-93
[14] 杨光，张雷，艾波．数据仓库实施策略．计算机应用．1999(9)：4-7
[15] 虞健飞，朱家元，张恒喜．数据仓库设计过程研究．计算机工程．2003 29(19)：4-5
[16] N．Damas，徐德智．数据仓库设计方法研究．企业技术开发．2004 23(2)：7-9
[17] Dimitri Theodoratos. Designing data warehouses. Data & Knowledge Engineering. 1999 31 (3): 279-301
[18] L. Wu, L. Miller, S. Nilakanta. Design of data warehouses using metadata, Information and Software Technology. 2001 43 (2): 109-119
[19] Terry Moriarty. A Metadata Management How-To. Database Programming & Design. 1997:57-60
[20] 南京联创股份有限公司．联通经营分析系统设计规格说明书—详细设计．
南京：南京联创股份有限公司，2003-8
[21] Elke A. Rundensteiner. Maintaining Data Warehouses Over Changing Information Source. communications of the ACM. 2000
[22] Nicholas galemmo. Mastering data warehouse design, relational and dimensional technique. 2000
[23] 赵太胜，张威，钱旭．基于ODS构建商业系统的即时OLAP应用．现代计算机．2001 115：37-39
[24] Ansela Bonifati, Fabiano Cattaneo, Stefano Ceri, Alfonso Fuggetta, Stefano Paraboschi. Designing data marts for data warehouses. ACM transactions on software engineering and methodology. 2001 10 (4): 452 - 483
[25] 南京联创股份有限公司．联通经营分析系统需求规格书．南京：南京联创股份有限公司，2001-1
[26] 高宏，李建中，李金宝．数掘仓库系统中层次式Cube存储结构．软件学报．2003 14(7)：1258-1266
[2] 刘建国．商业智能及其应用．商业研究．2003(22)：173-175
[3] Blaha, M. Data warehouses and decision support systems. Ieee Computer Magazine (m-c).2001 34 (12): 38-39
[4] W.H. Inmon. Building the Data Warehouse. 3nd ed. American: John Wiley & Sons, 2003-3-1
[5] 宋中山．数据仓库技术研究与应用．计算机工程与应用．2003 33：181-183
[6] 缪翀莺．数据仓库——商业智能的基石．广东通信技术．2003 23(7)：21-27
[7] 颜端武，王日芬．数据仓库的数据组织及其联机分析处理实现．情报科学．2003 21(11)：1217-1220
[8] 饶元，冯博琴．数据仓库的存储优化设计．计算机工程与应用．2003 36：197-200
[9] 吴建芹，吴建林，张雷．基于CWM的企业数据仓库体系结构设计．计算机工程与应用．2002 21：202-204
[10] 陈宇翔，鲍鸿．数据集市技术．微机发展．2002(6)：23-25
[11] Joseph. M. Firestone, Ph.D. Data Warehouses and Data Marts. Executive Information System Inc. 1997 (3)
[12] Marc Demarest. Building the Data Mart. DBMS Magazine. 1999 7 (8): 44
[13] 李静，宋瀚涛．创建企业级数据仓库的关键技术．计算机应用研究．2001(5)：90-93
[14] 杨光，张雷，艾波．数据仓库实施策略．计算机应用．1999(9)：4-7
[15] 虞健飞，朱家元，张恒喜．数据仓库设计过程研究．计算机工程．2003 29(19)：4-5
[16] N．Damas，徐德智．数据仓库设计方法研究．企业技术开发．2004 23(2)：7-9
[17] Dimitri Theodoratos. Designing data warehouses. Data & Knowledge Engineering. 1999 31 (3): 279-301
[18] L. Wu, L. Miller, S. Nilakanta. Design of data warehouses using metadata, Information and Software Technology. 2001 43 (2): 109-119
[19] Terry Moriarty. A Metadata Management How-To. Database Programming & Design. 1997:57-60
[20] 南京联创股份有限公司．联通经营分析系统设计规格说明书—详细设计．
南京：南京联创股份有限公司，2003-8
[21] Elke A. Rundensteiner. Maintaining Data Warehouses Over Changing Information Source. communications of the ACM. 2000
[22] Nicholas galemmo. Mastering data warehouse design, relational and dimensional technique. 2000
[23] 赵太胜，张威，钱旭．基于ODS构建商业系统的即时OLAP应用．现代计算机．2001 115：37-39
[24] Ansela Bonifati, Fabiano Cattaneo, Stefano Ceri, Alfonso Fuggetta, Stefano Paraboschi. Designing data marts for data warehouses. ACM transactions on software engineering and methodology. 2001 10 (4): 452 - 483
[25] 南京联创股份有限公司．联通经营分析系统需求规格书．南京：南京联创股份有限公司，2001-1
[26] 高宏，李建中，李金宝．数掘仓库系统中层次式Cube存储结构．软件学报．2003 14(7)：1258-1266