Design and Implementation of Efficient Decision Support System Using Data Mart Architecture

Abstract

This paper presents and discuss advantage about the design and implementation of Decision Support System by building data mart, which is a place for the storage and participation of data, which users can readily utilize to product improved decisions. Due to the problems within the systems of Information and Telecommunication Public Company obtaining the data in a successful method requires a harmonious potential Thus, This paper presents proposed framework of Decision Support System for Information and Telecommunication Public Company by which discusses the advantage about design, integration of the building data mart and what is the difference between it and relational database for-decision makers to obtain information that contains four layers (Interface layer determines data source, Extract Transformation Load Layer determines design process in SQL Server Integration service, Data mart layer determines data mart that conform Star Schema, Presentation layer determines the results from the system).