Civil Aviation Decision Support System for Early Warning of Disasters Based on Data Warehouse and Online Analytical Processing
Ke Li · Journal of Southwest Jiaotong University · 2007
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.