Commenced in January 2007
Frequency: Monthly
Edition: International
Paper Count: 30172
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

Procedia APA BibTeX Chicago EndNote Harvard JSON MLA RIS XML ISO 690 PDF Downloads 3399

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