Skip to main content

eDWaaS: A Scalable Educational Data Warehouse as a Service

  • Conference paper
  • First Online:
Book cover Intelligent Systems Design and Applications (ISDA 2017)

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 736))

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 259.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 329.99
Price excludes VAT (USA)
  • Compact, lightweight 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

References

  1. Agrawal Sr, M., Joshi Sr, A.S., Velez, A.F.: Best Practices in Data Management for Analytics Projects (2017)

    Google Scholar 

  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. 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. 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. Di Tria, F., Lefons, E., Tangorra, F.: Academic data warehouse design using a hybrid methodology. Comput. Sci. Inf. Syst. 12(1), 135–160 (2015). https://doi.org/10.2298/CSIS140325087D

    Article  Google Scholar 

  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. 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. 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. Pucciarelli, F., Kaplan, A.: Competition and strategy in higher education: managing complexity and uncertainty. Bus. Horizons 59(3), 311–320 (2016)

    Article  Google Scholar 

  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 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Anupam Khan .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG, part of Springer Nature

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Khan, A., Ghosh, S., Ghosh, S.K. (2018). eDWaaS: A Scalable Educational Data Warehouse as a Service. In: Abraham, A., Muhuri, P., Muda, A., Gandhi, N. (eds) Intelligent Systems Design and Applications. ISDA 2017. Advances in Intelligent Systems and Computing, vol 736. Springer, Cham. https://doi.org/10.1007/978-3-319-76348-4_96

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-76348-4_96

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-76347-7

  • Online ISBN: 978-3-319-76348-4

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics