Decision Support Research And Implementation Of Data Warehouse System

Data Warehouse (DW) is a new technology of data processing and data managing that develops very fast in recent years. Its appearance has greatly accelerated the development of Decision Support Systems' (DSS) theory research and application. By using DW technology in the construction of DSS, the existing data resource can be made full use of and the management level can be improved efficiently. The theory, method and application discussion based on DW technology has become a research hotspot of DSS currently. This paper is based on the background of the WEB Decision Support System for Banking. The DW modeling and its application in DSS are studied.At first, the birth and developing status of DSS and the newest development of the database technology are described. The reason why DW technology comes into being—the need of the DSS's development, is analyzed. The building of DW is not meant to replace the database, but to build an analysis environment based on an entire and perfect information application to support high-level decision. Then the technical theory of DW is expounded, the methods of DW system's design and its software developing are discussed. Meanwhile, a new framework of DSS is presented.The stress of this paper is the modeling research of the DW system and optimizing query of its. The DW modeling method and realization technology which middle-dimensional on apart-region on DW with Multidimensional Star Schema (MSS) are brought forward after detailed discussion of Object-Oriented Analysis and Subject-Oriented Analysis. In the application of the aforementioned theory, The design of Database 's system model on DSS is elaborated, including data modeling, the choice and realization of relational database. On the basis of that, some problems in the management of DW such as Metadata management, data extracting, data integrating and how to improve the performance of the DW are discussed in detail. Meanwhile, the data analysis of DW like OLAP and the data display of DW are taken theory research. Therefore, an analysing and displaying framework based on put dynamic region and static region in DW is put forward.