厂站监控系统中高可用数据库中间件的设计与实现

电力系统对数据存储可靠性有极高的要求,设计并实现了一个高可用数据库中间件MultiDbGate。它通过对连接和访问的动态维护和调度,屏蔽了底层连接、多数据库、双网等问题的复杂性,可以提供廉价而又简单的数据库服务,具备高可用性和可扩展性。介绍了中间件MultiDbGate的结构,分为单数据库接口、连接池、作业调度和日志服务4个模块。单数据库接口模块是对活动数据对象(ADO)的封装;连接池模块是中间件的核心,可以让不同的应用共享连接,并屏蔽了底层的分布式架构;作业调度模块是管理模块,响应应用的请求;日志服务模块通过日志重写保证数据一致性。中间件MultiDbGate已经在某电网的多个220kV变电站监控系统工程应用,效果良好。

Design and realization of high-availability database middleware for substation supervisory control system

Power system demands high reliability of data storage.A database middleware with high-availability,MultiDbGate,is designed and realized,which uses dynamic maintenance and dispatch of connection and access to mask the complexity of bottom layer connection,multi database,dual nets,etc.,and provides cheap and simple database services with high-availability and expansibility.The structure of MultiDbGate is divided into four modules:single database access,connection pool,job management and log service.The single database access module is the encapsulation of ADO(Active Data Objects).As the core,the connection pool module makes applications sharing the connections and masks the distributed architecture of bottom layer.The job management module schedules the requests of applications.The log service module ensures the data consistency by log records.The MultiDbGate runs well in supervisory control systems of several 220 kV substations.