摘要
电气化铁路接触网在日常运维过程中积累了海量的业务数据,这些数据能够为接触网PHM提供支持,但其通常具有多源、异构、种类繁多等特点。为了从全局出发对接触网业务数据进行综合分析研究,本文引入了数据仓库的概念,提出接触网数据仓库的总体架构,并依据维度建模技术设计了接触网数据仓库,包括主题域、维度表、事实表和数据粒度的设计,最终形成了接触网数据仓库的星座数据模型。
Massive business data are accumulated during process of daily operation and maintenance of OCS of electrified railways,though these data are able to provide support for PHM of OCS,they are featuring of multiple sources,heterogeneous and great varieties.In order to make a thorough comprehensive researches on the OCS business data,the paper introduces the concept of data warehouse,puts forward the overall framework of OCS business data.An OCS data warehouse is designed in accordance with the dimension modeling technology,including design of subject domain,dimension table,fact table and data granularity,and on the basis of which,a constellation model for OCS data warehouse is finally formed.
作者
何冠霖
高仕斌
于龙
HE Guanlin;GAO Shibin;YU Long
出处
《电气化铁道》
2019年第5期6-11,16,共7页
Electric Railway
关键词
接触网
数据仓库
维度建模
PHM
事实表
维度表
OCS
data warehouse
dimensional modeling
PHM
fact table
dimension table
