Currency-based updates to distributed materialized views

Conference · 01 June 1989

DOI:https://doi.org/10.1109/ICDE.1990.113505· OSTI ID:7222423

Segev, A.; Fang, W.

In currency-based updates, processing a query to a materialized view has to satisfy a currency constraint which specifies the maximum time lag of the view data with respect to a transaction database. Currency-based update policies are more general than periodical, deferred, and immediate updates; they provide additional opportunities for optimization and allow updating a materialized view from other materialized views. In this paper, we present algorithms to determine the source and timing of view updates and validate the resulting cost savings through simulation results. 20 refs.

• Research Organization: Lawrence Berkeley Lab., CA (USA)
• Sponsoring Organization: DOE/ER
• DOE Contract Number: AC03-76SF00098
• OSTI ID: 7222423
• Report Number(s): LBL-27359; CONF-900214--2; ON: DE90007775
• Country of Publication: United States
• Language: English

Related Subjects

99 GENERAL AND MISCELLANEOUS
990300* -- Information Handling
ALGORITHMS
COMPUTER NETWORKS
COST ESTIMATION
DATA BASE MANAGEMENT
INFORMATION RETRIEVAL
MANAGEMENT
MATHEMATICAL LOGIC
SIMULATION