Decision Support System Based on Data Warehouse

Authors: Yang Bao, LuJing Zhang

Abstract:

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.

Keywords: Decision Support System, Data Warehouse, Data Mining.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1075210

References:

[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