德阳电业局电力营销决策支持系统的设计与实现
|
摘要
现代电力系统需要有现代化的管理，供电企业生产的各个环节对管理的要求也随之越来越高，越来越多的信息需要有先进的手段进行加工处理。传统的管理方式，由于技术手段的限制，对收集的信息不能进行科学的处理和加工，缺乏综合分析和对未来发展趋势进行科学预测的能力，不可避免地可能造成决策失误。因此利用现代最新的信息技术和电力营销理论建立一套切合实际具有辅助分析决策功能的营销管理信息系统已成为当务之急。
建立德阳电业局营销部的内部计算机网络，并在此基础上实现整个营销部的管理信息系统。该系统应用最新的计算机技术、软件技术及通信技术，针对营销部的工作特点，将决策支持系统(DSS)和在线分析处理(OLAP)、Business Object(BO)技术运用于电力系统营销中建立的电力营销决策支持系统，实现其业务的计算机管理，建立营销部的办公自动化系统，实现与外界系统的互联。通过直接与供电局营销管理信息系统的原始数据交换，实现对全电业局营销情况及时、准确和可靠的掌握和督管，并以此为基础可生成各种统计分析报表，实现负荷预测，为营销市场开发、领导科学决策提供依据，最终全面实现领导辅助决策系统。
本文较为全面地分析和讨论了电力营销决策支持的设计和实现，给出了具体的实现和应用过程。首先给决策支持系统的发展、功能、特点及体系结构进行了一般性的介绍，重点介绍了决策支持系统的开发工具Business Object。设计了德阳电力营销决策支持系统数据仓库的实现方案，对德阳电力营销决策支持系统进行了全面需求及功能分析，最后给出了Business Object实现的具体方法，并以电量电费分析为例给出了Business Object实现的决策分析功能。
Modern management will be needed by modern electric power system. The request to management is more and more strict in every part of power companies. More and more information will be managed by advanced ways. Conventional management ways can't deal scientifically with information collected and lack of the ability to analyse synthetically and forecast the trends of future development because of the limit of technique. Thus the mistakes of making decision will be resulted in inevitably. Thereby,a set of practical information system of power business-distribution management,which provided the function of aid-analysis and making-decision has been demanded.
The whole information system of power business-distribution management in Deyang Power Company is realized on based of setting up the interior computer network. The newest techniques of computer,software and communication are applied to this system. According to the network characteristic of power business-distribution department,it apply the technique of decision support system (DSS),on-line analysis process(OLAP) and Business Object(BO) to the decision support system of electrical power in order to realize the computer management and mutual unite with outside system of its business. Through changing directly with the original data of business-distribution management of power supply bureaus and realizing the in-time,accurate and reliable management and supervise to all of the company,all kinds of stat. analysis reports forms can be made. The forecast of load can be realized in order to support the foundation for the market exploitation,scientific making-decision. Thus the whole system will be realized final
ly.
This dissertation comparatively generally dissertates and analyses the design and realization of decision-making support system of electric power business-distribution. The concrete process of realization and application is put forward.
First,this dissertation introduces generally the development,function and characteristic of DSS. Business Objects of DSS exploitation tool is emphased. Then,the realizing scheme of data warehouse of DSS of Deyang electric power business-distribution is designed and the demands and function of the DSS of Deyang electric power business-distribution are carried out to analyze. At last,the concrete realizing measure of BO is resulted in. The realizing function of DSS of BO by an example of electricity quantity and fees is put forward.
建立德阳电业局营销部的内部计算机网络，并在此基础上实现整个营销部的管理信息系统。该系统应用最新的计算机技术、软件技术及通信技术，针对营销部的工作特点，将决策支持系统(DSS)和在线分析处理(OLAP)、Business Object(BO)技术运用于电力系统营销中建立的电力营销决策支持系统，实现其业务的计算机管理，建立营销部的办公自动化系统，实现与外界系统的互联。通过直接与供电局营销管理信息系统的原始数据交换，实现对全电业局营销情况及时、准确和可靠的掌握和督管，并以此为基础可生成各种统计分析报表，实现负荷预测，为营销市场开发、领导科学决策提供依据，最终全面实现领导辅助决策系统。
本文较为全面地分析和讨论了电力营销决策支持的设计和实现，给出了具体的实现和应用过程。首先给决策支持系统的发展、功能、特点及体系结构进行了一般性的介绍，重点介绍了决策支持系统的开发工具Business Object。设计了德阳电力营销决策支持系统数据仓库的实现方案，对德阳电力营销决策支持系统进行了全面需求及功能分析，最后给出了Business Object实现的具体方法，并以电量电费分析为例给出了Business Object实现的决策分析功能。
Modern management will be needed by modern electric power system. The request to management is more and more strict in every part of power companies. More and more information will be managed by advanced ways. Conventional management ways can't deal scientifically with information collected and lack of the ability to analyse synthetically and forecast the trends of future development because of the limit of technique. Thus the mistakes of making decision will be resulted in inevitably. Thereby,a set of practical information system of power business-distribution management,which provided the function of aid-analysis and making-decision has been demanded.
The whole information system of power business-distribution management in Deyang Power Company is realized on based of setting up the interior computer network. The newest techniques of computer,software and communication are applied to this system. According to the network characteristic of power business-distribution department,it apply the technique of decision support system (DSS),on-line analysis process(OLAP) and Business Object(BO) to the decision support system of electrical power in order to realize the computer management and mutual unite with outside system of its business. Through changing directly with the original data of business-distribution management of power supply bureaus and realizing the in-time,accurate and reliable management and supervise to all of the company,all kinds of stat. analysis reports forms can be made. The forecast of load can be realized in order to support the foundation for the market exploitation,scientific making-decision. Thus the whole system will be realized final
ly.
This dissertation comparatively generally dissertates and analyses the design and realization of decision-making support system of electric power business-distribution. The concrete process of realization and application is put forward.
First,this dissertation introduces generally the development,function and characteristic of DSS. Business Objects of DSS exploitation tool is emphased. Then,the realizing scheme of data warehouse of DSS of Deyang electric power business-distribution is designed and the demands and function of the DSS of Deyang electric power business-distribution are carried out to analyze. At last,the concrete realizing measure of BO is resulted in. The realizing function of DSS of BO by an example of electricity quantity and fees is put forward.
引文
[1] Scott Morton M.S., Management Decision Systems in Computer- Based Support for Decision Making, Division of Research, Harvard University, Cambridge, Massachusetts, 1971.
[2] Konsynski B, Sprague R H. Future Research Directions In Model Management, Decision Support Systems, 1986, (2).
[3] 顾培亮．工业工程的使命与支持手段．中国机械工程学会第二次工业工程学术会议论文集，上海：上海科技出版社，1991．50～55
[4] Brennan J J, Elam J J, Understanding and validating results in model-based decision support systems, 1986.
[5] Miller L W, Katz N. A model management systems to support policy analysis. Decision support systems, 1986.
[6] Bianning R W. An entity-relationship approach to model management. Decision support systems, 1986.
[7] Alter, Steven L.A texanomy of decision support systems. Solan Management Review, 1977, 39:56
[8] 重庆大学电气工程有限公司，DY_YXDDS需求分析，2000，12．
[9] 重庆大学电气工程有限公司，四川省电力公司科学技术项目申请书，1999，11．
[10] Dolk D R. Data as methods: An approach to implementing model management: Decision support systems, 1986.
[11] Burns A, Rathwell M A, Thomas R C. A distribute decision making systems. Decision Support Systems, 1987.
[12] Watson H J,Boyd-wilson T,Magal S R. The evaluation of DSS groups. Information & Management, 1987.
[13] 王向阳，试论计算机网络信息管理与决策支持系统体系结构设计，软件学报，1994-1，第5卷第1期，48～52．
[14] Jark M. Knowledge sharing and negotiation support in multiple decision support systems. Decision Support Systems, 1986.
[15] 左小德．管理支持系统(M S S)的理论与方法及其应用：[学位论文]．天津：天津大学，1995
[16] 马勤勇，使用决策支持对象建立OLAP数据结构的研究，燕山大学学报，2000，21卷21期．
[17] 韦洛霞，数据仓库与OLAP的研究，东菀理工学院学报，2000，7卷14期．
[18] 周丽娟，数据仓库和OLAP研究，哈尔滨工程大学计算机学院学报，2000，10．
[19] 吉根林，连机分析处理(OLAP)技术研究，南京师大学报，2000，22卷4期，
[20] 刘义，常戈群，基于关系数据库的OLAP的研究，清华大学学报，1998，30卷13期
[21] 太平洋技术软件集团，决策支持系统应用——在电力行业，1999，3．
[22] 重庆大学电气工程有限公司，德阳电力系统概要设计说明书，2001，9．
[23] 重庆大学电气工程有限公司，德阳电业局电力营销DSS系统(DYYX-DSS)技术协议，1999，12．
[24] 德阳电业局，德阳电业局营销DSS系统(补充材料)，2000，4．
[25] 德阳电业局，德阳电业局营销DSS系统需求分析说明书，1999，11．
[26] 李敏强，潘振江，基于数据仓库技术的决策支持系统的研究和应用 天津大学管理学院学报，2001，12卷15期．
[27] Liang T P, Critical success factor of decision support systems: An experimental study.Database Winter, 1986.
[28] Bolen.R.michelle，Oracle数据库应用，机械工业出版社，1999，2．
[29] Al.Kete.Dome，Sybase程序员指南，机械工业出版社，1999，12．
[30] Mc.Hanlen，Microsoft SQL Server2000入门与精通，电子工业出版社，2000，7．
[31] 钱大琳，刘峰，决策支持系统的再认识，北方交通大学学报，1994，18卷12期，p552～555．
[2] Konsynski B, Sprague R H. Future Research Directions In Model Management, Decision Support Systems, 1986, (2).
[3] 顾培亮．工业工程的使命与支持手段．中国机械工程学会第二次工业工程学术会议论文集，上海：上海科技出版社，1991．50～55
[4] Brennan J J, Elam J J, Understanding and validating results in model-based decision support systems, 1986.
[5] Miller L W, Katz N. A model management systems to support policy analysis. Decision support systems, 1986.
[6] Bianning R W. An entity-relationship approach to model management. Decision support systems, 1986.
[7] Alter, Steven L.A texanomy of decision support systems. Solan Management Review, 1977, 39:56
[8] 重庆大学电气工程有限公司，DY_YXDDS需求分析，2000，12．
[9] 重庆大学电气工程有限公司，四川省电力公司科学技术项目申请书，1999，11．
[10] Dolk D R. Data as methods: An approach to implementing model management: Decision support systems, 1986.
[11] Burns A, Rathwell M A, Thomas R C. A distribute decision making systems. Decision Support Systems, 1987.
[12] Watson H J,Boyd-wilson T,Magal S R. The evaluation of DSS groups. Information & Management, 1987.
[13] 王向阳，试论计算机网络信息管理与决策支持系统体系结构设计，软件学报，1994-1，第5卷第1期，48～52．
[14] Jark M. Knowledge sharing and negotiation support in multiple decision support systems. Decision Support Systems, 1986.
[15] 左小德．管理支持系统(M S S)的理论与方法及其应用：[学位论文]．天津：天津大学，1995
[16] 马勤勇，使用决策支持对象建立OLAP数据结构的研究，燕山大学学报，2000，21卷21期．
[17] 韦洛霞，数据仓库与OLAP的研究，东菀理工学院学报，2000，7卷14期．
[18] 周丽娟，数据仓库和OLAP研究，哈尔滨工程大学计算机学院学报，2000，10．
[19] 吉根林，连机分析处理(OLAP)技术研究，南京师大学报，2000，22卷4期，
[20] 刘义，常戈群，基于关系数据库的OLAP的研究，清华大学学报，1998，30卷13期
[21] 太平洋技术软件集团，决策支持系统应用——在电力行业，1999，3．
[22] 重庆大学电气工程有限公司，德阳电力系统概要设计说明书，2001，9．
[23] 重庆大学电气工程有限公司，德阳电业局电力营销DSS系统(DYYX-DSS)技术协议，1999，12．
[24] 德阳电业局，德阳电业局营销DSS系统(补充材料)，2000，4．
[25] 德阳电业局，德阳电业局营销DSS系统需求分析说明书，1999，11．
[26] 李敏强，潘振江，基于数据仓库技术的决策支持系统的研究和应用 天津大学管理学院学报，2001，12卷15期．
[27] Liang T P, Critical success factor of decision support systems: An experimental study.Database Winter, 1986.
[28] Bolen.R.michelle，Oracle数据库应用，机械工业出版社，1999，2．
[29] Al.Kete.Dome，Sybase程序员指南，机械工业出版社，1999，12．
[30] Mc.Hanlen，Microsoft SQL Server2000入门与精通，电子工业出版社，2000，7．
[31] 钱大琳，刘峰，决策支持系统的再认识，北方交通大学学报，1994，18卷12期，p552～555．