eDWaaS: A Scalable Educational Data Warehouse as a Service

TL;DR

This paper introduces eDWaaS, a scalable, multi-tenant data warehouse service designed for universities to efficiently store and manage historical data, supporting decision-making and ranking activities cost-effectively.

Contribution

The paper proposes a novel multi-tenant, scalable data warehouse as a service model specifically tailored for educational institutions, addressing cost and scalability challenges.

Findings

Supports multiple universities with a single data warehouse infrastructure

Reduces costs compared to in-house or outsourced solutions

Enhances scalability for growing data needs

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.