Decision Support System Based on Data Warehouse

Typical Intelligent Decision Support System is 4-based, its design composes of Data Warehouse, Online Analytical Processing, Data Mining and Decision Supporting based on models, which is called Decision Support System Based on Data Warehouse (DSSBDW). This way takes ETL,OLAP and DM as its implementing means, and integrates traditional model-driving DSS and data-driving DSS into a whole. For this kind of problem, this paper analyzes the DSSBDW architecture and DW model, and discusses the following key issues: ETL designing and Realization; metadata managing technology using XML; SQL implementing, optimizing performance, data mapping in OLAP; lastly, it illustrates the designing principle and method of DW in DSSBDW.

• Yang Bao
• LuJing Zhang

• Decision Support System
• Data Warehouse
• Data Mining.

[1] Fan Jin-Sheng,Zhang Xiao-Ning. Imports and exports decision support
system based on data warehouse (J). COMPUTER ENGINEERING AND
DESIGN ,2008,(12).
[2] Zhang Zhi-Jun. Enterprise Management Decision Support System Based
on Data Warehouse(J) Computer Appication and
Software,2005,(6):41-43.
[3] SHAMS,KAMRUDDIN,FARISHTA,et al.Data Warehousing:Toward
Knowledge Management(J).Topics in Health Information
Management,2001,21(3):24-32.
[4] FORGIONNE,GANGOPADHYAY,ADYA.Cancer Surveillance Using
Data Warehousing,Data Mining,and Decision Support Systems(J).Topics
in Health Information Management,2000,21(1):21-34