Design And Implement Of City Management DSS Based On Data Warehouse

Data warehouse is the technology transferring collected data into significative information. Data warehouse performs through multithreading courses, which include collecting data, filtrating data and storing data in order to use these data in analyzing and reporting application to support analysis and disposal of decision. The main target of decision supportive system is to affirm data structure and tendency to help related decision-makers make better decisions. The continuous development and improvement of related technology on database as well as online analysis process (OLAP) tools make the development of decision supporting system based on DW possible.City management is a project relating to the national economy and the people's livelihood. With the constant development of city management. At present it is the most impending demand for city insurance management and financial organizations to derive and analyze the mass of historical data effectively and make the right decision.At first, a lot of domestic and overseas datum about Data Warehouse technology is introduced in this paper. Furthermore, an in-depth study of the ETL (extract, transform and loading) and Data Warehouse modeling is made. And then the details of the prototype system designing are discussed by means of an example of the BeiJing City management Decision Support System firstly. By encapsulating DTS (Data Transformation Services) to realize data extract, data transform and data loading (ETL), The data in some former operating database is loaded into data warehouse. Secondly, by analyzing the requirements of DSS and dynamic reports, the data warehouse is realized by using the information packed technology. It is explore of building DW in the domain of City management. Then, by using the tools of Microsoft OLAP services, the dimensions and cubes of production and consume are build and met the requirement of multidimensional OLAP analysis. According to the research on the development and implement of data warehouse-based City Management Decision Support System (S1DSS), this paper indicates that the modeling of data warehouse and the data extraction are of great significance to a further investigation of data warehouse as well as its practical application in various domains.City Management Decision Support System has been carried into execution in Beijing City Management Committee. It runs smoothly and successfully in Beijing Information Center and meets customers'needs. It's proved that the modeling of data warehouse and the data extraction in this paper are of great significance to a further investigation of data warehouse as well as its practical application in various domains.