Skip to main content

Star Schema-Based Data Warehouse Model for Education System Using Mondrian and Pentaho

  • Conference paper
  • First Online:
Modelling, Simulation and Intelligent Computing (MoSICom 2020)


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

Subscribe and save

Springer+ Basic
EUR 32.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or Ebook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
USD 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 219.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others


  1. Ponniah P (2009) Data warehousing fundaments for IT professionals. India

    Google Scholar 

  2. 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.

  3. 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).

  4. 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).

  5. 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).

  6. 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)

    Google Scholar 

  7. 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).

  8. Pentaho-Data Integration Homepage. Last accessed 15 Nov 2019

Download references

Author information

Authors and Affiliations


Corresponding author

Correspondence to Sweta Suman .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2020 Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

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.

Download citation

  • DOI:

  • 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)

Publish with us

Policies and ethics