电力生产工程计划管理系统的设计与实现
|
摘要
直辖后的重庆，电力工业迅猛发展，大量电力建设和技术改造纷纷实施，工程管理任务益加艰巨。然而目前采用的管理方式相对落后，迫切需要采用新技术、新手段和新方法来提高管理效率。工程管理中有大量的项目信息传输和存储需求，而网络和数据库技术就是能有效解决该类问题的成熟技术，由此论文结合实际情况，尝试采用这些技术解决面临的问题。
作为课题研究的技术背景知识，论文简要地回顾了网络技术的发展和应用历史，对先进的.NET技术进行了重点阐述，同时还概要地介绍了关系数据库技术的基础知识。
在电力生产工程计划管理系统的概要设计中，论文从体系结构、工作模式和软件实现方式等方面给出了系统结构框架。在系统的实施中，文章则分别从后台数据库、前端界面以及报表模块等方面具体阐述了待考虑和解决的主要问题。
接下来在系统详细设计和方案实现中，论文主要从三个方面进行论述，即①后台数据库设计与实现：系统采用Sybase数据库管理系统作为后台数据服务，通过对工程管理的流程整理和分析，给出了建库的实施过程，同时采用了数据集市技术实现工程信息的管理，采取文件和数据库结合的方法对文档信息进行管理；②前台界面设计与实现：在课题的研究中，应用先进的ASP.NET技术创建Web应用程序，它结合了桌面程序强大的交互能力和Web方便的信息发布能力，而在后台数据访问中采用ADO.NET技术来完成；③报表模块设计与实现：论文在总结目前多种报表的优缺点后，提出了一种Web报表解决方案，即通过客户端的软件实现信息查询并将返回数据导入Excel中，借助其强大和灵活的表格处理能力，在电力生产工程计划管理系统中实现用户定制报表功能，其中Web服务技术起了关键作用。
论文综合应用了数据库、数据集市、.NET和Web服务等先进技术，设计和实现了“电力生产工程计划管理系统”，它建立了电力建设信息的网络传输和存储功能，其应用覆盖公司下属各个企业所有生产工程管理过程，在生产工程管理中完成了对信息技术的应用实践。
Rapid development has taken place in electric power industry in Chongqing since it was directly under the jurisdiction of central government, and a lot of electric power constructions and technology reconstructions have been carried into execution in succession, thus the task of engineering management becomes tougher and tougher. However, the management mode lags behind comparatively, new technology and method must be adopted in imminence in order to enhance management efficiency. Plenty of information in project needs to be transferred and stored, the mature technologies such as network and database can solve these problems effectively. In this thesis, those technologies were introduced to meet the demand which comes from practice.
As the backgrounds of this research, the history of network development and application was reviewed briefly in this thesis, the advanced technology of .NET was explanation in detail, and the basic knowledge of relational database was introduced generally.
In this research, the outline design of power engineering system is comprised of three aspects: system structure, wok pattern, and software implementation mode; the implementation stage was separated into background database, front-end interface and report module, and lots of problems were brought forward.
In the section of realizing the detailed design and implementation of the system, the thesis dissertated the above three aspects in emphasis. Firstly, the design and implementation of background database: 'Sybase' database management system was adopted in this system to provide data service and database can be built through analyzing the construction operation flow; data warehouse technology was introduced in this research as well. In the meantime, the integrated method combining the file system and database was adopted into the document management. Secondly, in the front-end interface part, the ASP.NET was applied to create web applications which have good mutual capacity and strong release capability, and ADO.NET was used for data accessing. Finally, as for report module, by summarizing many kinds of report forms, a kind of web report forms' solution was put forward. In this scheme, users can get information from remote database server and then input them into Excel application with the help of client software. Because Excel has powerful and flexible capability in handling tables, users can make customized report by themselves. In this course, web service has made crucial effect.
Database, database warehouse, .Net and web service technologies were combined in this thesis, and a project management of electric power production engineering was designed and implemented at last which accomplished electric construction information transferring and storing and can be used in electric power activities. It's practice of information technology's application.
作为课题研究的技术背景知识，论文简要地回顾了网络技术的发展和应用历史，对先进的.NET技术进行了重点阐述，同时还概要地介绍了关系数据库技术的基础知识。
在电力生产工程计划管理系统的概要设计中，论文从体系结构、工作模式和软件实现方式等方面给出了系统结构框架。在系统的实施中，文章则分别从后台数据库、前端界面以及报表模块等方面具体阐述了待考虑和解决的主要问题。
接下来在系统详细设计和方案实现中，论文主要从三个方面进行论述，即①后台数据库设计与实现：系统采用Sybase数据库管理系统作为后台数据服务，通过对工程管理的流程整理和分析，给出了建库的实施过程，同时采用了数据集市技术实现工程信息的管理，采取文件和数据库结合的方法对文档信息进行管理；②前台界面设计与实现：在课题的研究中，应用先进的ASP.NET技术创建Web应用程序，它结合了桌面程序强大的交互能力和Web方便的信息发布能力，而在后台数据访问中采用ADO.NET技术来完成；③报表模块设计与实现：论文在总结目前多种报表的优缺点后，提出了一种Web报表解决方案，即通过客户端的软件实现信息查询并将返回数据导入Excel中，借助其强大和灵活的表格处理能力，在电力生产工程计划管理系统中实现用户定制报表功能，其中Web服务技术起了关键作用。
论文综合应用了数据库、数据集市、.NET和Web服务等先进技术，设计和实现了“电力生产工程计划管理系统”，它建立了电力建设信息的网络传输和存储功能，其应用覆盖公司下属各个企业所有生产工程管理过程，在生产工程管理中完成了对信息技术的应用实践。
Rapid development has taken place in electric power industry in Chongqing since it was directly under the jurisdiction of central government, and a lot of electric power constructions and technology reconstructions have been carried into execution in succession, thus the task of engineering management becomes tougher and tougher. However, the management mode lags behind comparatively, new technology and method must be adopted in imminence in order to enhance management efficiency. Plenty of information in project needs to be transferred and stored, the mature technologies such as network and database can solve these problems effectively. In this thesis, those technologies were introduced to meet the demand which comes from practice.
As the backgrounds of this research, the history of network development and application was reviewed briefly in this thesis, the advanced technology of .NET was explanation in detail, and the basic knowledge of relational database was introduced generally.
In this research, the outline design of power engineering system is comprised of three aspects: system structure, wok pattern, and software implementation mode; the implementation stage was separated into background database, front-end interface and report module, and lots of problems were brought forward.
In the section of realizing the detailed design and implementation of the system, the thesis dissertated the above three aspects in emphasis. Firstly, the design and implementation of background database: 'Sybase' database management system was adopted in this system to provide data service and database can be built through analyzing the construction operation flow; data warehouse technology was introduced in this research as well. In the meantime, the integrated method combining the file system and database was adopted into the document management. Secondly, in the front-end interface part, the ASP.NET was applied to create web applications which have good mutual capacity and strong release capability, and ADO.NET was used for data accessing. Finally, as for report module, by summarizing many kinds of report forms, a kind of web report forms' solution was put forward. In this scheme, users can get information from remote database server and then input them into Excel application with the help of client software. Because Excel has powerful and flexible capability in handling tables, users can make customized report by themselves. In this course, web service has made crucial effect.
Database, database warehouse, .Net and web service technologies were combined in this thesis, and a project management of electric power production engineering was designed and implemented at last which accomplished electric construction information transferring and storing and can be used in electric power activities. It's practice of information technology's application.
引文
[1] 袁清，基于Internet的动态网页制作，计算机时代，1999．4
[2] 武苍林，Web技术发展综述，电脑与信息技术，2000．2，pp48-50
[3] 陈庆章，WWW的未来发展趋势，计算机应用，1997，17(1)：2
[4] 陈友清，利用ASP技术开发Intenet／Intranet网上数据库应用程序，湖北邮电技术，1999．12pp26-30
[5] Joe Martin,Brett Tomson著，万松明等译，循序渐进ASP．NET教程，北京，人民邮电出版社，2002．1
[6] Stephen Walther著，马朝晖译，ASP．NET技术内幕，北京，机械工业出版社，2002．8
[7] Greg Buczek著，程永敬等译，ASP．NET技术与技巧，北京，机械工业出版社，2003．2
[8] 王珊，罗力，从数据库到数据仓库，中国人民大学数据与知识工程研究所，1997
[9] 精锐工作组编著，Visual Basic.net网络数据库整合应用，北京，人民邮电出版社，2001．11
[10] 李小琳，李文印等，基于数据仓库的动态报表系统设计与实现，长春邮电学院学报，2001
[11] 晓通数据库研究所，如何使用Sybase Central进行系统管理，呼和浩特，内蒙古人民出版社，1998．11
[12] 蒋春花，冯录刚等，Sybase数据库系统的应用开发，北京，地震出版社，2002．8
[13] 王珊，Sybase原理高级系统管理与性能调优，北京，中国水利水电出版社，1998．8
[14] 邵佩英，杨孝如，Sybase数据库系统知识，北京，中国水利水电出版社，2001．10
[15] 陈峰，数据仓库技术综述，重庆工学院学报，2002．4
[16] Chen LD, Frolick MN. Web based Data Warehousing Fundamentals,Challenges, and Solutions. Information System Management, 2000, (1)
[17] Calkins, M, Internet Security for Data Warehouses, Journal of Data Warehousing(3:1),1998,12-17.
[18] Joyce Bischoff，Ted Alexander,数据仓库技术，成栋，魏立源译，北京，电子工业出版社，1998
[19] 李德毅，从数据库中发现知识的策略和方法，计算机世界报，1995．3
[20] Castelluccio, M., Data Warehouse, Marts, Metadata, OLAP/ROLAP, and Data Mining A Glossary, Management Accounting(4:78), 1996,.59-61.
[21] Gardner, D., Cashing in with Data Warehouses and the Web, Data Based Adviser,February, 1997, 60-64.
[22] Gardner, S., R., Building the Data Warehouse. Communications of ACM(41:9), September 1998, 52-58.
[23] Howie, G., Warehouses: Innovate, Integrate and Liberate, Computing Canada(24:15),1998,35-36.
[24] Ladley, J., Data Warehousing Trends, Data Adviser, January 1998, 35-367.
[25] Orr, K.,Data Warehousing Technology, 1996-1997.
[26] 何雪梅，唐常杰等，基于Web的数据仓库的研究，计算机应用，1998．10
[27] 刘立波，数据仓库技术的研究与应用，计算机工程与应用，2002．15
[28] 李敏强，纪仕光，陈富赞，潘振江，数据仓库系统的结构与设计研究，决策与决策支持系统，1997．2
[29] Liao Lin, Wang Ligang, Liu Wenhuang, Build the Web-based Data Warehouse with XML. The 7th Joint International Computer Conference, 2000.11
[30] White, C., Building Web Information Systems, Byte(23:7), July 1998, 80-83.
[31] Inmon W H.. Building Data Warehouse, Second Edition, John Wiley, 1996
[32] Lou Agosta, The Essential Guide to Data Warehousing, Prentice-Hall, 2000
[33] 胡侃，夏绍伟，基于大型数据仓库的数据采掘，软件学报，1998．1
[34] E. Thomsen, OLAP Solutions: Building Multidimensional Information Systems, John Wiley & Sons, 1997
[35] S. chaudhuri, U, Dayal, An overview of data warehousing and OLAP technology, ACM SIGMOD Record, 1997
[36] A. Berson, J. Smith, Data Warehousing, Data Mining and OLAP, McGraw-Hill, 1997
[37] M.J.A. Berry, G. Linoff. Mastering Data Mining: The Art Science of Customer Relationship Management. John Wiley &Sons, 1999
[38] 毕潜，李飞，利用ASP+ADO访问站点数据库，计算机应用研究，2000．5，pp81-83
[39] 陆东云等，以客户为中心的浏览器服务器(BS)网络计算模型，计算机与应用化学，2001．7
[40] 李海燕等，用Delphi编写高效的客户服务器应用系统，微型电脑应用，2001．12
[41] Steve Teixeria,Xavier Pacheco著，任旭钧，王永生等，Delphi 5开发人员指南，北京，机械工业出版社，2000．7
[42] 刘艺著，Delphi 6企业级解决方案及应用剖析，北京，机械工业出版社，2002．7
[43] 魏鹰，通用报表系统的设计思想，广西科学院学报，1995．6
[44] 刘子林，卜怀原，利用OLE Automation实现Delphi与Excel的集成，重庆工业高等专科学校学报，2001．9
[45] 邓亚玲，王新房等，OLE Automation技术在MIS报表制作中的应用，陕西工学院学报，2001．3
[46] 曹芝兰，王汉江，基于Delphi+Execl 2000制作复杂报表，2000．12
[47] 吕振洪，周全，Delphi与Excel快速数据接口，自动化技术与应用，2001．2
[2] 武苍林，Web技术发展综述，电脑与信息技术，2000．2，pp48-50
[3] 陈庆章，WWW的未来发展趋势，计算机应用，1997，17(1)：2
[4] 陈友清，利用ASP技术开发Intenet／Intranet网上数据库应用程序，湖北邮电技术，1999．12pp26-30
[5] Joe Martin,Brett Tomson著，万松明等译，循序渐进ASP．NET教程，北京，人民邮电出版社，2002．1
[6] Stephen Walther著，马朝晖译，ASP．NET技术内幕，北京，机械工业出版社，2002．8
[7] Greg Buczek著，程永敬等译，ASP．NET技术与技巧，北京，机械工业出版社，2003．2
[8] 王珊，罗力，从数据库到数据仓库，中国人民大学数据与知识工程研究所，1997
[9] 精锐工作组编著，Visual Basic.net网络数据库整合应用，北京，人民邮电出版社，2001．11
[10] 李小琳，李文印等，基于数据仓库的动态报表系统设计与实现，长春邮电学院学报，2001
[11] 晓通数据库研究所，如何使用Sybase Central进行系统管理，呼和浩特，内蒙古人民出版社，1998．11
[12] 蒋春花，冯录刚等，Sybase数据库系统的应用开发，北京，地震出版社，2002．8
[13] 王珊，Sybase原理高级系统管理与性能调优，北京，中国水利水电出版社，1998．8
[14] 邵佩英，杨孝如，Sybase数据库系统知识，北京，中国水利水电出版社，2001．10
[15] 陈峰，数据仓库技术综述，重庆工学院学报，2002．4
[16] Chen LD, Frolick MN. Web based Data Warehousing Fundamentals,Challenges, and Solutions. Information System Management, 2000, (1)
[17] Calkins, M, Internet Security for Data Warehouses, Journal of Data Warehousing(3:1),1998,12-17.
[18] Joyce Bischoff，Ted Alexander,数据仓库技术，成栋，魏立源译，北京，电子工业出版社，1998
[19] 李德毅，从数据库中发现知识的策略和方法，计算机世界报，1995．3
[20] Castelluccio, M., Data Warehouse, Marts, Metadata, OLAP/ROLAP, and Data Mining A Glossary, Management Accounting(4:78), 1996,.59-61.
[21] Gardner, D., Cashing in with Data Warehouses and the Web, Data Based Adviser,February, 1997, 60-64.
[22] Gardner, S., R., Building the Data Warehouse. Communications of ACM(41:9), September 1998, 52-58.
[23] Howie, G., Warehouses: Innovate, Integrate and Liberate, Computing Canada(24:15),1998,35-36.
[24] Ladley, J., Data Warehousing Trends, Data Adviser, January 1998, 35-367.
[25] Orr, K.,Data Warehousing Technology, 1996-1997.
[26] 何雪梅，唐常杰等，基于Web的数据仓库的研究，计算机应用，1998．10
[27] 刘立波，数据仓库技术的研究与应用，计算机工程与应用，2002．15
[28] 李敏强，纪仕光，陈富赞，潘振江，数据仓库系统的结构与设计研究，决策与决策支持系统，1997．2
[29] Liao Lin, Wang Ligang, Liu Wenhuang, Build the Web-based Data Warehouse with XML. The 7th Joint International Computer Conference, 2000.11
[30] White, C., Building Web Information Systems, Byte(23:7), July 1998, 80-83.
[31] Inmon W H.. Building Data Warehouse, Second Edition, John Wiley, 1996
[32] Lou Agosta, The Essential Guide to Data Warehousing, Prentice-Hall, 2000
[33] 胡侃，夏绍伟，基于大型数据仓库的数据采掘，软件学报，1998．1
[34] E. Thomsen, OLAP Solutions: Building Multidimensional Information Systems, John Wiley & Sons, 1997
[35] S. chaudhuri, U, Dayal, An overview of data warehousing and OLAP technology, ACM SIGMOD Record, 1997
[36] A. Berson, J. Smith, Data Warehousing, Data Mining and OLAP, McGraw-Hill, 1997
[37] M.J.A. Berry, G. Linoff. Mastering Data Mining: The Art Science of Customer Relationship Management. John Wiley &Sons, 1999
[38] 毕潜，李飞，利用ASP+ADO访问站点数据库，计算机应用研究，2000．5，pp81-83
[39] 陆东云等，以客户为中心的浏览器服务器(BS)网络计算模型，计算机与应用化学，2001．7
[40] 李海燕等，用Delphi编写高效的客户服务器应用系统，微型电脑应用，2001．12
[41] Steve Teixeria,Xavier Pacheco著，任旭钧，王永生等，Delphi 5开发人员指南，北京，机械工业出版社，2000．7
[42] 刘艺著，Delphi 6企业级解决方案及应用剖析，北京，机械工业出版社，2002．7
[43] 魏鹰，通用报表系统的设计思想，广西科学院学报，1995．6
[44] 刘子林，卜怀原，利用OLE Automation实现Delphi与Excel的集成，重庆工业高等专科学校学报，2001．9
[45] 邓亚玲，王新房等，OLE Automation技术在MIS报表制作中的应用，陕西工学院学报，2001．3
[46] 曹芝兰，王汉江，基于Delphi+Execl 2000制作复杂报表，2000．12
[47] 吕振洪，周全，Delphi与Excel快速数据接口，自动化技术与应用，2001．2