电力生产企业历史数据库构造及展示研究
|
摘要
随着电力生产企业的高度自动化，生产信息数量的极度膨胀，海量的历史数据需要一套科学的方法有机地组织，有效地存储，需要一套高效的管理软件对其进行检索，生成用户可定制的报表，生成明晰的统计信息供管理者对生产计划进行决策。
出于此目的，本文对电力生产企业的实际需求设计了一套基于商用数据库和XML的功能框架，并为电力生产企业量身定做了一套通用的历史数据管理及展示软件—H9000WebReport，以及基于Excel的用户报表定制软件ReportMaker。
作为一个面向数据的系统，本文首先针对满足无人值班(少人值守)的电厂监控系统，讨论了历史数据库的基本框架。在此基础上，结合H9000WebReport讨论了历史数据Web展示系统三层结构的设计，阐述了各组成模块的设计思想，同时对该类型系统的各种实现方法进行了细致的比较研究。
最后，本文针对信息处理领域的部分热点对电厂信息系统的前景提出了一些展望。
With rapid progress of automatic system in power generate sectors, the explosive growth of history data need organic construct, efficient storage, and effective query to produce customized report with accurate data. And managers desire wise statistical analysis to help them make decision.
Aim at it, after investigates the power plant requirement, this paper designs an abstract architecture which base on commercial relation database and XML technology for power plant information management, and realized a practicable history management and presentation software-H9000WebReport base on ASP.NET platform.
Fundamentally, as a data-oriented system, the paper discusses the structure of history database at beginning. Satisfied so-called 'free on duty' requirement of power plant supervise& control system, it stages the necessary database tables and relations between them. Base upon it, the paper describes the three-tiers structure of the framework for H9000WebReport. Besides it the design thought of report template maker -ReportMaker also is introduced in detail.
Finally, according to some popular topics in information exchange field, the paper advocates some possible usage in power sectors and wish of these up-date technologies will achieve more effective and safety information exchange and management in bright future.
出于此目的，本文对电力生产企业的实际需求设计了一套基于商用数据库和XML的功能框架，并为电力生产企业量身定做了一套通用的历史数据管理及展示软件—H9000WebReport，以及基于Excel的用户报表定制软件ReportMaker。
作为一个面向数据的系统，本文首先针对满足无人值班(少人值守)的电厂监控系统，讨论了历史数据库的基本框架。在此基础上，结合H9000WebReport讨论了历史数据Web展示系统三层结构的设计，阐述了各组成模块的设计思想，同时对该类型系统的各种实现方法进行了细致的比较研究。
最后，本文针对信息处理领域的部分热点对电厂信息系统的前景提出了一些展望。
With rapid progress of automatic system in power generate sectors, the explosive growth of history data need organic construct, efficient storage, and effective query to produce customized report with accurate data. And managers desire wise statistical analysis to help them make decision.
Aim at it, after investigates the power plant requirement, this paper designs an abstract architecture which base on commercial relation database and XML technology for power plant information management, and realized a practicable history management and presentation software-H9000WebReport base on ASP.NET platform.
Fundamentally, as a data-oriented system, the paper discusses the structure of history database at beginning. Satisfied so-called 'free on duty' requirement of power plant supervise& control system, it stages the necessary database tables and relations between them. Base upon it, the paper describes the three-tiers structure of the framework for H9000WebReport. Besides it the design thought of report template maker -ReportMaker also is introduced in detail.
Finally, according to some popular topics in information exchange field, the paper advocates some possible usage in power sectors and wish of these up-date technologies will achieve more effective and safety information exchange and management in bright future.
引文
[1] H9000系统没计，中国水利水电科学研究院
[2] ABB Advant System Enterprise Historian Design, ABB Asea Brown Boveri Ltd, Switzerland
[3] ABB DataDirect User Guide Version1.2, ABB Asea Brown Boveri Ltd, Switzerland
[4] John Wakkenbach 等著、牛力等译，Excel 2002宝典，2001，电力工业出版社
[5] DR. Codd, E. F., A Relational Model of Data for Large Shared Data Banks, Communications of the ACM, vol. 13 #6 (June, 1970).
[6] 陈宁江等，多层企业应用的关键：J2EE应用服务器，计算机科学，2003．30．1
[7] 韩兵等，NC2000监控系统历史数据库功能设计与实现，水电厂自动化，2002增刊
[8] Web Services Activity, http://www.w3.org/2002/ws/
[9] Dave Pawson, XSL Frequently Asked Questions ,http://www.dpawson.co.uk/xsl/index.html
[10] 明宇报表，http://www.soft2web.biz
[11] Formula One Report Engine, http://www.reportingengincs.com/products/ercportengine/overview.jsp
[12] ActivcX White Paper, http://www.microsoft.com/com/tcch/ActiveX.asp
[13] Introduction toActiveX Controls,Microsoft Corp.,MSDN,1998.8
[14] Microsoft Platform SDK:Automation, http://msdn.microsoft.com/library/en-us/automat/htm/chapl 3rlq.asp
[15] 潘爱民，ActiveX文档技术，微电脑周刊，1999．04～06
[16] 熊中阳等，三层结构中的数据库访问技术，计算机科学，2000Vo127No．4
[17] HTML4.01,W3C Technical Reports and Publications, http://www.w3.org/TR/1999/REC-htm1401-19991224/
[18] SGML, http://xml.coverpages.org/sgml.html
[19] Web Style Sheet, http://www.w3.org/Style/
[20] CSS, http://www.w3.org/Style/CSS/
[21] CSS1 Specification, http://www.w3.org/TR/REC-CSS1
[22] CSS2 Specification, http://www.w3.org/TR/REC-CSS2
[23] SVG, http://www.w3.org/Graphics/SVG/
[24] XHTML, http://www.w3.org/TR/xhtml1/
[25] XSL, http://www.w3.org/Style/XSL/
[26] James Clark's, Comparison of SGML and XML, http://www.w3.org/TR/NOTE-sgml-xml,html,1997.11.15
[27] Kurt Cagle等著、韩平等译，XSL高级编程，2001，Wrox原版、机械工业出版社译
[28] Simon Robinson等著、康博译，C#高级编程，2002，Wrox原版、清华大学出版社译
[29] Dayid Flanagan著、张铭泽等译，JavaScript权威指南，2003，O'Reilly原版、机械工业出版社译
[30] 孙三才、许熏尹著，C#与ASP.NET程序设计，横逸资讯中国青年出版社
[31] Internet开发人员的验证和安全技术(8570), http://www.microsoft.com/china/msdn/technic/develop/ii/O522a.asp, 1997.10.10, MSDN
[32] Microsoft ACE小组著、王培宇等译，Mirosoft.NET Web应用程序性能测试，2003，Microsoft press原版、清华大学出版社译
[33] M.Shaw,D.Garlan,Software architecture:perspectives on an emerging discipline,1998,清华大学出版社
[34] Peter A. Bromberg, Ph.D,Streaming native Excel Workbooks to the Browser with Office Web Components, http://www.eggheadcafe.com/articles/20021220.asp
[35] Xpath, http://www.w3.org/TR/xpath
[36] XSLT, http://www.w3.org/Style/XSLT/
[37] DOM, http://www.w3.org/DOM/
[2] ABB Advant System Enterprise Historian Design, ABB Asea Brown Boveri Ltd, Switzerland
[3] ABB DataDirect User Guide Version1.2, ABB Asea Brown Boveri Ltd, Switzerland
[4] John Wakkenbach 等著、牛力等译，Excel 2002宝典，2001，电力工业出版社
[5] DR. Codd, E. F., A Relational Model of Data for Large Shared Data Banks, Communications of the ACM, vol. 13 #6 (June, 1970).
[6] 陈宁江等，多层企业应用的关键：J2EE应用服务器，计算机科学，2003．30．1
[7] 韩兵等，NC2000监控系统历史数据库功能设计与实现，水电厂自动化，2002增刊
[8] Web Services Activity, http://www.w3.org/2002/ws/
[9] Dave Pawson, XSL Frequently Asked Questions ,http://www.dpawson.co.uk/xsl/index.html
[10] 明宇报表，http://www.soft2web.biz
[11] Formula One Report Engine, http://www.reportingengincs.com/products/ercportengine/overview.jsp
[12] ActivcX White Paper, http://www.microsoft.com/com/tcch/ActiveX.asp
[13] Introduction toActiveX Controls,Microsoft Corp.,MSDN,1998.8
[14] Microsoft Platform SDK:Automation, http://msdn.microsoft.com/library/en-us/automat/htm/chapl 3rlq.asp
[15] 潘爱民，ActiveX文档技术，微电脑周刊，1999．04～06
[16] 熊中阳等，三层结构中的数据库访问技术，计算机科学，2000Vo127No．4
[17] HTML4.01,W3C Technical Reports and Publications, http://www.w3.org/TR/1999/REC-htm1401-19991224/
[18] SGML, http://xml.coverpages.org/sgml.html
[19] Web Style Sheet, http://www.w3.org/Style/
[20] CSS, http://www.w3.org/Style/CSS/
[21] CSS1 Specification, http://www.w3.org/TR/REC-CSS1
[22] CSS2 Specification, http://www.w3.org/TR/REC-CSS2
[23] SVG, http://www.w3.org/Graphics/SVG/
[24] XHTML, http://www.w3.org/TR/xhtml1/
[25] XSL, http://www.w3.org/Style/XSL/
[26] James Clark's, Comparison of SGML and XML, http://www.w3.org/TR/NOTE-sgml-xml,html,1997.11.15
[27] Kurt Cagle等著、韩平等译，XSL高级编程，2001，Wrox原版、机械工业出版社译
[28] Simon Robinson等著、康博译，C#高级编程，2002，Wrox原版、清华大学出版社译
[29] Dayid Flanagan著、张铭泽等译，JavaScript权威指南，2003，O'Reilly原版、机械工业出版社译
[30] 孙三才、许熏尹著，C#与ASP.NET程序设计，横逸资讯中国青年出版社
[31] Internet开发人员的验证和安全技术(8570), http://www.microsoft.com/china/msdn/technic/develop/ii/O522a.asp, 1997.10.10, MSDN
[32] Microsoft ACE小组著、王培宇等译，Mirosoft.NET Web应用程序性能测试，2003，Microsoft press原版、清华大学出版社译
[33] M.Shaw,D.Garlan,Software architecture:perspectives on an emerging discipline,1998,清华大学出版社
[34] Peter A. Bromberg, Ph.D,Streaming native Excel Workbooks to the Browser with Office Web Components, http://www.eggheadcafe.com/articles/20021220.asp
[35] Xpath, http://www.w3.org/TR/xpath
[36] XSLT, http://www.w3.org/Style/XSLT/
[37] DOM, http://www.w3.org/DOM/