eDWaaS: A Scalable Educational Data Warehouse as a Service

  • Anupam Khan
  • Sourav Ghosh
  • Soumya K. Ghosh
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 736)


The university management is perpetually in the process of innovating policies to improve the quality of service. Intellectual growth of the students, the popularity of university are some of the major areas that management strives to improve upon. Relevant historical data is needed in support of taking any decision. Furthermore, providing data to various university ranking frameworks is a frequent activity in recent years. The format of such requirement changes frequently which requires efficient manual effort. Maintaining a data warehouse can be a solution to this problem. However, both in-house and outsourced implementation of a dedicated data warehouse may not be a cost-effective and smart solution. This work proposes an educational data warehouse as a service (eDWaaS) model to store historical data for multiple universities. The proposed multi-tenant schema facilitates the universities to maintain their data warehouse in a cost-effective solution. It also addresses the scalability issues in implementing such data warehouse as a service model.


Educational data management Data warehouse Service-oriented architecture Scalability 


  1. 1.
    Agrawal Sr, M., Joshi Sr, A.S., Velez, A.F.: Best Practices in Data Management for Analytics Projects (2017)Google Scholar
  2. 2.
    Aziz, A.A., Jusoh, J.A., Hassan, H., Idris, W., Rizhan, W.M., Zulkifli, M., Putra, A., Yusof, M., Anuwar, S.: A framework for educational data warehouse (EDW) architecture using business intelligence (BI) technologies. J. Theor. Appl. Inf. Technol. 69(1), 50–58 (2014)Google Scholar
  3. 3.
    Cuzzocrea, A., Moussa, R.: A cloud-based framework for supporting effective and efficient OLAP in big data environments. In: Proceedings - 14th IEEE/ACM International Symposium on Cluster, Cloud, and Grid Computing, CCGrid 2014, pp. 680–684 (2014)Google Scholar
  4. 4.
    Dell’Aquila, C., Di Tria, F., Lefons, E., Tangorra, F.: An academic data warehouse. In: Proceedings of the 7th Conference on 7th WSEAS International Conference on Applied Informatics and Communications, pp. 229–235 (2007)Google Scholar
  5. 5.
    Di Tria, F., Lefons, E., Tangorra, F.: Academic data warehouse design using a hybrid methodology. Comput. Sci. Inf. Syst. 12(1), 135–160 (2015). CrossRefGoogle Scholar
  6. 6.
    Kaur, H., Agrawal, P., Dhiman, A.: Visualizing clouds on different stages of DWH-an introduction to data warehouse as a service. In: 2012 International Conference on Computing Sciences (ICCS), pp. 356–359. IEEE (2012)Google Scholar
  7. 7.
    Khan, A., Ghosh, S.K.: Analysing the impact of poor teaching on student performance. In: 2016 IEEE International Conference on Teaching, Assessment and Learning for Engineering (TALE), IEEE (2016)Google Scholar
  8. 8.
    Kurniawan, Y., Halim, E.: Use data warehouse and data mining to predict student academic performance in schools: A case study (perspective application and benefits). In: Proceedings of 2013 IEEE International Conference on Teaching, Assessment and Learning for Engineering, TALE 2013, pp. 98–103 (2013)Google Scholar
  9. 9.
    Pucciarelli, F., Kaplan, A.: Competition and strategy in higher education: managing complexity and uncertainty. Bus. Horizons 59(3), 311–320 (2016)CrossRefGoogle Scholar
  10. 10.
    Saada, A.I., El Khayat, G.A., Guirguis, S.K.: Cloud computing based ETL technique using warehouse intermediate agents. In: Proceedings - ICCES 2011: 2011 International Conference on Computer Engineering and Systems, pp. 301–306 (2011)Google Scholar

Copyright information

© Springer International Publishing AG, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Computer Science and EngineeringIndian Institute of Technology KharagpurKharagpurIndia

Personalised recommendations