Description of the illustration materialized

This graphic shows several detail tables in the database. A materialized view is created by taking certain rows from each of the detail tables; thus, enabling only the desired information to be shown when a select is performed on the materialized view. However, all updates are applied solely to the detail tables and then reflected in the materialized view.