IBM Rational Insight data warehouse metadata model

This section describes the metadata model for IBM® Rational® Insight data warehouse (RIDW). It provides a business view of the information in the source data to simplify building reports, analyses, and queries.

The business view:

The RIDW model contains the following entities.

Physical metadata

This layer contains query subjects representing the imported tables and relationships between them. The relationships are inferred from the relationships defined in the imported file. It includes fact tables, dimension tables, and view tables to enable drilling down to details.

Dimensions

This layer contains regular dimensions, measure dimensions, and scope relationships. The regular dimension objects are based on query subjects representing dimension tables. They may be either conformed or non-conformed. The measure dimension objects are based on query subjects representing fact tables. The scope relationships are inferred from the relationships defined in the imported file.

Consolidate view

This layer contains query subjects that represent data in terms of business needs and report requirements. Filters, calculations, and parameter maps are defined in this view. Rational Insight uses the following settings in this layer:

Business View

This layer contains shortcuts to the query subjects in the Operational data view. The shortcuts are grouped in star schema in namespaces that are further grouped into business domains.

When you use the Rational Insight sample metadata model, the following business domains are available:

Feedback