Dynamic creation of materialized database views

摘要

A control file is created which ordinary views that are to be converted to materialized views. A conversion program controlled by the control file can then create all of the materialized views at one time, and only that single conversion program needs to be written. By running the conversion program periodically, it becomes possible to create automatic updates of the materialized views.