卷烟营销辅助决策支持系统设计与实现
|
摘要
随着中国加入WTO,烟草行业面临着巨大的竞争压力,为了提升卷烟营销管理水平,各公司都建立了相关的管理信息系统,如烟草销售业务系统、客户关系管理系统及烟草专卖管理系统等,各系统独自完成日常的业务处理工作。由于系统之间的数据不一致,没有形成一个全面、集成的数据环境,各个信息系统之间沟通不畅,信息共享不能实现,无法满足卷烟营销决策的要求。因此,本文利用卷烟营销辅助决策支持技术有效解决现代卷烟营销综合决策管理的业务要求。
本文在研究决策支持技术和相关理论基础上,对系统实现的主要关键技术进行了探讨。针对烟草营销系统综合决策管理用户需求进行系统分析,搭建出卷烟营销决策支持系统结构,并对系统中数据仓库、OLAP和数据挖掘部分进行了相应的设计。在系统实施上,将卷烟营销的行业经验与数据挖掘方法密切结合,体现了系统的适用性。
本文以六盘水市烟草公司卷烟营销信息系统为项目依托,采用辅助决策支持技术全面整合流程内的数据资源,实现卷烟营销信息集成和资源共享,提高了卷烟营销经营管理水平,为六盘水卷烟营销提供了很好的辅助决策支持效果。
With the China joined the WTO, the tobacco industry faces aggravating competition. In order to enhance the level of cigarette marketing, many companies have established several management information systems, such as tobacco sales systems, customer relationship management systems, and Tobacco Monopoly management systems. Although each system can fulfill their daily business processing needs, it is difficult to meet the requirements of modern tobacco marketing management, because the inconsistencies between the data, the nonintegrated data environment, the poor communication between the various information systems, and the poor information sharing. Thus, the thesis put forward a cigarette marketing decision support system to resolve these problems.
Based on the present research and overview of relevant theory, the thesis made an overall design of the system which combines the business needs of cigarette maketing information. We gave some analysis and instructions of the key technologies of the system, and constructed the system’s main function. In database design and management, we extract, transformate, filter and load the source data, then analyze the data through OLAP to carry out data mining, find out shared knowledge, and optimiz the system’s logical structure and physical implementation. In system implementation, the cigarette industry marketing experience and data mining methods were closely integrated, which fully reflect the applicability of the system.
The thesis relies on Liupanshui tobacco company’s cigarette marketing information system project, using data mining and business intelligence technology to build cigarette marketing decision support system, which has been successfully applied in practice.
本文在研究决策支持技术和相关理论基础上,对系统实现的主要关键技术进行了探讨。针对烟草营销系统综合决策管理用户需求进行系统分析,搭建出卷烟营销决策支持系统结构,并对系统中数据仓库、OLAP和数据挖掘部分进行了相应的设计。在系统实施上,将卷烟营销的行业经验与数据挖掘方法密切结合,体现了系统的适用性。
本文以六盘水市烟草公司卷烟营销信息系统为项目依托,采用辅助决策支持技术全面整合流程内的数据资源,实现卷烟营销信息集成和资源共享,提高了卷烟营销经营管理水平,为六盘水卷烟营销提供了很好的辅助决策支持效果。
With the China joined the WTO, the tobacco industry faces aggravating competition. In order to enhance the level of cigarette marketing, many companies have established several management information systems, such as tobacco sales systems, customer relationship management systems, and Tobacco Monopoly management systems. Although each system can fulfill their daily business processing needs, it is difficult to meet the requirements of modern tobacco marketing management, because the inconsistencies between the data, the nonintegrated data environment, the poor communication between the various information systems, and the poor information sharing. Thus, the thesis put forward a cigarette marketing decision support system to resolve these problems.
Based on the present research and overview of relevant theory, the thesis made an overall design of the system which combines the business needs of cigarette maketing information. We gave some analysis and instructions of the key technologies of the system, and constructed the system’s main function. In database design and management, we extract, transformate, filter and load the source data, then analyze the data through OLAP to carry out data mining, find out shared knowledge, and optimiz the system’s logical structure and physical implementation. In system implementation, the cigarette industry marketing experience and data mining methods were closely integrated, which fully reflect the applicability of the system.
The thesis relies on Liupanshui tobacco company’s cigarette marketing information system project, using data mining and business intelligence technology to build cigarette marketing decision support system, which has been successfully applied in practice.
引文
[1]贵州省烟草专卖局编.卷烟销售网络建设全面提升工作运行规范.贵阳:贵州人民出版社2006-09:131-189
[2]毕长敏主编.烟草流通企业战略与管理.沈阳:东北财经大学出版社,2004,71-90
[3]陈艳春.决策支持系统设计与开发.北京:人民邮电出版社,2007,22-83
[4] Peter G.W.Keen. Every Manager's Guide to Information Technology: A Glossary of Key Terms and Concepts for Today's Business Leader. Harvard Business School Press (January 1991),vol 10:123-130
[5]高勇.啤酒与尿布:神奇的购物篮分析.北京:清华大学出版社,2008,121-128
[6]王汝涌.今日的决策支持系统.外国经济与管理,1983(Z1):56-60
[7]耿刚勇,江涛等.烟草行业数据中心建设实施意见.北京:国家烟草专卖局,2006,20-40
[8]张应利,周霞.基于数据仓库的企业营销决策支持系统的设计.华南理工大学学报(自然科学版),2001,12(10):61-65
[9] http://www.magnsoftbi.com/services.asP?name=smoke烟草行业BI解决方案
[10]鲍玉斌,史捷,王大玲,等.企业级数据仓库设计方法及其实施的关键因素研究.控制与决策,2004, 12(12):35-40
[11]荆著,赵宏霞.数据库与数据仓库.现代管理科学,2008, 56(2):19-22
[12] G.Linoff. Which Way to the Mine? . AS/400 System Management, 1998, Vol26:42-44
[13] W.H.Inmon..Buliding the Data Warehouse Third Edition, .John Wiley&Sons Inc,2002,20-110
[14] M.J.A.Berry and G. Linoff. Data Mining Techniques, New York: John Wiley & Sons,1997,90-105
[15](加)Jiawei Han,MichelineKamber著,范明,孟小峰等译.数据挖掘概念与技术.北京:机械工业出版社,2005,12-60
[16] B.Mobasher, R.Cooley, J. Srivastava. Automatic Personalization Based on Web Personalization, Communications of the ACM, 2000, Vol43(8):142-151
[17] Rakesh Agrawal,Ramakrishnan Srikant.Fast Algorithms for Mining Association Rules. IBM Almaden Research Center 2008, 1-6
[18]毛国君,段立娟,王实,等.数据挖掘原理与算法.北京:清华大学出版社,2005,36-66
[19]陈文伟.决策支持系统教程.北京:清华大学出版社,2005,80-105
[20]许飚.柔性报表系统的设计与实现:[硕士学位论文] .华中科技大学,2006.5
[21]朱云龙,袁凌云等.基于仪表盘的税收决策支持平台的研究与实现.计算机应用与软件,2008.8,8-9
[22]王养廷,李磊,宋汉珍.UML基础与应用.北京:清华大学出版社,2006,13-37
[23]徐德智.数据仓库设计方法研究.企业技术开发,2004,20(2):7-9
[24]刘智琼.浅析ODS与EDW关系.电信科学,2007,68(7):5-9
[25]周祥,石小勇.浅谈烟草企业实用型数据仓库构建.科技信息,2006, 34(5):9-11
[26]于宗民,刘义宁.数据仓库项目管理实践.北京:人民邮电出版社,2006,48-78
[27]张宁,贾自艳,史忠植.数据仓库中ETL技术的研究.计算机工程与应用,2002, 20(24):38-41
[28]王欣,徐腾飞,唐连章.SQL Server2005数据挖掘实例分析.北京:中国水利水电出版社,2008,120-145
[29]张磊,钟勇.一种新型数据仓库体系的实现.计算机应用,2003, 12(10):111-113
[30]赵阳.需求分析与维度设计.北京:北京迈思奇科技有限公司,2007,30-56
[31]栾诚,李玉忱.数据仓库维度建模技术在电信行业的应用研究.通信世界,2005,22(16):20-22
[32]张应利,周霞.基于数据仓库的企业营销决策支持系统的设计.华南理工大学学报(自然科学版),2001,10(5):33-33
[33]章水,鑫徐,宏炳于,等.立增量式ETL工具的研究与实现.现代计算机,2005,13(3):6-9
[34]贵州省烟草公司编.卷烟零售客户星级评定方案.贵阳:贵州人民出版社2008-12:13-89
[35] (美)ZHAOHUI TANG,JAMIE MACLENNAN著,邝祝芳,焦贤龙,高升译.数据挖掘原理与应用-SQL SERVER 2005数据库.北京:清华大学出版社, 2007,109-205
[36]侯东风,陆昌辉,刘青宝等.联机分析处理的综述和分析.计算机科学,2008,32(10):12-16
[37]陈氢.几种新型决策支持系统的比较研究.情报科学,2005,24(1):34-37
[38] Golfarelli M.Maio D.Rizzi S Conceptual design of data warehouses from E/R schemas ,1998
[39]尤璞.数据仓库技术在卷烟销售中的应用.科技信息,2008(35):103-104
[40]欧阳秀军,刘文.数据挖掘技术在烟草CRM中的应用.井冈山学院学报,2009,6:41-42
[2]毕长敏主编.烟草流通企业战略与管理.沈阳:东北财经大学出版社,2004,71-90
[3]陈艳春.决策支持系统设计与开发.北京:人民邮电出版社,2007,22-83
[4] Peter G.W.Keen. Every Manager's Guide to Information Technology: A Glossary of Key Terms and Concepts for Today's Business Leader. Harvard Business School Press (January 1991),vol 10:123-130
[5]高勇.啤酒与尿布:神奇的购物篮分析.北京:清华大学出版社,2008,121-128
[6]王汝涌.今日的决策支持系统.外国经济与管理,1983(Z1):56-60
[7]耿刚勇,江涛等.烟草行业数据中心建设实施意见.北京:国家烟草专卖局,2006,20-40
[8]张应利,周霞.基于数据仓库的企业营销决策支持系统的设计.华南理工大学学报(自然科学版),2001,12(10):61-65
[9] http://www.magnsoftbi.com/services.asP?name=smoke烟草行业BI解决方案
[10]鲍玉斌,史捷,王大玲,等.企业级数据仓库设计方法及其实施的关键因素研究.控制与决策,2004, 12(12):35-40
[11]荆著,赵宏霞.数据库与数据仓库.现代管理科学,2008, 56(2):19-22
[12] G.Linoff. Which Way to the Mine? . AS/400 System Management, 1998, Vol26:42-44
[13] W.H.Inmon..Buliding the Data Warehouse Third Edition, .John Wiley&Sons Inc,2002,20-110
[14] M.J.A.Berry and G. Linoff. Data Mining Techniques, New York: John Wiley & Sons,1997,90-105
[15](加)Jiawei Han,MichelineKamber著,范明,孟小峰等译.数据挖掘概念与技术.北京:机械工业出版社,2005,12-60
[16] B.Mobasher, R.Cooley, J. Srivastava. Automatic Personalization Based on Web Personalization, Communications of the ACM, 2000, Vol43(8):142-151
[17] Rakesh Agrawal,Ramakrishnan Srikant.Fast Algorithms for Mining Association Rules. IBM Almaden Research Center 2008, 1-6
[18]毛国君,段立娟,王实,等.数据挖掘原理与算法.北京:清华大学出版社,2005,36-66
[19]陈文伟.决策支持系统教程.北京:清华大学出版社,2005,80-105
[20]许飚.柔性报表系统的设计与实现:[硕士学位论文] .华中科技大学,2006.5
[21]朱云龙,袁凌云等.基于仪表盘的税收决策支持平台的研究与实现.计算机应用与软件,2008.8,8-9
[22]王养廷,李磊,宋汉珍.UML基础与应用.北京:清华大学出版社,2006,13-37
[23]徐德智.数据仓库设计方法研究.企业技术开发,2004,20(2):7-9
[24]刘智琼.浅析ODS与EDW关系.电信科学,2007,68(7):5-9
[25]周祥,石小勇.浅谈烟草企业实用型数据仓库构建.科技信息,2006, 34(5):9-11
[26]于宗民,刘义宁.数据仓库项目管理实践.北京:人民邮电出版社,2006,48-78
[27]张宁,贾自艳,史忠植.数据仓库中ETL技术的研究.计算机工程与应用,2002, 20(24):38-41
[28]王欣,徐腾飞,唐连章.SQL Server2005数据挖掘实例分析.北京:中国水利水电出版社,2008,120-145
[29]张磊,钟勇.一种新型数据仓库体系的实现.计算机应用,2003, 12(10):111-113
[30]赵阳.需求分析与维度设计.北京:北京迈思奇科技有限公司,2007,30-56
[31]栾诚,李玉忱.数据仓库维度建模技术在电信行业的应用研究.通信世界,2005,22(16):20-22
[32]张应利,周霞.基于数据仓库的企业营销决策支持系统的设计.华南理工大学学报(自然科学版),2001,10(5):33-33
[33]章水,鑫徐,宏炳于,等.立增量式ETL工具的研究与实现.现代计算机,2005,13(3):6-9
[34]贵州省烟草公司编.卷烟零售客户星级评定方案.贵阳:贵州人民出版社2008-12:13-89
[35] (美)ZHAOHUI TANG,JAMIE MACLENNAN著,邝祝芳,焦贤龙,高升译.数据挖掘原理与应用-SQL SERVER 2005数据库.北京:清华大学出版社, 2007,109-205
[36]侯东风,陆昌辉,刘青宝等.联机分析处理的综述和分析.计算机科学,2008,32(10):12-16
[37]陈氢.几种新型决策支持系统的比较研究.情报科学,2005,24(1):34-37
[38] Golfarelli M.Maio D.Rizzi S Conceptual design of data warehouses from E/R schemas ,1998
[39]尤璞.数据仓库技术在卷烟销售中的应用.科技信息,2008(35):103-104
[40]欧阳秀军,刘文.数据挖掘技术在烟草CRM中的应用.井冈山学院学报,2009,6:41-42
© 2004-2018 中国地质图书馆版权所有 京ICP备05064691号 京公网安备11010802017129号 地址：北京市海淀区学院路29号 邮编：100083 电话：办公室：(+86 10)66554848；文献借阅、咨询服务、科技查新：66554700 |