loading...
A Comparison of Three Methods for Join View Maintenance in Parallel RDBMS
Bangalore, India March 05-March 08
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2003.126079119th International Conference on Data ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
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
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.
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, pp.177, 19th International Conference on Data Engineering (ICDE'03), 2003
Usage of this product signifies your acceptance of the Terms of Use.


Suggestions