The data warehouse contains three data storage
areas: the configuration area, the operational data source, and the
data mart. As an administrator, you can monitor, maintain, and back
up the data warehouse.
Rational Integrated Data Warehouse model
The Rational® Integrated Data Warehouse (RIDW) is the component that stores data from various
operational systems in a format that facilitates analytical reporting,
and provides the engine required for query optimization, multidimensional
analysis, and historical trending. Its data structure is different
from that of live transactional systems, which generally store information
in normalized form. While incoming data passes through several stages
during which it is stored temporarily in normalized tables, the final
format used is a star schema. This section describes the basic data
structure of the RIDW.
Administering the Rational Integrated Data Warehouse
If you are the administrator of the Rational Integrated Data Warehouse, you need
to monitor, maintain, and back up the data warehouse. These tasks
are specific to the relational database management system (RDBMS)
that you are using to host the data warehouse.