高速铁路牵引供电SCADA系统调度端数据仓库设计

针对我国高速铁路(HSR)牵引供电(TPS) SCADA调度端保存的海量数据,分析了传统数据库的特点及不足,提出利用数据仓库技术将操作型数据从日常事务处理(OLTP)系统应用环境中分离出来,构造分析决策型应用环境,提高牵引供电SCADA系统决策支持能力.设计了牵引供电SCADA系统数据仓库体系结构,以实现对牵引供电SCADA设备故障进行深入分析,为对保护动作进行评判及事故预测提供依据.根据挖掘主题,对牵引供电SCADA调度端数据仓库给出了详细的设计(包括事实表、公共维表和私有维表设计),并对数据仓库的实施作了阐述.

Design of Data Warehouse Totps SCADA System

With the development of computer and railway automation technology,the more and more SCADA systems have been applied in the traction power supply system in Chinese high speed railway,which results massive quantities of accumulative date in the dispatching center of SCADA system.This paper analyses the deficiency of the current SCADA system and puts forward the method of separating analytical data from OLTP systems with the data warehouse,which will improve the ability of decision support.Finally it provides...