Based On The Data Warehouse Fire Decision Support System Research And Implementation,

Through decades of development,Decision Support System(DSS)has been widely used in the western developed countries.In our country,this technology is still in its infancy.However,DDS has been achieving good acceptances in China.At present,reform of the fire protection affairs is deepened.The government is pushing forward Fire Protection System restructuring and up-grading,in conformity with the international practice.Therefore,the activity of transferring historical data to valuable knowledge becomes more important.In domestic finance,sale and manufacture industries,Decision Support System based on data warehouse and analysis technology has been demonstrated as a good solution.In order to better serve fire system by using information method,the study of establishing Fire Protection Decision Supporting System is proposed.This thesis mainly researched the DSS based on data warehouse and Unified Dimensional Model(UDM).It also introduced in detail the progress of requirement analysis,framework design,data modeling and system implementation.1.Research the status of applications and developments of DSS in our country and abroad,analyze the applications of various domestic industries,summarize the key component of DSS.2.Elicit customer requirements,and research on a suited decision support solution for Fire Protection System,through the study of current service system.3.Design a compatible system frame Structure on the basis of DSS solution,4.Regarding to relatively independent service systems,actions' re taken as follows:analyze logic relationship and data structure,and then complete modeling of data warehouse via defining measure,dividing dimension and its structural levels.5.Study on the effective process and method of data Extract-Transform-Load(ETL),in order to make sure the validity, consistency,completeness and timelines of data in data warehouse. 6.Define multidimensional dataset and establish UDM for heterogeneous data sources,in order to import useful data to DDS and serve it.Many efforts were putted into improve development efficiency and system usability through the study.On the one hand,UDM——a new concept of On-Line Analysis Processing(OLAP),was utilized to make system more effective and adaptive.And on the other hand,QlikView was used to make user interface and display data,which could make system more comfortable to use.The system is at the trial operation stage,and has been proved to be good so far.However,it requires continues improvement since the research is a groping activity.Pressed of time,the system doesn't provide the solution of data-mining,which is considered as the key area of future work.