Application Research of an Intelligent Decision Support System Based on Data Warehousing Technology

The integration of a Data Warehouse(DW) and a Decision Support System(DSS) can provide teaching managers with sufficient information for decision making without interrupting daily work of an On-Line Transaction Processing(OLTP) system. In this paper, project background and the research necessity are first introduced. Then the concepts of the DW, On-Line Analysis Processing(OLAP), Data Mining(DM), On-line analytical mining (OLAM) and DSS are reviewed. The method of creating a DW is then shown, changing the data in the DW into a multidimensional data cube and integrating the DW with a DSS. An application example is given to illustrate the use of the teaching Management Decision Support System developed by SQL SERVER solution. In the last part of the paper, a summary of an intelligent DSS Based on DW Technology and is represented, and the foregrounds prospects of further improvement of the system are conceived.