The DOI matches its Crossref record.
Efficiently updating materialized views
Open accessAbstract
Query processing can be sped up by keeping frequently accessed users' views materialized. However, the need to access base relations in response to queries can be avoided only if the materialized view is adequately maintained. We propose a method in which all database updates to base relations are first filtered to remove from consideration those that cannot possibly affect the view. The conditions given for the detection of updates of this type, called irrelevant updates , are necessary and sufficient and are independent of the database state. For the remaining database updates, a differential algorithm can be applied to re-evaluate the view expression. The algorithm proposed exploits the knowledge provided by both the view definition expression and the database update operations.
Overview
The claims and statistics of this paper haven’t been checked yet.
Run the check — free, no account needed. It reads the open-access text and checks the sources it cites.
Integrity signals
Registry
Cites
Statistics
Verification
Claims the paper makes
The claims and statistics of this paper haven’t been checked yet.
Run the check — free, no account needed. It reads the open-access text and checks the sources it cites.
Self-check
Percentages, sums and reported differences re-computed from the paper’s own numbers.
The self-check needs the paper’s full text.
Citations
Cited by
Streams and Tables: Two Sides of the Same Coin
Sax, M. J., Wang, G., Weidlich, M., & Freytag, J.-C. (2018) · Proceedings of the International Workshop on Real-Time Business Intelligence and Analytics · doi:10.1145/3242153.3242155 · Cited by 51
MatKV: Trading Compute for Flash Storage in LLM Inference
Shin, K.-W., Park, J. H., Oh, M., Jo, Y., Do, J., & Lee, S.-W. (2026) · 2026 IEEE 42nd International Conference on Data Engineering (ICDE) · doi:10.1109/icde65706.2026.00071
Metadata
- Authors
- Blakeley, J. A., Larson, P.-A., & Tompa, F. W.
- Venue
- ACM SIGMOD Record
- Published
- 1986-06-15
- Volume
- 15
- Issue
- 2
- Pages
- 61-71
- ISSN
- 0163-5808 (ISSN-L)
- OpenAlex
- W2116476518
- Cited by
- 429
- References
- 0
- FWCI
- 17.06
- Type
- journal article
- Language
- en
- Open access
- bronze
About these checks
Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.
Statistics and arithmetic are recomputed, not judged.
Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.
What counts as a claim ›How we measure confidence ›How we check this ›
Are you an author, or do you see a problem with this page? Request a review
How to cite
Cite CoChat for the checks on this page, and the paper for its own findings.
- This page
- CoChat. (2026). Citation check: Efficiently updating materialized views. https://app.cochat.ai/papers/10.1145/16856.16861
- The paper
- Blakeley, J. A., Larson, P.-A., & Tompa, F. W. (1986). Efficiently updating materialized views. ACM SIGMOD Record. https://doi.org/10.1145/16856.16861
Data sources
Bibliographic data: Semantic Scholar, OpenAlex, Crossref.
Contains information from the Semantic Scholar Academic Graph Datasets, made available under the ODC Attribution License (ODC-BY 1.0).
Semantic Scholar’s data is described in: Kinney, R., et al. (2023). The Semantic Scholar Open Data Platform. arXiv:2301.10140.
