Non-blocking Materialized View Creation and Transformation of Schemas

In existing systems, user transactions get blocked during materialized view creation and non-trivial database schema transformations. Blocking user transactions is not an option in systems with high availability requirements. A non-blocking method to perform such tasks is therefore needed. In this paper, we present a method for non-blocking creation of derived tables, suitable for highly available databases. These derived tables can be used to create materialized views and to transform the database schema. Modified versions of well-known crash recovery techniques are used, thus making the method easy to integrate into existing DBMSs. Because the involved tables are not locked, the derived table creation may run as a low priority background process. As a result, the process has little impact on concurrent user transactions.

• Type: Conference
• Year: 2006
• Where: ADBIS
• Authors: Jørgen Løland, Svein-Olaf Hvasshovd
• Keywords: ADBIS 2006, Database, Database Schema, Materialized Views, User Transactions