|
Published Articles >> Table of Contents >> Abstract
19th International Conference on Data Engineering (ICDE'03)
p. 177
A Comparison of Three Methods for Join View Maintenance in Parallel RDBMS
Gang Luo, University of Wisconsin-Madison
Jeffrey F. Naughton, University of Wisconsin-Madison
Curt J. Ellmann, NCR Advance Development Lab
Michael W. Watzke, NCR Advance Development Lab
Full Article Text:
  
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2003.1260791
Send link to a friend
| Abstract |
|
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, we present a comparison of three materialized join view maintenance methods in a parallel RDBMS, which we refer to as the naive, auxiliary relation, and global index methods. The last two methods improve performance at the cost of using more space. The results of this study show that the method of choice depends on the environment, in particular, the update activity on base relations and the amount of available storage space.
|
 Additional Information
|
Citation:
Gang Luo, Jeffrey F. Naughton, Curt J. Ellmann, Michael W. Watzke,
"A Comparison of Three Methods for Join View Maintenance in Parallel RDBMS,"
icde,
p. 177,
19th International Conference on Data Engineering (ICDE'03),
2003
|
|
