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...

ver descrição completa

Detalhes bibliográficos
Autor principal: Cavique, Luís (author)
Outros Autores: Cavique, Mariana (author), Santos, Jorge M. A. (author)
Formato: conferenceObject
Idioma:eng
Publicado em: 2020
Assuntos:
Texto completo:http://hdl.handle.net/10400.2/10186
País:Portugal
Oai:oai:repositorioaberto.uab.pt:10400.2/10186
Descrição
Resumo: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.