Description of the illustration dwhsg071.eps

This figure illustrates how summary management works.

• First, data flows from an operational database to a staging file to the warehouse.

• From the warehouse, you can use tools as well as perform daily maintenance for ETL.

• You can use summary management on the materialized views.

• Query rewrite uses both the details tables and the materialized views.