Optimal Update Policies for Distributed Materialized Views

Arie Segev and Weiping Fang
Additional contact information
Arie Segev: Walter A. Haas School of Business, University of California at Berkeley, Berkeley, California 94720 and Information & Computing Sciences Division, Lawrence Berkeley Laboratory, Berkeley, California 94720
Weiping Fang: Industrial Engineering & Operations Research Department, University of California at Berkeley, Berkeley, California 94720 and Information & Computing Sciences Division, Lawrence Berkeley Laboratory, Berkeley, California 94720

Management Science, 1991, vol. 37, issue 7, 851-870

Abstract: In this paper we present an analysis of the problem of determining optimal policies for updating distributed materialized views. We demonstrate the general application of materialized views, and define the concept of materialized view currency and allow a query to specify its currency requirement. We also allow a materialized view to be updated from either a base relation or another materialized view. This flexibility provides an opportunity for further reduction in the cost of maintaining distributed materialized views. We model the problem of optimal update policies to capture currency and policy constraints, replicated data, and various view update policies. The optimization incorporates a minimum-cost objective function as well as user's response time constraints.

Keywords: database; database views; materialized views; distributed databases; information (search for similar items in EconPapers)
Date: 1991
References: Add references at CitEc
Citations: View citations in EconPapers (2)

Downloads: (external link)
http://dx.doi.org/10.1287/mnsc.37.7.851 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:ormnsc:v:37:y:1991:i:7:p:851-870

Access Statistics for this article

More articles in Management Science from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().