A Survey: Data Warehouse Architecture

Data Warehouse and Data mining are technologies that deliver optimallyvaluable information to ease effective decision making. This survey paper defines architecture of traditional data warehouse and ways in which data warehouse techniques are used to support academic decision making. This paper defines different data warehouse types and techniques used in educational environment to extract, transform and load data, and the ways to improve these techniques to have maximum benefit of data warehouse in educational environment. Further this paper have define different data warehouse framework for different situations.

[1]  Cheryl A. Casper,et al.  Developing Performance-Oriented Models for University Resource Allocation , 2001 .

[2]  D. Z. Deniz,et al.  USING AN ACADEMIC DSS FOR STUDENT, COURSE AND PROGRAM ASSESSMENT , 2001 .

[3]  Bogdan Crivat,et al.  Data Mining with Microsoft SQL Server 2008 , 2008 .

[4]  G. G. Stokes.  "J." , 1890, The New Yale Book of Quotations.

[5]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[6]  M. Baranovic,et al.  Data warehouse as a part of the higher education information system in Croatia , 2003, Proceedings of the 25th International Conference on Information Technology Interfaces, 2003. ITI 2003..

[7]  Roger Fang,et al.  Teaching data warehousing and data mining in a graduate program of information technology , 2006 .

[8]  Robert Wrembel,et al.  Hierarchical Materialisation of Method Results in Object-Oriented Views , 2000, ADBIS-DASFAA.

[9]  Marc H. Scholl,et al.  Decision Support System for Managing Educational Capacity Utilization , 2007, IEEE Transactions on Education.

[10]  Johann Eder,et al.  Creation and management of versions in multiversion data warehouse , 2004, SAC '04.

[11]  John B. Shoven,et al.  I , Edinburgh Medical and Surgical Journal.

[12]  Peter Lehmann,et al.  Data Mining with Microsoft SQL Server 2005 , 2007 .

[13]  Robert Wrembel,et al.  Metadata Management in a Multiversion Data Warehouse , 2005, OTM Conferences.

[14]  James A. Senn.  Information Technology in Business: Principles, Practices, and Opportunities , 1994 .

[15]  อนิรุธ สืบสิงห์,et al.  Data Mining Practical Machine Learning Tools and Techniques , 2014 .

[16]  Ping Dong,et al.  Application of Data Warehouse Technique in Educational Decision Support System , 2006, 2006 IEEE International Conference on Service Operations and Logistics, and Informatics.

[17]  Marc H. Scholl,et al.  UNICAP: Efficient Decision Support for Academic Resource and Capacity Management , 2005, TCGOV.

[18]  Francesco Di Tria,et al.  An academic data warehouse , 2007 .

[19]  Jeffrey W. Seifert,et al.  Data Mining: An Overview , 2004 .

[20]  Yue Zhuge,et al.  Distributed and Parallel Computing Issues in Data Warehousing (Invited Talk) , 1998 .

[21]  Robert Wrembel,et al.  On Methods' Materialization in Object-Relational Data Warehouse , 2002, ADVIS.

[22]  M. Gribaudo,et al.  2002 , 2001, Cell and Tissue Research.

[23]  Osmar R. Zaïane,et al.  Web Usage Mining for a Better Web-Based Learning Environment , 2001 .

[24]  N. K. Kwak,et al.  A multicriteria decision-making approach to university resource allocations and information infrastructure planning , 1998, Eur. J. Oper. Res..

[25]  Matthias Jarke,et al.  Data warehouse process management , 2001, Inf. Syst..

[26]  Elliott Levine.  Building a Data Warehouse. , 2002 .

[27]  Matthias Goeken,et al.  Method for User Oriented Modelling of Data Warehouse Systems , 2006, ICEIS.