A Conceptual Metadata Framework for Spatial Data Warehouse

TL;DR

This paper proposes a comprehensive metadata framework tailored for spatial data warehouses, aiming to enhance data access efficiency, reduce query response times, and improve the accuracy of spatial information retrieval.

Contribution

It introduces a novel holistic metadata framework specifically designed for spatial data warehouses, integrating spatial information with data modeling to improve performance.

Findings

Reduces query response time in spatial data warehouses

Improves accuracy of spatial information retrieval

Enhances efficiency of data access in SDWs

Abstract

Metadata represents the information about data to be stored in Data Warehouses.It is a mandatory element of Data Warehouse to build an efficient Data Warehouse.Metadata helps in data integration,lineage,data quality and populating transformed data into data warehouse.Spatial data warehouses are based on spatial data mostly collected from Geographical Information Systems(GIS)and the transactional systems that are specific to an application or enterprise.Metadata design and deployment is the most critical phase in building of data warehouse where it is mandatory to bring the spatial information and data modeling together.In this paper,we present a holistic metadata framework that drives metadata creation for spatial data warehouse. Theoretically, the proposed metadata framework improves the efficiency of accessing of data in response to frequent queries on SDWs.In other words, the proposed framework decreases the response time of the query and accurate information is fetched from Data Warehouse including the spatial information.