基于数据仓库和OLAP的民航灾害预警决策支持系统

为解决民航灾害预警管理中的多数据源和多目标决策的问题,构建了基于数据仓库和联机分析(OLAP)技术的民航灾害预警决策支持系统.该系统包括应用界面层、辅助决策功能层、库管理及接口层、信息库层和数据层。数据仓库的主题是航空公司、空管中心和机场的预警指标.设计了地域、机构、指标名称和时间4个维度,数据仓库雪花模型,以及年度、季度和月份3种粒度.数据仓库的分割方案是首先按地区维分割,再按机构维分割.#介绍了多维决策分析过程,包括切片、切块和旋转等操作.

Civil Aviation Decision Support System for Early Warning of Disasters Based on Data Warehouse and Online Analytical Processing

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.