Study Of Decision Support System Based On OLAP And Data Warehouse

In recent years, along with the rapid development of management information system and the dramatically expanding of database scale, at the same time , the database technology has been developed rapidly, however people don't satisfy the useful information which attained from the transact database in the field of decision. Therefore, decision support system emerges as the time require. The technology of data warehouse, OLAP and data mining provide advantages to the development and application of DSS(decision support system), and therefore the three technology is the most important in the research of DSS.This paper studies and implements a DSS based on multi-dimensional query analysis, and then, we brought forward a set of multi-dimensional association rules algorithms base on OLAP technique. We proceed from designing the system function, then describe the system architecture and explain the every module. Based on the study of designing pattern of multi-dimensional data model, three designation methods are pointed out. The multi-dimensional data model of the sample database is designed as star schema, and we design the DTS(Data Transformation Server) by SQL SERVER2000 enterprise edition, and implement data extract ,transformation and load. One of Relative database , log files, remote data soure can be used as data source in DTS .Through the deep research of association rules we extended it from intra-dimension and single level to inter-dimension and multi-level. Based on that, we put forward effective algorithms and optimize it for different dataset,besides, we analyzed the complexity of the algorithms and compared the efficiency of the different algorithms for different dataset. The application of improved algorithms in Heilongjiang province enterprise information website has testified that it is feasible.The techniques of establishment and access for multi-dimensional dataset are discussed. We implement multi-dimensional query, including roll-up, drill down and slicing etc, and the update of the multi-dimensional data set by the technique of MDX, ADO MD and DSO. The expression of corresponding operation by graphic is also implemented.The application of this system point out the direction of enterprise's information construction, and provides the decision maker scientific, convenient and timely decision information.