Abstract | ||
---|---|---|
The conventional way to process commands for relational views is to use query modification to translate the commands into ones on the base relations. An alternative approach has been proposed recently, whereby materialized copies of views are kept, and incrementally updated immediately after each modification of the database. A related scheme exists, in which update of materialized views is deferred until just before data is retrieved from the view. A performance analysis is presented comparing the cost of query modification, immediate view maintenance, and deferred view maintenance. Three different models of the structure of views are given a simple selection and projection of one relation, the natural join of two relations, and an aggregate (e.g. the sum of values in a column) over a selection-projection view. The results show that the choice of the most efficient view maintenance method depends heavily on the structure of the database, the view definition, and the type of query and update activity present. |
Year | DOI | Venue |
---|---|---|
1987 | 10.1145/38713.38759 | Materialized views |
Keywords | Field | DocType |
performance analysis,base relation,deferred view maintenance,immediate view maintenance,efficient view maintenance method,query modification,view definition,relational view,view materialization strategy,selection-projection view,alternative approach,update activity present,materialized views | Data mining,Information retrieval,Computer science,View maintenance,View,Materialized view,Database | Conference |
Volume | Issue | ISBN |
16 | 3 | 0-262-57122-6 |
Citations | PageRank | References |
127 | 48.49 | 14 |
Authors | ||
1 |
Name | Order | Citations | PageRank |
---|---|---|---|
Eric N. Hanson | 1 | 917 | 376.11 |