Data Warehouse Design in Academic Environment

Munawar Munawar

Sari


The popularity of Data Warehouses (DW)sfor data analysis has grown tremendously, asconventional transaction processing systems have matured, becoming faster and more stable. Conventionalsystems in universitiesworking in the same area, storedaily activities and display or report these events on a regular basis. Therefore, the establishment of the DWs will help the top management in the development of strategies and take appropriate decisions inthese universities.This paper addresses issues related to designing a DW for private university in Jakarta. The purpose of the project isto provide a process model that will enhance decision making capabilities ina private university in order to facilitate and improve academic activities.

 

Keywords: requirements analysis, conceptual design, data warehouse, academic


Teks Lengkap:

PDF

Referensi


Artz, J, “Data driven vs. metric driven data warehouse designâ€, In Encyclopedia of Data Warehousing and Mining, pp. 223 – 227, Idea Group, 2005

Boehnlein M., Vom Ende U, “A Business Process Oriented Development of Data Warehouse Structuresâ€, In Proceedings of Data Warehousing 2000, Physica Verlag, 2000

C. dell’Aquila, F. Di Tria, E. Lefons, and F. Tangorra, “Business Intelligence Application for University Decision Makersâ€, WSEAS Transactions on Computers. ISSN 1109-2750, Issue 7, Volume 7, July, 2008

D. J. Berndt and R. K, “Satterfield, "Customer and household matching: Resolving entity identity indata warehousesâ€, The International Society for Optical Engineering, vol. 4057, pp. 173-180, 2000

D. L. Heise, " Data warehousing and decision making in higher education in the United States", Andrews University, 2006

Frolick, M., & Ariyachandra, T, “Critical Success Factors in Business Performance Management-Striving for Successâ€, Information Systems Management, 25, 113-120, 2006

Giorgini, P., Rizzi, S., Garzetti, M.: GRAnD, “A goal-oriented approach to requirement analysis in data warehousesâ€, Decision Support Systems 45(1), 4–21, 2008

H. J. Watson, C. Fuller, and T. Ariyachandra, "Data warehouse governance: best practices at BlueCross and Blue Shield of North Carolina", Decision Support Systems, vol. 38, pp. 435-450, 2004

H. Palmer, "A Data Warehouse Methodology and Model for Student Data in Higher Education", NovaSoutheastern University, Graduate School of Computer and Information Sciences, 2006

J. Guan, W. Nunez, and J. F. Welsh, "Institutional strategy and information support: the role of datawarehousing in higher education", Campus-Wide Information Systems, vol. 19, pp. 168-174, 2002

Kaldeich, C., & Oliveira, J, “Data warehouse methodology: A process driven approachâ€, In Proceedings of CAISE, LNCS, 3084, 536-549, 2004

Kimball, R., Reeves, L., Ross,M., and Thornthwaite, W, “The Data Warehouse Lifecycle Toolkitâ€, second edition, John Wiley & Sons, 1998

List B., Bruckner R., Machaczek K., and Schiefer, J, “A comparison of data warehouse development methodologies: Case study of the process warehouseâ€, In Proc. DEXA, 2002

M. Baranovic, M. Madunic, and I. Mekterovic, "Data warehouse as a part of the higher educationinformation system in Croatia", presented at 25th International Conference on Information TechnologyInterfaces, Cavtat, Croatia, 2003

M. C. Lin, "University Data Warehouse Design Issues: A Case Study", presented at ASEE AnnualConference & Exposition, 2001

M. Ester, H. P. Kriegel, J. Sander, M. Wimmer, and X. Xu, "Incremental Clustering for Mining in aData Warehousing Environment", Proceedings of the 24rd International Conference on Very LargeData Bases, pp. 323-333, 1998

Matteo Golfarelli, Dario Maio, Stefano Rizzi, “Conceptual Design of data warehouses from E/R schemesâ€, Proceedings of the Hawaii International Conference on System Sciences, 1998

Munawar, Naomie Salim, and Roliana Ibrahim, “Toward Data Quality Integration into the Data Warehouse Developmentâ€, Ninth IEEE International Conference on Dependable, Autonomic and Secure Computing.978-0-7695-4612-4/11 © 2011 IEEE Computer Sociaty. DOI 10.1109/DASC.2011.194, 2011

Munawar, Naomie Salim, and Roliana Ibrahim, “Toward Data Warehouse Quality through Integrated Requirements Analysisâ€, ICACSIS 2011. ISBN: 978-979-1421-11-9, 2011

P. Vassiliadis, "Gulliver in the land of data warehousing: practical experiences and observations of aresearcher," Proc. 2 ndIntl. Workshop on Design and Management of Data Warehouses (DMDW), pp.12.1–12.16, 2002

R. G. Allan and D. R. May, "Data models for a registrar's data mart", presented at The College and University Services Conference (CUMREC), 2000

R. G. Allan, "Data models for a registrar's data mart", Journal of Data Warehousing, vol. 6, pp. 38-53, 2001

R. G. Little and M. L. Gibson, "Perceived influences on implementing data warehousing," IEEETransactions on Software Engineering, vol. 29, pp. 290-296, 2003

R. G. Stephen, "Building the data warehouse," Commun. ACM, vol. 41, pp. 52-60, 1998

S. M. Grotevant and D. Foth, "The Power of Multidimensional Analysis (OLAP) in Higher EducationEnterprise Reporting Strategie", presented at The College and University Information ServicesConference (CUMREC), 1999

V. Poe, S. Brobst, and P. Klauer, “Building a Data Warehouse for Decision Support: Prentice-Hallâ€, Inc.Upper Saddle River, NJ, USA, 1997

W. H. Inmon,†Building the data warehouseâ€, 4th ed, John Wiley & Sons, Inc, New York, USA,2005

Westerman, P, “Data Warehousing using the Wal-Mart modelâ€, p. 297, Morgan Kaufmann

Wierschem, D., McMillen, J. and McBroom, R, “What Academia Can Gain from Building a Data Warehouseâ€, Vol. 26, No. 1, EDUCAUSE Quarterly, 2003




DOI: https://doi.org/10.47007/komp.v10i2.901

Refbacks

  • Saat ini tidak ada refbacks.


VISITOR COUNTER:

gerEGGe

 

Web Analytics Made Easy - Statcounter View My Stats