Rational ProjectConsole Designer Help
Data storage in the Rational ProjectConsole repository is based on a star schema table design. A star schema represents the relationships between a single measure (or fact) table that contains one or more measures, and its dimension tables.
A measure table consists of measures and references to dimension tables. Dimension tables contain attributes of measures. For example, a measure such as the number of defects can be viewed based on the attribute priority or the attribute severity. The measure and dimension tables are collectively called target tables. In the Rational ProjectConsole repository, these target tables store the data collected from your project sources.
The following figure illustrates a star schema design:
In constructing a metrics warehouse schema, you must create the dimension tables first so that the attribute fields exist before you create the measure tables that reference them.
For more information about the design and components of the Rational ProjectConsole repository, see Working with target tables and Using a star schema design.