Supply-demand matrix: a process-oriented approach for data warehouses with constellation schemas

Star schema in data warehouses is a very well-established model. However, the increasing number of star schemas creating large constellations schemas add new challenges in the organizations. In this document, we intend to make a contribution in the technical architecture of data warehouses with cons...

Full description

Bibliographic Details
Main Author: Cavique, Luís (author)
Other Authors: Cavique, Mariana (author), Santos, Jorge M. A. (author)
Format: conferenceObject
Language:eng
Published: 2020
Subjects:
Online Access:http://hdl.handle.net/10400.2/10186
Country:Portugal
Oai:oai:repositorioaberto.uab.pt:10400.2/10186
Description
Summary:Star schema in data warehouses is a very well-established model. However, the increasing number of star schemas creating large constellations schemas add new challenges in the organizations. In this document, we intend to make a contribution in the technical architecture of data warehouses with constellation schemas using an extension of the bus matrix. The proposed supply-demand matrix details the raw data from the original databases, describes the constellation schemas with different dimensions and establishes the information demand requirements.