The Application of Data Warehouse in Decision Support System

Abstract:

Decision support systems provide the field of query optimization with increasing challenges in the traditional questions of selectivity estimation that can exploit transformations without exploding search space. The aims of this paper are to understand what the data warehouse and protect the sensitive information stored elsewhere in data warehouse. In the system, management level of system can review all records of historical data for monthly or yearly as user desired item for each dimension. This system is developed to easy access for frequently needed data, to improve end-user respond time. The paper results in accumulation of growing amounts of data in operational databases. The system can help to retrieve complex query analysis report. In this paper, we analyze personnel information by using Data Warehouse and OLAP tools.

• Periodical: Advanced Materials Research (Volumes 268-270)
• Pages: 534-539
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.268-270.534
• Online since: July 2011
• Authors: Xiao Hua Yang
• Keywords: Data Warehouse (DW), Decision Support System (DSS), OLAP

References

[1] A. Berson and S.J. Smith, Data Warehousing, Data Mining and OLAP, MC Graw-Hill Series on Data Warehousing and Data Management.

DOI: 10.4018/978-1-59904-951-9.ch013

[2] E. F . Codd, Providing OLAP (online analytical processing) to user-analysis, An IT mandate. E.F. Codd and Associates, (2009).

[3] W.H. Inmon, Building the data bridge: the ten critical success factors of building a data warehouse. Database Programming and Design, (1992).

[4] H. Jiawei and K. Micheline, Data Mining Concepts and Techniques, Margan Kaufmann, (2001).

[5] R. Kimball, DBMS Online Article, http: /ww. dbsmag. com.

[6] M. Lupetin, InfoMaker Inc., Glenview, Illions, A Data Warehouse Implementation Using the Star Schema, http: /www. microsoft. com.

[7] A. Marotta, A transformation based approach for designing Data Warehouse Internal Report. InCo. Universidad dela Republica, Montevideo, Uruguay, (2009).

[8] C. Squire, Data extraction and transformation for the data warehouse. In SIGMOD, May (1995).

[9] C. Surajit and D. Umeshwar, An Overview of Data Warehousing and OLAP Technology, pp.2-3, Microsoft Research, Redmond, (2008).

[10] J. Widom, Research Problems in Data Warehousing, in Proc. 4th Int. Conf. on information and Knowledge Management, (2009).