A Conceptual Model for Data Warehousing

Deepika Prakash, Naveen Prakash

2024

Abstract

We show that current approaches for data warehouse conceptual modelling are inadequate for capturing the range of analysis capabilities of the enterprise. In addressing this, our conceptual model retains the basic distinction between the analysis data and analysis parameters but additionally introduces intra analysis-data and intra analysis-parameters relationships besides relationships between analysis data and analysis parameter. A variety of constraints for enforcing analysis semantics are also defined. We convert the conceptual model to star schema and show procedures to do so. We illustrate the use of our model through an example.

Paper Citation

in Harvard Style

Prakash D. and Prakash N. (2024). A Conceptual Model for Data Warehousing. In Proceedings of the 19th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE; ISBN 978-989-758-696-5, SciTePress, pages 87-98. DOI: 10.5220/0012621200003687

in Bibtex Style

@conference{enase24,
author={Deepika Prakash and Naveen Prakash},
title={A Conceptual Model for Data Warehousing},
booktitle={Proceedings of the 19th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE},
year={2024},
pages={87-98},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0012621200003687},
isbn={978-989-758-696-5},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 19th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE
TI - A Conceptual Model for Data Warehousing
SN - 978-989-758-696-5
AU - Prakash D.
AU - Prakash N.
PY - 2024
SP - 87
EP - 98
DO - 10.5220/0012621200003687
PB - SciTePress