Data Management

A Comparison of Three Methods for Join View Maintenance in Parallel RDBMS

Free registration required

Executive Summary

In a typical data warehouse, materialized views are used to speed up query execution. Upon updates to the base relations in the warehouse, these materialized views must also be maintained. The need to maintain these materialized views can have a negative impact on performance that is exacerbated in parallel RDBMSs, since simple single-node updates to base relations can give rise to expensive all-node operations for materialized view maintenance. In this paper, the authors present a comparison of three materialized join view maintenance methods in a parallel RDBMS, which they refer to as the naive, auxiliary relation, and global index methods.

  • Format: PDF
  • Size: 158 KB