
1.2 Data Modeling for Data Warehouses 23
Chapter 1
between the PRODUCT and CATEGORY entities. The PRODUCT
dimensional entity in Figure 1.14 has the name of the category rolled into
the PRODUCT entity, minimizing on joins and ultimately providing for
faster performing code in a data warehouse.
Transactional databases usually have some form of demographic infor-
mation attached to transactions, either directly or through relations with
other entities. The equivalent for a data warehouse is sometimes a location
dimension such as that shown in Figure 1.15.
Figure 1.16 shows a transformation between a relational entity location
structure design and that of ...