基于数据仓库的电信本地网营销辅助系统研究与实现

【作者】 黄强；

【导师】 杨尚明； 李开云；

【作者基本信息】 电子科技大学 ， 软件工程， 2010， 硕士

【摘要】 随着需求的多元化、电信技术的日新月异以及国家信息化战略的深入实施,我国电信产业正在发生根本性转变。为提升企业核心竞争力,各省(市、区)电信运营商纷纷以数据仓库为基础构建经营分析系统,以期据此提高其经营和决策水平。数据仓库技术就是以决策支持为最终目标的技术,通过对过去大量历史数据的积累,使用联机分析处理技术来回答目前经营中究竟发生了什么情况,运用数据挖掘来预测企业将来可能要发生什么情形。它作为一种新兴技术,在数据处理量极大的行业中己经获得了广泛的使用。论文结合电信行业数据深层次应用的实际情况,将原有的需要人工进行的数据分析、制作报表的分析模式,转变为本系统所实现的灵活的、可自定义的电子分析模式;利用数据挖掘模型进行针对性的营销分析,为市场营销提供参考。通过本系统的建设,大大提高企业数据应用能力,从而提高经营和管理水平,加大企业市场竞争力。论文首先阐述项目的开发背景及意义,分析阐述了相关的数据仓库技术及数据挖掘模型;其次,结合自贡电信分公司的应用现状,应用软件工程的方法重点分析了电信本地网营销辅助系统的业务需求,提出了系统的开发内容,并就系统整体架构、软件架构、数据建模、模型设计等进行了详细阐述;最后,给出了系统的设计及实现。该系统融入了自贡市本地的分析理念,分析的数据粒度细,分析具有较好的时效性,能够更好地辅助各级市场人员分析营销现状,指导市场营销策略。论文还对海量基础数据存取造成性能下降的突出问题,提出了解决方案。该系统在框架的灵活性和可拓展性,以及数据访问权限控制等方面,都较好地满足了用户的需求,具有较好的使用和推广价值。更多还原

【Abstract】 With the diversified demand and ever-changing telecommunications technology as well as the further implementation of national information technology strategy, China’s telecommunications industry is undergoing fundamental change. In order to enhance the core competitiveness of enterprises, telecom operators of provinces (cities, districts) have to build a data warehouse based on operational analysis system, and improve their operations and decision-making level. Data warehouse technology is the ultimate goal of decision support technology. Through the accumulation of a lot of historical data pass by, it uses on-line analytical processing techniques to answer operating situation at present, uses data mining to predict the future of companies what can be happen. As an emerging technology, it has gained widespread usage in enormous amount of data processing industry.According the actual situation of the depth application of data in the telecommunications industry, the original need for manual data analysis and model of production reporting is changed to flexible, customizable electronic analytical model that implement by this system. At the same time, data mining model is presented by the thesis in targeted marketing analysis and provided a reference for marketing activities. Through the construction of this system, telecom operators can improve greatly the applications of enterprise data, and increase level of operational and management, enhance the competitiveness of the marketing.Firstly, the background and significance of project development is presented, the relevant data warehouse and data mining models is discussed. Secondly, with the data application of telecommunications branch of Zigong, we use software engineering methods focused on analyzing the local telecommunications network marketing business support system demand, and put forward the development of the system content and the overall system architecture, software architecture, data modeling, model design in detail. Finally, a system design and implementation is given. The system is integrated into the analysis of the local concept of Zigong that use fine granularity of data and better timeliness. This system is able to support the status quo at all levels of the market for analysis of marketing, and to guide marketing strategy. Mass-based data access performance degradation caused by the outstanding problems is researched and put forward a solution. In the framework of the system flexibility and scalability, and data access control, etc., are to meet the needs of users. So, the system has better prospect and can strengthen values effectively.更多还原