The Research And Realization Of City Management DSS Based On Data Warehouse

With the proliferation of computers and the tremendous success of database systems, the various database systems developed with unprecedented speed and widely used in various fields, makes business more accurate, efficient and more data is accumulated exponential growth. But faced with a deluge of data, how to found the relationship and rules in the data, and how the existing data to predict the future trend, these are the problems people have been looking forward to solve. Based on this demand, data warehouse technology and on-line analytical processing tools have emerged.The data of different information systems can not be compatible and the resources can not be shared, and over the years a large number of historical data accumulated can not learn effectively, of great impact on the decision making efficiency of Guangzhou city management. City management is a cause of the people's livelihood, how to break "data explosion but lack of information", the shackles of raising the efficiency of decision-making has become urgent. Therefore, take the data warehouse technology as the foundation, on-line analytical processing and data mining tools as means to establish the city management decision support system of Guangzhou becomes the best option.The paper analyzes the development of decision support system status, introduces concepts of data warehouse and OLAP, compares and analyzes the data warehouse and OLAP with the traditional technology. Then takes the city management decision support system of Guangzhou for example, describes the operational management status of the city, main business data and the main demand of decision support system in detail, and shows the architecture of the city management decision support system of Guangzhou and modular design, and notes the process of the design and implementation: Firstly, through the SQL Server Integration Service (SSIS) we can extract, purify, transform, and load the data of different data sources; Secondly, by using the SSIS, the dimensions and cubes of production and consumes are built and meet the requirement of multidimensional OLAP analysis. According to the needs of data analysis and decision analysis, completes the data query and analysis demonstrate in a variety of ways. Finally, describes issues related to Web Services of the system, and designs two ways of visiting the city management decision support system through Web.