动车段(所)调度与检修分析数据仓库方案的研究  

A Study on the Data Warehouse of EMU Scheduling and Maintenance

作　　者：刘隽[1] 杨洪权[1] LIU Jun, YANG Hong-quan(Signal ＆ Communication Research Institute, China Academy of Railway Sciences, Beijing 100081, Chin)

机构地区：[1]中国铁道科学研究院通信信号研究所,北京100081

出　　处：《铁道运输与经济》2018年第3期34-38,68,共6页Railway Transport and Economy

基　　金：中国铁路总公司科技研究开发计划重点课题(2012X004-H)

摘　　要：为充分利用动车段(所)调度与检修业务数据,实现对动车组的高效运用与检修,在阐述动车段(所)调度与检修作业流程及信息系统运用现状的基础上,基于现代数据仓库和商业智能理论,研究动车段(所)调度与检修分析数据仓库总体方案,即:数据仓库逻辑结构,数据仓库配置方案,数据源组织,数据仓库设计,ETL工程,数据分析与展现等。从我国高速铁路动车组运用与检修管理的实际需求出发,为我国动车段(所)调度与检修分析数据仓库方案构建提供参考。EMU trains can be better utilized and maintained by taking full advantages of data from the EMU scheduling and maintenance system.This paper firstly elaborates on the workflow of EMU scheduling,maintenance and information system application.Based on the theories of modern data warehouses and business intelligence,this paper also analyzes the general plan of the data warehouse where EMU scheduling and maintenance are conducted,including the logical structure,configuration,source management,design,ETL projects and data analysis and presentation.The study,which highlights the practical requirements for the application and maintenance of EMU trains,is expected to serve as reference points for establishing the Data Warehouse of EMU Scheduling and Maintenance.

关 键 词：高速铁路 动车段(所) 数据仓库 商业智能 联机分析处理 

分 类 号：U269[机械工程—车辆工程] TP311.13[交通运输工程—载运工具运用工程]