Semantic Metadata Requirements for Data Warehousing from a Dimensional Modeling Perspective

Susanna Campher

2022

Abstract

The era of big data has brought on new challenges to data warehousing. Emerging architectural paradigms such as data fabric, data mesh, lakehouse and logical data warehouse are promoted as solutions to big data analytics challenges. However, such hybrid environments, aimed at offering universal data platforms for analytics, have schemas that tend to grow in size and complexity and become more dynamic and decentralized, having a drastic impact on data management. Data integrity, consistency and clear meaning are compromised in large architectures where traditional (relational) database principles do not apply. This paper proposes an investigation into semantic metadata solutions in modern data warehousing from a (logical) dimensional modeling perspective. The primary goal is to determine which metadata and types of semantics are required to support automated dimensionalization as it is assumed to be a good approach to integrate data with different modalities. A secondary goal is finding a suitable model to represent such metadata and semantics for both human and computer interpretability and use. The proposal includes a description of the research problem, an outline of the objectives, the state of the art, the methdology and assumptions, the exepected outcome and current stage of the research.

Download


Paper Citation


in Harvard Style

Campher S. (2022). Semantic Metadata Requirements for Data Warehousing from a Dimensional Modeling Perspective. In Proceedings of the 24th International Conference on Enterprise Information Systems - Volume 2: ICEIS, ISBN 978-989-758-569-2, pages 129-136. DOI: 10.5220/0011018200003179


in Bibtex Style

@conference{iceis22,
author={Susanna Campher},
title={Semantic Metadata Requirements for Data Warehousing from a Dimensional Modeling Perspective},
booktitle={Proceedings of the 24th International Conference on Enterprise Information Systems - Volume 2: ICEIS,},
year={2022},
pages={129-136},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0011018200003179},
isbn={978-989-758-569-2},
}


in EndNote Style

TY - CONF

JO - Proceedings of the 24th International Conference on Enterprise Information Systems - Volume 2: ICEIS,
TI - Semantic Metadata Requirements for Data Warehousing from a Dimensional Modeling Perspective
SN - 978-989-758-569-2
AU - Campher S.
PY - 2022
SP - 129
EP - 136
DO - 10.5220/0011018200003179