data warehouse architecture on the base of dimensional modelling
The present talk deals with the data warehouse architecture. Dimensional modelling, "star" and "snowflake" schemes are defined. The advantages of the dimensional model are described. A comparison between dimensional and entity relation modelling is given. An application of dimensional modelling in the BTC PLC data warehouse architecture is presented.
data warehouse architecture dimensional modelling entity relation modelling snowflake scheme star scheme