SDG Aligned Data Warehouse Implementation over Open Government Data

Several Open Government Data (OGD) initiatives have resulted in the availability of open datasets that can be very useful for policy formulation and participatory decision-making. However, integrating these disparate datasets and seamlessly connecting them to all relevant data sources remains a critical challenge. Typically, OGD reflects the performance metrics of geographical units such as states, districts, or villages. This information is primarily utilized by policymakers and data analysts for decision-making within specific frameworks like the UN Sustainable Development Goals (SDGs). The current frameworks designed for data retrieval, whether based on keywords or domains, lack the capability to semantically map the inherent connections between data points and SDG constructs. In this research, we introduce a Data Warehouse framework over an open dataset provided by the government of the state of Karnataka in India. This framework aims to bridge the gap by enabling a more nuanced understanding of the relationship between data points collected by the OGD processes and SDGs. In this research, the proposed data warehouse is constructed based on a top-down approach. A fact constellation schema model is proposed to effectively capture information across multiple dimensions, including geographical data, temporal aspects, and various administrative units. The proposed framework is implemented over the OGD dataset called Karnataka at a Glance (KAG), and is equipped to handle OLAP (Online Analytical Processing) queries. The findings validate the integrity of the proposed architecture and demonstrate its capacity to facilitate the seamless integration of data ingestion processes.