Databases Reference
In-Depth Information
Figure 14.8
Example data warehouse constellation.
Even though the constellation forms a united schema for the data warehouse, the
people analyzing each business process may be interested only in their piece of the puz-
zle. A scheduler will naturally focus on the scheduling star schema. Each star schema
can be thought of as a data mart for the corresponding business process. It is possible to
deploy data marts on physically different machines. Perhaps the scheduling department
has their own dedicated computer system that it prefers. When deploying data to physi-
cally distinct data marts, it is still very important for the data to be conformed, so that
everyone is communicating meaningfully.
