数据库动态描述及上层数据服务子系统的设计与实现
|
摘要
随着Internet和计算机技术的飞速发展,企业对于过程工业监测这一生产环节有着越来越高的要求。为了自动适应每个过程工业企业自身不同的企业结构和对监测不同的需求、为了保证监测系统的实时性、为了避免客户监测子系统巨大的重复性配置工作、同时也为提高软件的复用率,笔者所在实验室课题组通过多年来在该领域研究成果的分析和总结,设计了一套通用的分布式监测平台。
本文详述了核心子系统-数据服务子系统的数据库结构的设计。首先提出了一种数据库表结构与信息树的映射机制,满足了用户可定制系统的需求,同时屏蔽数据库,实现其它子系统对服务子系统的通用查询;并为了配合课题组其他同学的研究,如子系统配置动态更新的需求,数组机制下的数据传递等,设计了一整套复杂的数据库结构,进而从整体上实现了数据库的动态描述;然后根据以往监测系统的应用经验,通过对多年来实验室在数据监视领域研究成果的继承和发展,总结了大部分可能存在的数据服务;最后分析比较了多种协议并最终确定了分别与B/S,C/S子系统通信协议的选取,并完成了和其他子系统间的接口实现。
在设计和实现的过程中,使用了多种经典计算机技术和设计思想,并结合了数据库的诸多优化策略,力争将本系统做到全面周到又详细入微。
With the rapid development of Internet and computer technology, enterprises demand much higher on the process industry monitoring aspect of their production. In order to automatically adapt to different industrial enterprises in their own corporate structures and different needs of the monitoring, in order to guarantee real-time monitoring system, in order to avoid client monitoring subsystem configuration repeatability enormous job, but also to improve software reuse rate, the author is located at the laboratory team, through years of research results in the field to analyze and summarize, design a set of common distributed monitoring platform.
This article details the core subsystems - data services subsystem database structure design. First, one mechanism is proposed to map database table structure and information tree, in order to meet the needs that system can be customized, while shielding database, implementation of other subsystems of the Common Services Subsystem inquiries; Besides, to satisfy other classmates' research in the same group, such as subsystem configuration updates dynamically, the data transfer in the array mechanism, the author designs a set of complex database structure, and thus on the overall implements the dynamic description of the database; And then through Over past experience in the application of monitoring system, based on the inheritance and development in the field of laboratory research achievements, the author summarizes the majority of data services that may exist; Finally chose interaction protocol with the B/S, C/S subsystem through analysis and comparison, and completes interface definition with other subsystems.
In the design and implementation process, the author uses a variety of classic computer technology and design idea, combined with a database of many optimization strategies, and strive to be considerate of the system to achieve a comprehensive and detailed attention.
本文详述了核心子系统-数据服务子系统的数据库结构的设计。首先提出了一种数据库表结构与信息树的映射机制,满足了用户可定制系统的需求,同时屏蔽数据库,实现其它子系统对服务子系统的通用查询;并为了配合课题组其他同学的研究,如子系统配置动态更新的需求,数组机制下的数据传递等,设计了一整套复杂的数据库结构,进而从整体上实现了数据库的动态描述;然后根据以往监测系统的应用经验,通过对多年来实验室在数据监视领域研究成果的继承和发展,总结了大部分可能存在的数据服务;最后分析比较了多种协议并最终确定了分别与B/S,C/S子系统通信协议的选取,并完成了和其他子系统间的接口实现。
在设计和实现的过程中,使用了多种经典计算机技术和设计思想,并结合了数据库的诸多优化策略,力争将本系统做到全面周到又详细入微。
With the rapid development of Internet and computer technology, enterprises demand much higher on the process industry monitoring aspect of their production. In order to automatically adapt to different industrial enterprises in their own corporate structures and different needs of the monitoring, in order to guarantee real-time monitoring system, in order to avoid client monitoring subsystem configuration repeatability enormous job, but also to improve software reuse rate, the author is located at the laboratory team, through years of research results in the field to analyze and summarize, design a set of common distributed monitoring platform.
This article details the core subsystems - data services subsystem database structure design. First, one mechanism is proposed to map database table structure and information tree, in order to meet the needs that system can be customized, while shielding database, implementation of other subsystems of the Common Services Subsystem inquiries; Besides, to satisfy other classmates' research in the same group, such as subsystem configuration updates dynamically, the data transfer in the array mechanism, the author designs a set of complex database structure, and thus on the overall implements the dynamic description of the database; And then through Over past experience in the application of monitoring system, based on the inheritance and development in the field of laboratory research achievements, the author summarizes the majority of data services that may exist; Finally chose interaction protocol with the B/S, C/S subsystem through analysis and comparison, and completes interface definition with other subsystems.
In the design and implementation process, the author uses a variety of classic computer technology and design idea, combined with a database of many optimization strategies, and strive to be considerate of the system to achieve a comprehensive and detailed attention.
引文
[1]李广鑫,马志欣,丁振国,周利华.基于B/S结构的远程实时监测系统[J].计算机应用研究,2003,10:147-150
[2]赵方圆,魏志强,林勇.基于构件的可重构软件开发平台技术研究[J].计算机工程与设计,2005,26(1):33-36
[3]周强,史有群,巩敦位.基于数据驱动的监控系统数据服务器设计[J].计算机工程与应用,2002,20:244-246
[4]Pooh Polly,Dillon Tharam,Chang Elizabeth,Feng Ling.XML descriptor based approach for real time data messaging[R].Ninth IEEE International Symposium on Object-Oriented Real-Time Distributed Computing,2006,459-468
[5]刘文彬,高金吉,江志农,杨剑锋,姚伟.基于中间件技术的远程实时监测系统[J].计算机应用研究,2005,(5):189-191
[6]任光胜,杨继东,刘凡银.基于软件复用技术的监控软件设计[J].重庆大学学报,2003,26(6):18-21
[7]张伟,张晓明,边小凡,邵玉敏.通用组件的改装方法[J].计算机应用研究,2002,22(3):148-149
[8]Antonio Mendes da Silva Filho,Junior Toshiraru Saito,Itana Maria de Souza Gimenes.Real-Time Supervisor Modeling for Teleeom Systems[J].IEEE Computer Society,2001:162
[9]季立明,王太勇.基于Winsocket和组件技术的设备远程实时监测系统[J].工业控制计算机,2001,14(5):21-22,31
[10]骆华.基于多层B/S模式的监测系统[J].现代计算机,2004,(201):23-26
[11]彭四伟,朱群雄.过程工业监测系统中的行为定制[J].控制工程,2005,12(4):289-291
[12]A.Zerzelidis,A.J.Wellings.Requirements for a Real-Time.NET Framework[J].SIGPLAN Notices,2005,40(2):86-89
[13]范敏,福成,吴勇军.一种基于元数据的Web数据共享技术[J].绵阳师范学院学报,2004,23(2):34-40
[14]Erik Meijer,Brian Beckman,Gavin Bierman.Reconciling Objects Relations and XML in the.NET Framework[J].SIGMOD,2006,27-29
[15]李学荣,李莎.基于元数据的异构数据源集成系统设计与实现[J].计算机应用,2005,(25):209-210
[16]陈小青,殷宏.基于元数据的数据库分析与设计方法[J].计算机工程与应用,2002,13:195-197
[17]杨强,基于.NET的远程监控决策平台的设计和实现[D].西安:西安科技大学,2003
[18]Lothar Thiele,Ernesto Wandeler,Nikolay Stoimenov.Real-Time Interfaces for Composing Real-Time Systems[J].EMSOFT,2006,22-25
[19]姜丽华.主动实时数据库管理系统[D].保定:华北电力大学,2004
[20]杨华丽,石锐,胡捷,秦鹏.组态软件中实时数据库系统的设计和实现[J].实验技术与管理,2007,24(3):80-83
[21]贺耀宜,汤利平,刘晋坤.基于Web的可组态实时监控系统的开发和应用[J].工矿自动化,2005,2:1-3
[22]赵恒永,彭四伟.过程工业监测系统中的交互协议设计[J].北京化工大学学报,2000,27(4):72-74,88
[23]汪维敏.基于C/S,B/S混合结构的分布式测控系统[D].西安:西北工业大学,2003.
[24]Xingmei Feng,Yanping Li,Liang Chen.Real-time Supervisory Control and Scheduling for Complex Industrial Process Based on Integrated Modeling[J].IEEE Computer Society,2006:45
[25]刘波,雷刚跃,杨路明.基于.NET平台通用数据库组件的设计与实现[J].计算机工程与设计,2007,28(6):1415-1417
[26]唐伟,施永香,文巨峰.基于.NET的通用查询组件的开发[J].计算机工程与设计,2007,27(14):2708-2711
[27]王孝明,胡健,陆坤,周伟.基于.NET平台可复用软件框架的设计与实现[J].计算机工程,2004,30(22):76-78
[28]J.Lapalme,E.M.Aboulhamid,G.Nicolescu,L.Charest,F.R.Boyer,J.P David,G.Bois..NET Framework—A Solution for the Next Generation Tools for System-Level Modeling and Simulation Proceedings of the Design[R].Automation and Test in Europe Conference and Exhibition,2004,1530-1591
[29]许南山,史东林,彭四伟,翁海昕.实时监测平台数据服务子系统的设计[J].计算机系统应用,2006,12:69-71
[30]王普,郭继业,孙崇正,等.基于SQLServer2000的组态软件实时数据库[J].北京工业大学学报,2006,32(3):197-201
[31]Ernesto Wandeler,Lothar Thiele.Real-Time Interfaces for Interface-Based Design of Real-Time Systems with Fixed Priority Scheduling[J].EMSOFT,2005,19-22.
[32]吴平,王安.元数据在全动态数据库系统中使用方法的探讨[J].计算机与农业,2002,(11):34-36
[33]郭昭,谭庆平.基于XML的可定制软件开发平台配置的设计和实现[J].长沙大学学报,2005,19(2):48-51
[34]Oberwinlder Christian,Stundner Michael.From real-time data to production optimization[J].SPE Production and Facilities,2005,229-239
[35]林冰玉,彭四伟,汪须忠.软件开发自动化平台的研究与应用[J].计算机工程与应用,2005(9):122-125
[36]Wang Cuiru,Liu Shuangxi.SOA based electric power real-time data warehouse[R].2008Workshop on Power Electronics and Intelligent Transportation System,2008,355-359
[37]Cen Ming,Jiang Jianchun,Hu Ruifei.Real-time data superaddition method based on triggers[R].Proceedings of the World Congress on Intelligent Control and Automation (WCICA),2008,6227-6231
[38]马保国,王连锋,李华刚.XML在Socket方式实时数据交换中的应用[J].计算机技术与发展,2007,(5):18-20
[2]赵方圆,魏志强,林勇.基于构件的可重构软件开发平台技术研究[J].计算机工程与设计,2005,26(1):33-36
[3]周强,史有群,巩敦位.基于数据驱动的监控系统数据服务器设计[J].计算机工程与应用,2002,20:244-246
[4]Pooh Polly,Dillon Tharam,Chang Elizabeth,Feng Ling.XML descriptor based approach for real time data messaging[R].Ninth IEEE International Symposium on Object-Oriented Real-Time Distributed Computing,2006,459-468
[5]刘文彬,高金吉,江志农,杨剑锋,姚伟.基于中间件技术的远程实时监测系统[J].计算机应用研究,2005,(5):189-191
[6]任光胜,杨继东,刘凡银.基于软件复用技术的监控软件设计[J].重庆大学学报,2003,26(6):18-21
[7]张伟,张晓明,边小凡,邵玉敏.通用组件的改装方法[J].计算机应用研究,2002,22(3):148-149
[8]Antonio Mendes da Silva Filho,Junior Toshiraru Saito,Itana Maria de Souza Gimenes.Real-Time Supervisor Modeling for Teleeom Systems[J].IEEE Computer Society,2001:162
[9]季立明,王太勇.基于Winsocket和组件技术的设备远程实时监测系统[J].工业控制计算机,2001,14(5):21-22,31
[10]骆华.基于多层B/S模式的监测系统[J].现代计算机,2004,(201):23-26
[11]彭四伟,朱群雄.过程工业监测系统中的行为定制[J].控制工程,2005,12(4):289-291
[12]A.Zerzelidis,A.J.Wellings.Requirements for a Real-Time.NET Framework[J].SIGPLAN Notices,2005,40(2):86-89
[13]范敏,福成,吴勇军.一种基于元数据的Web数据共享技术[J].绵阳师范学院学报,2004,23(2):34-40
[14]Erik Meijer,Brian Beckman,Gavin Bierman.Reconciling Objects Relations and XML in the.NET Framework[J].SIGMOD,2006,27-29
[15]李学荣,李莎.基于元数据的异构数据源集成系统设计与实现[J].计算机应用,2005,(25):209-210
[16]陈小青,殷宏.基于元数据的数据库分析与设计方法[J].计算机工程与应用,2002,13:195-197
[17]杨强,基于.NET的远程监控决策平台的设计和实现[D].西安:西安科技大学,2003
[18]Lothar Thiele,Ernesto Wandeler,Nikolay Stoimenov.Real-Time Interfaces for Composing Real-Time Systems[J].EMSOFT,2006,22-25
[19]姜丽华.主动实时数据库管理系统[D].保定:华北电力大学,2004
[20]杨华丽,石锐,胡捷,秦鹏.组态软件中实时数据库系统的设计和实现[J].实验技术与管理,2007,24(3):80-83
[21]贺耀宜,汤利平,刘晋坤.基于Web的可组态实时监控系统的开发和应用[J].工矿自动化,2005,2:1-3
[22]赵恒永,彭四伟.过程工业监测系统中的交互协议设计[J].北京化工大学学报,2000,27(4):72-74,88
[23]汪维敏.基于C/S,B/S混合结构的分布式测控系统[D].西安:西北工业大学,2003.
[24]Xingmei Feng,Yanping Li,Liang Chen.Real-time Supervisory Control and Scheduling for Complex Industrial Process Based on Integrated Modeling[J].IEEE Computer Society,2006:45
[25]刘波,雷刚跃,杨路明.基于.NET平台通用数据库组件的设计与实现[J].计算机工程与设计,2007,28(6):1415-1417
[26]唐伟,施永香,文巨峰.基于.NET的通用查询组件的开发[J].计算机工程与设计,2007,27(14):2708-2711
[27]王孝明,胡健,陆坤,周伟.基于.NET平台可复用软件框架的设计与实现[J].计算机工程,2004,30(22):76-78
[28]J.Lapalme,E.M.Aboulhamid,G.Nicolescu,L.Charest,F.R.Boyer,J.P David,G.Bois..NET Framework—A Solution for the Next Generation Tools for System-Level Modeling and Simulation Proceedings of the Design[R].Automation and Test in Europe Conference and Exhibition,2004,1530-1591
[29]许南山,史东林,彭四伟,翁海昕.实时监测平台数据服务子系统的设计[J].计算机系统应用,2006,12:69-71
[30]王普,郭继业,孙崇正,等.基于SQLServer2000的组态软件实时数据库[J].北京工业大学学报,2006,32(3):197-201
[31]Ernesto Wandeler,Lothar Thiele.Real-Time Interfaces for Interface-Based Design of Real-Time Systems with Fixed Priority Scheduling[J].EMSOFT,2005,19-22.
[32]吴平,王安.元数据在全动态数据库系统中使用方法的探讨[J].计算机与农业,2002,(11):34-36
[33]郭昭,谭庆平.基于XML的可定制软件开发平台配置的设计和实现[J].长沙大学学报,2005,19(2):48-51
[34]Oberwinlder Christian,Stundner Michael.From real-time data to production optimization[J].SPE Production and Facilities,2005,229-239
[35]林冰玉,彭四伟,汪须忠.软件开发自动化平台的研究与应用[J].计算机工程与应用,2005(9):122-125
[36]Wang Cuiru,Liu Shuangxi.SOA based electric power real-time data warehouse[R].2008Workshop on Power Electronics and Intelligent Transportation System,2008,355-359
[37]Cen Ming,Jiang Jianchun,Hu Ruifei.Real-time data superaddition method based on triggers[R].Proceedings of the World Congress on Intelligent Control and Automation (WCICA),2008,6227-6231
[38]马保国,王连锋,李华刚.XML在Socket方式实时数据交换中的应用[J].计算机技术与发展,2007,(5):18-20