Abstract
Multiple strategic challenges are being faced by educational institutions across the globe which is of interest to both researchers and decision-makers. These challenges can be successfully addressed by analyzing the vast amount of data stored in multiple, unorganized, and unstructured operational databases in the educational institutes. Practitioners, researchers, and students would need data warehousing techniques to be able to utilize the knowledge stored in different archives. Data warehousing techniques include assimilating disparate sources of data, analysis of the requirements, designing the data, development, implementation, and deployment of the data. In this paper, a data warehouse (DW) for solving operational challenges of the center of higher education has been developed, which encompasses system design, ETL data processing, and online analytical processing analysis. The designing of this model is done using Mondrian and Pentaho business intelligence tool.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Ponniah P (2009) Data warehousing fundaments for IT professionals. India
Singh RP, Singh K (2016) Design and research of data analysis system for student education improvement (case study: Student Progression System in University). In: 2016 International conference on micro-electronics and telecommunication engineering (ICMETE). IEEE Press, Ghaziabad, pp 508–512. https://doi.org/10.1109/icmete.2016.80
Dong P, Dong J, Huang T (2006) Application of data warehouse technique in educational decision support system. In: 2006 IEEE international conference on service operations and logistics, and informatics. IEEE, Shanghai, pp 818–822 (2006). https://doi.org/10.1109/soli.2006.328961
Sharma S, Jain R (2014) Modeling ETL Process for data warehouse: an exploratory study. In: 2014 fourth international conference on advanced computing and communication technologies. IEEE Press, Rohtak, pp 271–276 (2014). https://doi.org/10.1109/acct.2014.100
Moscoso-Zea O, Sampedro A, Luján-Mora S (2016) Datawarehouse design for educational data mining. In: 2016 15th international conference on information technology based higher education and training (ITHET), IEEE, Istanbul, pp 1–6 (2016). https://doi.org/10.1109/ithet.2016.7760754
Tripathy A, Das K (2011) A descriptive approach towards data warehouse and OLAP technology: an overview. In: Das VV, Stephen J, Chaba Y (eds) Computer networks and information technologies. CNC 2011. Communications in computer and information science, vol 142. Springer, Berlin, Heidelberg (2011)
Hanlin Q, Xianzhen J, Xianrong Z (2012) Research on extract, transform and load (ETL) in land and resources star schema data warehouse. In: 2012 Fifth international symposium on computational intelligence and design, Hangzhou. IEEE, Hangzhou, China, pp 120–123 (2012). https://doi.org/10.1109/iscid.2012.38
Pentaho-Data Integration Homepage. www.pentaho.com. Last accessed 15 Nov 2019
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Suman, S., Khajuria, P., Urolagin, S. (2020). Star Schema-Based Data Warehouse Model for Education System Using Mondrian and Pentaho. In: Goel, N., Hasan, S., Kalaichelvi, V. (eds) Modelling, Simulation and Intelligent Computing. MoSICom 2020. Lecture Notes in Electrical Engineering, vol 659. Springer, Singapore. https://doi.org/10.1007/978-981-15-4775-1_4
Download citation
DOI: https://doi.org/10.1007/978-981-15-4775-1_4
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-15-4774-4
Online ISBN: 978-981-15-4775-1
eBook Packages: Computer ScienceComputer Science (R0)