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

Cavique, Luís; Cavique, Mariana; Santos, Jorge M. A.

http://hdl.handle.net/10400.2/10186

Use this identifier to reference this record.

Name:	Description:	Size:	Format:
WorldCIST 2020_Supply-demand matrix.pdf		1.33 MB	Adobe PDF	Download

Send Feedback

Authors

Cavique, Luís

Cavique, Mariana

Santos, Jorge M. A.

Abstract(s)

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.