Desain Model Data Warehouse dengan Contoh Kasus Perguruan Tinggi
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:
PDFReferences
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.