You can modify the schema, create tables and indexes, and
build relationships between tables. IBM® InfoSphere™ Data Architect
is the recommended tool for working with the Rational® Insight data warehouse.
Rational Insight data warehouse model
The IBM Rational Insight
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.
Creating a data design project
To store the data models, you need a data design project
where you can place your data model.
Creating a table
You can create tables for facts, dimensions, and history.
You can customize the Rational Insight
data warehouse schema
by adding tables to it.
Linking two tables
Tables are linked through their primary keys and foreign
keys. The primary key of one table is defined as the foreign key of
the other table.
Joining two tables
You can create a view for an SQL query for joining two
tables. The table joins can be stored as views and executed.
Administering the Rational data warehouse
If you are the administrator of the IBM Rational Insight
data warehouse, you
need to monitor, maintain, and back up the data warehouse. These tasks
are specific to the relational database management system (RDBMS)
you are using to host the data warehouse.