Non-blocking Creation and Maintenance of Materialized Views
Øystein Aalstad Jonasson · BIBSYS Brage (BIBSYS (Norway)) · 2006
The approach used in this document is to create an assisting table as a bridge between the base table and view, on which only projection of non-identifying attributes is performed. This makes it possibly to distinguish individual records to enable log recovery methods to keep the assisting table consistent with the base table. The assisting table can then be used to create and maintain the view without blocking the base table.