Desain Model Data Warehouse dengan Contoh Kasus Perguruan Tinggi

Spits Warnars

Abstract


The growth high education has been raising the competition in high education market and Data Warehouse can be used as an effective technology weapon for going to battle in high education competition market. Data Warehouse can produce the reliable reports for high level management on high education in short time in order to make the faster and best decision making for not just only increasing number of students, but possibility to find mining fund which have never thinking before limited by high education ordinance. The reports which produce by Data Warehouse are made based on database which summarization transaction database can be trusted and far from manipulation, different with old producing reports based on transaction database which need to be questioned and need time to produce, need manipulation for the result, cannot be trusted and could be have different results if differentiate to other systems. Data Warehouse will be modeled with dimension business concept and be created based on hypercube which produced based on high demand reports which usually used by high level management. In every fact and dimension table will be inserted with fields which represent the construction merge loading as an ETL (Extraction, Transformation and Loading) extraction.

Keywords: Data Warehouse, High Education, Hypercube, Business Dimensional Concept


Full Text:

PDF

References


Porter M.E., “Strategy and the Internet”, Harvard Business Review, pp. 62-78,2001.

Ward J. & Peppard J.,”Strategic planning for Information Systems”,Edisi 3,John Willey & Sons, Ltd, West Sussex, England,2003

Dimokas N., Mittas N., Nanopoulos A., Angelis L.,”A Prototype System for Educational Data Warehousing and Mining”, Proceedings of the 2008 Panhellenic Conference on Informatics, pp.199-203,2008

Hans D., Gomez J.M., Peters D., Solsbach A.,”Case Study-Design for Higher Education- A Demonstration in the Data Warehouse Environment”, W. Abramowicz & D. Flejter (Eds), Business Information Systems Workshops, BIS 2009 International Workshops, LNBIP, Vol. 37, pp. 231-241, Poznan, Poland, 2009

Wu T,”System of Teaching quality analyzing and evaluating based on Data Warehouse”, Computer Engineering and Design, Vol 30, No. 6, pp.1545-1547, 2009

Zhou L., Wu M., Li S., “Design of Data Warehouse in teaching state based on OLAP and Data Mining”, Proc. Of SPIE (The International Society for Optical Engineering), Vol. 7344, 2009

Gombiro C., Munyoka W., Hove S., Chengetanai G., Zano C.,”The Need for Data Warehousing in Sharing Learning Materials”,Journal of Sustainable Development in Africa, Vol. 10, No.2, pp. 422-449,2008

Wikramanayake G.N.& Goonetillake J.S., “Managing Very Large Databases and Data Warehousing”, Sri Lankan Journal of Librarianship and Information Management, Vol. 2, No.1, pp. 22-29, 2006

Ranjan J., Khalil S.,”Conceptual Framework of Data Mining Process in Management Education in India: An Institutional Perspective”, Information Technology Journal, Vol.7, No, 1, pp.16-23, 2008

Goldstein P.J.,”Academic Analytics: The Uses of Management Information and Technology in Higher Education”, ECAR Key Findings, EDUCAUSE Center for Applied Research, Washington DC, USA, 2005.

Silva F.S.C., Panigassi R., Hulot C.,”Learning Management Systems Desiderata for Competitive Universities”, European Journal of Open, Distance and E-Learning, Vol. 2, 2007

Ponniah P.,”Data Warehousing Fundamentals”, John Willey & Sons, Inc, New York, USA,2001

Chaudhuri S., Dayal U., ”An overview of data warehousing and olap technology”, ACM SIGMOD Record, Vol. 26, No. 1, pp.65-74, 1997




DOI: http://dx.doi.org/10.30813/jiems.v3i1.70

Refbacks

  • There are currently no refbacks.