Loading...
2 results
Search Results
Now showing 1 - 2 of 2
- Supply-demand matrix: a process-oriented approach for data warehouses with constellation schemasPublication . Cavique, Luís; Cavique, Mariana; Santos, Jorge M. A.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.
- Extraction of fact tables from a relational database: an effort to establish rules in denormalizationPublication . Cavique, Luís; Cavique, Mariana; Gonçalves, AntónioRelational databases are supported by very well established models. However, some neglected problems can occur with the join operator: semantic mistakes caused by the multiple access path problem and faults when connection traps arise. In this paper we intend to identify and overcome those problems and to establish rules for relational data denormalization. Two denormalization forms are proposed and a case study is presented.