Civil Aviation Decision Support System for Early Warning of Disasters Based on Data Warehouse and Online Analytical Processing
-
摘要: 为解决民航灾害预警管理中的多数据源和多目标决策的问题,构建了基于数据仓库和联机分析(OLAP)技术的民航灾害预警决策支持系统.该系统包括应用界面层、辅助决策功能层、库管理及接口层、信息库层和数据层。数据仓库的主题是航空公司、空管中心和机场的预警指标.设计了地域、机构、指标名称和时间4个维度,数据仓库雪花模型,以及年度、季度和月份3种粒度.数据仓库的分割方案是首先按地区维分割,再按机构维分割.#介绍了多维决策分析过程,包括切片、切块和旋转等操作.Abstract: An early warning decision support system for civil aviation disasters was constructed based on data warehouse and online analytical processing(OLAP) to utilize the data from multiple sources and to provide a support to multi-objective decision making.The system includes 5 layers: application interface layer,auxiliary decision making function layer,warehouse management and data interface layer,information warehouse layer and data layer.The subject of the data warehouse consists of the early warning indices of airline companies,aviation control centers and airports.Four dimensions(geological area,organization,index and time),the snow model for the data warehouse,and 3 granularities(annual,quarterly and monthly) were designed.The partitioning scheme for the data warehouse is to do partitioning on the geological area dimension first followed by partitioning on the organization dimension.The multidimensional decision making procedure,including slicing,dicing and rotation,was discussed.
-
FINK A,SIEBE,KUHLE J P.How scenarios support strategic early warning processes[J].Foresight,2004,6 (3):173-185.[2] SKYTTNER L.Monitoring and early warning systems-a design for human survival[J].Kybernetes,2002,31 (2):220-245.[3] PERRY R W.Incident management systems in disaster management[J].Disaster Prevention and Management,2003,12(5):405-412.[4] 杨昌其,魏光兴.空管不安全事件危险等级的量化评估方法[J].西南交通大学学报,2006(6):753-757.YANG Changqi,WEI Guangxing.Quantitative assessment method for severity classification of air traffic control Incidents[J].Journal of Southwest Jiaotong University,2006 (6):753-757.[5] 王恩德,刘国斌.基于经济景气分析数据仓库的设计与实现[J].吉林大学学报(信息科学版),2005(7):416-420.WANG Ende,LIU Guobin.Design and realization of data warehouse based on economic climate analysis[J].Journal of Changchun Post and Telecommunication Institute,2005 (7):415-420.[6] 罗帆,余廉,顾必冲.航空公司交通灾害预警指标体系的构建[J].武汉理工大学学报(交通科学与工程版),2004,28(3):361-364 LUO Fan,SHE Lian,GU Bichong.Constructing the system of early warning indexes for transportation disasters of an airline[J].Journal of Wuhan University of Technology,2004,28 (3):361-364.
点击查看大图
计量
- 文章访问数: 1304
- HTML全文浏览量: 48
- PDF下载量: 370
- 被引次数: 0