DBScholar

Back to papers

Intermittent Query Processing

Summary: Proposes Intermittent Query Processing (IQP): binds query execution to refresh policies triggered by intermittent data arrivals. PostgreSQL prototype persists operator state for fast updates; inactivity throttling lowers resources and latency versus batch, with memory comparable to IV maintenance. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
12025
Venue
VLDB
Year
2019
Pagerank
5.6756294e-05
Overall Rank
7,200 | 50.61%
DOI
10.14778/3342263.3342278

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{tang_vldb19,
        title = {{Intermittent Query Processing}},
        author = {Tang, Dixin and Shang, Zechao and Elmore, Aaron J. and Krishnan, Sanjay and Franklin, Michael J.},
        journal = {PVLDB},
        series = {{VLDB} '19},
        volume = {12},
        number = {11},
        pages = {1427--1441},
        doi = {10.14778/3342263.3342278},
        url = {https://doi.org/10.14778/3342263.3342278},
        year = {2019}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank Citing Paper Year Venue Pagerank
3,072 Lux: Always-on Visualization Recommendations for Exploratory Dataframe Workflows 2022 VLDB 7.7873864e-05
5,348 Crystal: A Unified Cache Storage System for Analytical Databases 2021 VLDB 6.2562688e-05
6,626 Tempura: A General Cost-Based Optimizer Framework for Incremental Data Processing 2021 VLDB 5.8198723e-05
6,684 CrocodileDB: Efficient Database Execution through Intelligent Deferment 2020 CIDR 5.8036476e-05
7,579 Resource-efficient Shared Query Execution via Exploiting Time Slackness 2021 SIGMOD 5.592546e-05
7,967 Thrifty Query Execution via Incrementability 2020 SIGMOD 5.5169373e-05
8,571 Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI) 2022 SIGMOD 5.4102496e-05
8,818 Resource-Adaptive Query Execution with Paged Memory Management 2025 CIDR 5.3637177e-05
9,175 CrocodileDB in Action: Resource-Efficient Query Execution by Exploiting Time Slackness 2020 VLDB 5.3087332e-05
10,842 Agamotto: Scheduling of Deadline-Oriented Incremental Query Execution under Uncertain Resource Price 2025 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 41 of 41 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0024089429
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
25 NiagaraCQ: A Scalable Continuous Query System for Internet Databases 2000 SIGMOD 0.00054667018
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00047309646
61 Maintaining Views Incrementally 1993 SIGMOD 0.00039026867
87 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035281619
111 TelegraphCQ: Continuous Dataflow Processing for an Uncertain World 2003 CIDR 0.00032990214
112 HoloClean: Holistic Data Repairs with Probabilistic Inference 2017 VLDB 0.00032801121
254 Record Linkage: Similarity Measures and Algorithms 2006 SIGMOD 0.00023199211
361 The Dataflow Model: A Practical Approach to Balancing Correctness, Latency, and Cost in Massive-Scale, Unbounded, Out-of-Order Data Processing 2015 VLDB 0.00020138717
376 Discovering Denial Constraints 2013 VLDB 0.00019677674
438 DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views 2012 VLDB 0.00018471721
461 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00018068441
549 ERACER: A Database Approach for Statistical Inference and Data Cleaning 2010 SIGMOD 0.00016692839
640 Materialization Optimizations for Feature Selection Workloads 2014 SIGMOD 0.00015409494
661 Don’t be SCAREd: Use SCalable Automatic REpairing with Maximal Likelihood and Bounded Changes 2013 SIGMOD 0.0001519162
671 Load Shedding in a Data Stream Manager 2003 VLDB 0.00015154516
736 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00014508563
816 The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates 2017 SIGMOD 0.00013827772
929 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013152103
943 DynaMat: A Dynamic View Management System for Data Warehouses 1999 SIGMOD 0.00013068595
1,133 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00012039326
1,218 P-Store: An Elastic Database System with Predictive Provisioning 2018 SIGMOD 0.00011621066
1,750 Lazy Maintenance of Materialized Views 2007 VLDB 9.8392477e-05
1,765 Selecting Subexpressions to Materialize at Datacenter Scale 2018 VLDB 9.8079546e-05
1,945 Continuous Analytics Over Discontinuous Streams 2010 SIGMOD 9.4348569e-05
2,059 LINVIEW: Incremental View Maintenance for Complex Analytical Queries 2014 SIGMOD 9.2471145e-05
2,151 An Architecture for Recycling Intermediates in a Column-store 2009 SIGMOD 9.0784444e-05
2,280 Partial Results for Online Query Processing 2002 SIGMOD 8.8129961e-05
2,771 Supporting Multiple View Maintenance Policies 1997 SIGMOD 8.1455861e-05
3,087 How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates 2016 SIGMOD 7.7702906e-05
3,206 Incremental View Maintenance with Triple Lock Factorization Benefits 2018 SIGMOD 7.6367549e-05
3,370 Revisiting Reuse for Approximate Query Processing 2017 VLDB 7.4700891e-05
3,707 Query Suspend and Resume 2007 SIGMOD 7.1818056e-05
4,250 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.8031294e-05
4,764 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 6.51896e-05
5,521 Staying FIT: Efficient Load Shedding Techniques for Distributed Stream Processing 2007 VLDB 6.1881166e-05
5,947 Revisiting Reuse in Main Memory Database Systems 2017 SIGMOD 6.0323707e-05
6,122 iOLAP: Managing Uncertainty for Efficient Incremental OLAP 2016 SIGMOD 5.9687498e-05
6,739 Utilizing IDs to Accelerate Incremental View Maintenance 2015 SIGMOD 5.7873433e-05
8,194 Resumable Online Index Rebuild in SQL Server 2017 VLDB 5.469529e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 10,969 Improving DBMS Scheduling Decisions with Accurate Performance Prediction on Concurrent Queries 2025 VLDB
2 10,634 Efficient Approximate Query Processing with Block Sampling 2025 CIDR
3 10,078 Request Window: an Approach to Improve Throughput of RDBMS-based Data Integration System by Utilizing Data Sharing Across Concurrent Distributed Queries 2007 VLDB
4 3,760 Query Processing in Tertiary Memory Databases 1995 VLDB
5 832 Streaming Queries over Streaming Data 2002 VLDB
6 4,880 An Incremental Anytime Algorithm for Multi-Objective Query Optimization 2015 SIGMOD
7 8,625 QPPT: Query Processing on Prefix Trees 2013 CIDR
8 10,342 Approximate Query Processing under Updates 2026 SIGMOD
9 7,321 Update-Pattern-Aware Modeling and Processing of Continuous Queries 2005 SIGMOD
10 7,967 Thrifty Query Execution via Incrementability 2020 SIGMOD