Stale View Cleaning: Getting Fresh Answers from Stale Materialized Views

@article{Krishnan2015StaleVC,
  title={Stale View Cleaning: Getting Fresh Answers from Stale Materialized Views},
  author={Sanjay Krishnan and Jiannan Wang and Michael J. Franklin and Kenneth Y. Goldberg and Tim Kraska},
  journal={ArXiv},
  year={2015},
  volume={abs/1509.07454}
}
  • Sanjay Krishnan, Jiannan Wang, +2 authors Tim Kraska
  • Published 2015
  • Computer Science
  • ArXiv
  • Materialized views (MVs), stored pre-computed results, are widely used to facilitate fast queries on large datasets. When new records arrive at a high rate, it is infeasible to continuously update (maintain) MVs and a common solution is to defer maintenance by batching updates together. Between batches the MVs become increasingly stale with incorrect, missing, and superfluous rows leading to increasingly inaccurate query results. We propose Stale View Cleaning (SVC) which addresses this problem… CONTINUE READING

    Figures and Topics from this paper.

    Explore key concepts

    Links to highly relevant papers for key concepts in this paper:

    Citations

    Publications citing this paper.
    SHOWING 1-10 OF 26 CITATIONS, ESTIMATED 89% COVERAGE

    SampleClean: Fast and Reliable Analytics on Dirty Data

    VIEW 10 EXCERPTS
    CITES BACKGROUND

    Approximate Query Processing: What is New and Where to Go?

    VIEW 2 EXCERPTS
    CITES BACKGROUND

    Virtual lightweight snapshots for consistent analytics in NoSQL stores

    VIEW 1 EXCERPT
    CITES BACKGROUND

    FILTER CITATIONS BY YEAR

    2015
    2020

    References

    Publications referenced by this paper.
    SHOWING 1-10 OF 70 REFERENCES

    Materialized Views

    VIEW 16 EXCERPTS
    HIGHLY INFLUENTIAL

    Materialized Sample Views for Database Approximation

    VIEW 1 EXCERPT

    Knowing when you're wrong: building fast and reliable approximate query processing systems

    VIEW 4 EXCERPTS
    HIGHLY INFLUENTIAL

    Maintenance of materialized views of sampling queries

    VIEW 1 EXCERPT