北京移动商业智能平台的分析与设计
|
摘要
商业智能是企业对商业数据的搜集、管理和分析的系统过程,目的是使企业的各级决策者获得知识或洞察力,帮助他们做出对企业更有利的决策,从技术层面上讲,BI是数据仓库、OLAP和数据挖掘等技术的综合运用。目前,商业智能已经在电信行业获得了广泛的应用,随着电信业的发展,许多电信公司建立了CRM、经营分析系统等大型的信息系统,积累了大量的客户数据和信息,但是对数据和信息的提取、分析、评估及应用于决策方面的问题日益增加,从而造成了大量高价值的数据不能发挥效用。
北京移动已经成功实施了CRM、BOSS和BASS系统,为了实现信息系统之间数据向知识的转化,增强数据的提取、分析、评价和决策应用,采用商业智能技术是一种比较好的选择。本文对商业智能关键技术进行了分析与研究,对商业职能平台进行了设计。本文主要做了以下工作:
分析商业智能在电信行业的应用和研究现状,从北京移动的信息化现状出发,提出建设商业智能平台的目标和内容。
以北京移动已有的CRM、BOSS、BASS系统为背景,对商业智能平台进行分析和设计,从数据源、业务和功能需求出发,设计了BMCC BI平台,包括ETL部件、仓库部件、OLAP部件、调度系统和前台系统五大模块,通过系统需求分析、系统设计、系统实施等内容展现了BMCC BI平台分析和设计的全过程,在平台实施成功后,通过数据分析和界面演示证明了平台的可用性。
Business intelligence (BI) is the process of collection, management and analysis of business data in enterprises, its purpose is to help decision-makers in enterprises to gain knowledge or insight, and then to do more beneficial decisions, from the technology tier, BI is the synthetical application of data warehouse, OLAP and data mining. At present, with the development of telecommunication industry, business intelligence has already gained broad application in this industry , lots of telecommunication companies have built large-scale information systems such as CRM , operation analysis systems, and accumulated large amount of data and information of customers, however, problems of the retrieving, analyzing and assessing of them so to be applied to decision making increase gradually, and leads to the ineffective of much data and information.
Beijing mobile company of China (BMCC) has already successfully applied CRM, BOSS and BASS systems, in order to increase the transformation from data to knowledge in MIS, and improve the retrieving, analyzing, assessing and decision making applications, the application of BI is an most optimal choice. From the problems we list out, and taking the application of business intelligent in BMCC as study background, we did an analysis and research on key technologies, analysis and design of BI platform, The main jobs we did is as following:
Analysis of the business intelligence application in telecommunication industry and its current situation, from the informatization situation in BMCC, the target, contents and significance of building BMCC BI platform is studied.
Taking the construction of CRM, BOSS, BASS in BMCC as study background, the analysis and design of BMCC BI platform has been completed, from the demands of data source, business and function, five modules were design on the platform: ETL component, warehouse component, OLAP component, dispatching module and proscenium module. Through the steps of system demand analysis, design, implementation etc, the analysis and design of BMCC BI platform process has been demonstrated, after the implementation of our system, the availability of platform has been proved by data analysis and interface display.
北京移动已经成功实施了CRM、BOSS和BASS系统,为了实现信息系统之间数据向知识的转化,增强数据的提取、分析、评价和决策应用,采用商业智能技术是一种比较好的选择。本文对商业智能关键技术进行了分析与研究,对商业职能平台进行了设计。本文主要做了以下工作:
分析商业智能在电信行业的应用和研究现状,从北京移动的信息化现状出发,提出建设商业智能平台的目标和内容。
以北京移动已有的CRM、BOSS、BASS系统为背景,对商业智能平台进行分析和设计,从数据源、业务和功能需求出发,设计了BMCC BI平台,包括ETL部件、仓库部件、OLAP部件、调度系统和前台系统五大模块,通过系统需求分析、系统设计、系统实施等内容展现了BMCC BI平台分析和设计的全过程,在平台实施成功后,通过数据分析和界面演示证明了平台的可用性。
Business intelligence (BI) is the process of collection, management and analysis of business data in enterprises, its purpose is to help decision-makers in enterprises to gain knowledge or insight, and then to do more beneficial decisions, from the technology tier, BI is the synthetical application of data warehouse, OLAP and data mining. At present, with the development of telecommunication industry, business intelligence has already gained broad application in this industry , lots of telecommunication companies have built large-scale information systems such as CRM , operation analysis systems, and accumulated large amount of data and information of customers, however, problems of the retrieving, analyzing and assessing of them so to be applied to decision making increase gradually, and leads to the ineffective of much data and information.
Beijing mobile company of China (BMCC) has already successfully applied CRM, BOSS and BASS systems, in order to increase the transformation from data to knowledge in MIS, and improve the retrieving, analyzing, assessing and decision making applications, the application of BI is an most optimal choice. From the problems we list out, and taking the application of business intelligent in BMCC as study background, we did an analysis and research on key technologies, analysis and design of BI platform, The main jobs we did is as following:
Analysis of the business intelligence application in telecommunication industry and its current situation, from the informatization situation in BMCC, the target, contents and significance of building BMCC BI platform is studied.
Taking the construction of CRM, BOSS, BASS in BMCC as study background, the analysis and design of BMCC BI platform has been completed, from the demands of data source, business and function, five modules were design on the platform: ETL component, warehouse component, OLAP component, dispatching module and proscenium module. Through the steps of system demand analysis, design, implementation etc, the analysis and design of BMCC BI platform process has been demonstrated, after the implementation of our system, the availability of platform has been proved by data analysis and interface display.
引文
[1]The 5 Styles of Business Intelligence:Industrial-strength business intelligence,MicroStrategy,Inc.
[2]Kamel Roubibah,Samia Ould-ali.Puzzle:a concept and prototype for
[3]linking business intelligence to business strategy.[J]Journal of Strategic Information System 11(2002)133-152.
[4]Shaku Atre,Dipendra Malhotra.Real-Time Analysis and Data Integration for BI.http://www.dmreview,com.
[5]商业智能概念.http://www.bi-soft.comBI-power.htm.商业智能技术与应用发展现状分析.http://www.bokesoft.com.
[6]王珊,张新宇,陈红.商业智能的一大支柱.中国计算机报,12(2002).28-31.
[7]萨师煊,王珊.数据库系统概论(第三版)CM].北京:高等教育出版社,2000.
[8]袁林.基于数据仓库的辅助决策系统设计与实现.电力系统自动化[J],2001,7(21),21-23.
[9]王珊.数据仓库技术与联机分析处理[M].北京:科学出版社:1999,11-25.
[10]曹 悦.商业智能系统[EBOL].http://www.amteam.org,2001.
[11]RobinsonM.Business intelligence infrastructure[EBOL].http://www.dm review.com,2002.
[12]IBM中国公司软件部.IBM商业智能系列文章.计算机世界,1998.16-17.
[13]InmonW H.Building the data warehouse[M].Wellesley Massachusetts:Q ED Technical Publishing Group,1992.1-74.
[14][美]W.H.Inmon数据仓库.王志海等译.北京:机械工业出版社,2005.5.
[15]张春.商业智能技术与应用分析.电信工程技术与标准化[[J].2003,12:81-85.
[16]康博创作室.SQL Server 2000数据仓库设计和使用指南.清华大学出版社,2001.
[17]汤艳艳.数据仓库中基于面向对象技术的多维数据模型的设计与实现.计算机应用技术[J].2003,10:37-40.
[18]M.Golfarelli,S.Rizzi:Methodological Framework for Data Warehouse Design[M].In Proc.DOLAP,(Bethesda,Maryland,USA,1998)pp.3-9.
[19]Codd,S.B.Codd,and C.T.Salley.Providing OLAP to User-Analysts:An IT Mandate.
[20]武彦峰,朱仲英.基于DTS组件的数据仓库的数据抽取工具的设计与实现. 微型电脑应用[J],2004,3:35-36.
[21]石磊,石云.OLAP与数据挖掘一体化模型的研究与发展.计算机科学.Vol.27,No5,2000.45-49.
[22]曹斌,齐剑锋,涂序彦.商业智能决策支持系统(BIDSS)[J].计算机工程与应用,2001,(20):29-31.
[23]Michael J.Shaw,Chandrasekar Subramaniam,Gek WooTan,Michael E.Welge,Knowledge management and data mining for marketing,Decision Support Systems.31(2001),127-137.
[24]John H.Heinrichs,Jeen-Su Lim.Integrating web-based data mining tools with business models for knowledge management[J]Decision Support Systems 35(2003):103-112.
[25]R Agrawal,T.lmielinski,A.Swami.Database Mining:A Performance Perspective[J].IEEE Transactions on Knowledge and Data Engineering,1993,12:14-925.
[26]向保林.浅析数据挖掘技术在电力市场中的运用.计算机应用技术[J],2003,10:27-28.
[27]李德毅.数据挖掘研究现状.数据仓库之路[J],2000,11(2):16-17.
[28]Vasant Dhat.Data Mining In Finance:Using Counterfactuals to generate knowledge from organizational information system [J].Information System,1998,23(7):423-437.
[29]谢榕.数据挖掘与商业智能系统[[J].计算机系统应用,1999,8:9-10.
[30]杨城.数据挖掘实施分析.电脑开发与应用[[J].2002,11:25-27.
[31]Rouibah K,Ould2ali S.Puzzle:A concept and prototype for linking business intelligence to business strategy[J].Journal of Strategic Information Systems,2002,(11):133- 152.
[32]刘兵,张吉善.浅析商业智能系统的研究及发展趋势.理论研究.3-6.
[2]Kamel Roubibah,Samia Ould-ali.Puzzle:a concept and prototype for
[3]linking business intelligence to business strategy.[J]Journal of Strategic Information System 11(2002)133-152.
[4]Shaku Atre,Dipendra Malhotra.Real-Time Analysis and Data Integration for BI.http://www.dmreview,com.
[5]商业智能概念.http://www.bi-soft.comBI-power.htm.商业智能技术与应用发展现状分析.http://www.bokesoft.com.
[6]王珊,张新宇,陈红.商业智能的一大支柱.中国计算机报,12(2002).28-31.
[7]萨师煊,王珊.数据库系统概论(第三版)CM].北京:高等教育出版社,2000.
[8]袁林.基于数据仓库的辅助决策系统设计与实现.电力系统自动化[J],2001,7(21),21-23.
[9]王珊.数据仓库技术与联机分析处理[M].北京:科学出版社:1999,11-25.
[10]曹 悦.商业智能系统[EBOL].http://www.amteam.org,2001.
[11]RobinsonM.Business intelligence infrastructure[EBOL].http://www.dm review.com,2002.
[12]IBM中国公司软件部.IBM商业智能系列文章.计算机世界,1998.16-17.
[13]InmonW H.Building the data warehouse[M].Wellesley Massachusetts:Q ED Technical Publishing Group,1992.1-74.
[14][美]W.H.Inmon数据仓库.王志海等译.北京:机械工业出版社,2005.5.
[15]张春.商业智能技术与应用分析.电信工程技术与标准化[[J].2003,12:81-85.
[16]康博创作室.SQL Server 2000数据仓库设计和使用指南.清华大学出版社,2001.
[17]汤艳艳.数据仓库中基于面向对象技术的多维数据模型的设计与实现.计算机应用技术[J].2003,10:37-40.
[18]M.Golfarelli,S.Rizzi:Methodological Framework for Data Warehouse Design[M].In Proc.DOLAP,(Bethesda,Maryland,USA,1998)pp.3-9.
[19]Codd,S.B.Codd,and C.T.Salley.Providing OLAP to User-Analysts:An IT Mandate.
[20]武彦峰,朱仲英.基于DTS组件的数据仓库的数据抽取工具的设计与实现. 微型电脑应用[J],2004,3:35-36.
[21]石磊,石云.OLAP与数据挖掘一体化模型的研究与发展.计算机科学.Vol.27,No5,2000.45-49.
[22]曹斌,齐剑锋,涂序彦.商业智能决策支持系统(BIDSS)[J].计算机工程与应用,2001,(20):29-31.
[23]Michael J.Shaw,Chandrasekar Subramaniam,Gek WooTan,Michael E.Welge,Knowledge management and data mining for marketing,Decision Support Systems.31(2001),127-137.
[24]John H.Heinrichs,Jeen-Su Lim.Integrating web-based data mining tools with business models for knowledge management[J]Decision Support Systems 35(2003):103-112.
[25]R Agrawal,T.lmielinski,A.Swami.Database Mining:A Performance Perspective[J].IEEE Transactions on Knowledge and Data Engineering,1993,12:14-925.
[26]向保林.浅析数据挖掘技术在电力市场中的运用.计算机应用技术[J],2003,10:27-28.
[27]李德毅.数据挖掘研究现状.数据仓库之路[J],2000,11(2):16-17.
[28]Vasant Dhat.Data Mining In Finance:Using Counterfactuals to generate knowledge from organizational information system [J].Information System,1998,23(7):423-437.
[29]谢榕.数据挖掘与商业智能系统[[J].计算机系统应用,1999,8:9-10.
[30]杨城.数据挖掘实施分析.电脑开发与应用[[J].2002,11:25-27.
[31]Rouibah K,Ould2ali S.Puzzle:A concept and prototype for linking business intelligence to business strategy[J].Journal of Strategic Information Systems,2002,(11):133- 152.
[32]刘兵,张吉善.浅析商业智能系统的研究及发展趋势.理论研究.3-6.