engleski

On the Differences of Relational and Dimensional Data Model

Relational modelling is used for the modelling of transactional data stored in relational databases while dimensional modelling is prevalently used for the modelling of dimensional data stored in data warehouses. The modelling approach used is quite different. In relational modelling the focus is on identification of fundamental or strong entities involved in the execution of business transactions, while in dimensional modelling the focus is on identification of associative entities that carry business measures. In the paper some equivalence problems of two models are discussed. Also, the main steps of transformation of relational into dimensional model are described.

relational data model; dimensional data model; relational modelling; dimensional modelling

nije evidentirano