Chapter 3 Building Physical Diagrams

Defining query tables in a physical diagram

A query table is a table whose data proceeds from the result of a query. In PowerDesigner, you design a query table using a view with a specific type, depending on the DBMS.

DB2

In DB2 CS7, you design a query table using a view with the summary table type. In later versions of DB2, you should use the materialized query table type.

For more information on summary tables and materialized views, see DB2 documentation.

Oracle

In Oracle, you design a query table using a view with the materialized view type. Materialized view is the new recommended name for snapshots that were used before version 8i.

For more information on materialized views and snapshots, see Oracle documentation.

Copyright (C) 2005. Sybase Inc. All rights reserved.