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
he0dcfd459a241c20
Venue
VLDB
Year
2019
Pagerank
5.6803529e-05
Overall Rank
6,796 | 54.31%
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 11 of 11 citing papers.

Rank Citing Paper Year Venue Pagerank
3,098 Lux: Always-on Visualization Recommendations for Exploratory Dataframe Workflows 2022 VLDB 7.6517623e-05
5,446 Crystal: A Unified Cache Storage System for Analytical Databases 2021 VLDB 6.1266228e-05
6,706 Tempura: A General Cost-Based Optimizer Framework for Incremental Data Processing 2021 VLDB 5.7049776e-05
6,814 CrocodileDB: Efficient Database Execution through Intelligent Deferment 2020 CIDR 5.6735614e-05
7,722 Resource-efficient Shared Query Execution via Exploiting Time Slackness 2021 SIGMOD 5.467573e-05
8,131 Thrifty Query Execution via Incrementability 2020 SIGMOD 5.3936608e-05
8,560 Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI) 2022 SIGMOD 5.3142933e-05
8,983 Resource-Adaptive Query Execution with Paged Memory Management 2025 CIDR 5.2433703e-05
9,320 CrocodileDB in Action: Resource-Efficient Query Execution by Exploiting Time Slackness 2020 VLDB 5.1946265e-05
10,885 Storing and Indexing Multiple Tables by Interesting Orderings: For Efficient Joins, Groupings, and Updates in Relational Databases 2026 VLDB 4.9793485e-05
11,248 Agamotto: Scheduling of Deadline-Oriented Incremental Query Execution under Uncertain Resource Price 2025 VLDB 4.9793485e-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.0023947656
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061066921
25 NiagaraCQ: A Scalable Continuous Query System for Internet Databases 2000 SIGMOD 0.00053930011
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00046602544
62 Maintaining Views Incrementally 1993 SIGMOD 0.00039045511
88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035351639
104 HoloClean: Holistic Data Repairs with Probabilistic Inference 2017 VLDB 0.00033690989
112 TelegraphCQ: Continuous Dataflow Processing for an Uncertain World 2003 CIDR 0.00032459277
262 Record Linkage: Similarity Measures and Algorithms 2006 SIGMOD 0.00022821392
325 The Dataflow Model: A Practical Approach to Balancing Correctness, Latency, and Cost in Massive-Scale, Unbounded, Out-of-Order Data Processing 2015 VLDB 0.00020964941
350 Discovering Denial Constraints 2013 VLDB 0.00020253521
408 DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views 2012 VLDB 0.00018900199
460 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00017842695
547 ERACER: A Database Approach for Statistical Inference and Data Cleaning 2010 SIGMOD 0.00016578131
652 Don’t be SCAREd: Use SCalable Automatic REpairing with Maximal Likelihood and Bounded Changes 2013 SIGMOD 0.00015121325
654 Materialization Optimizations for Feature Selection Workloads 2014 SIGMOD 0.0001510357
676 Load Shedding in a Data Stream Manager 2003 VLDB 0.00014853749
744 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00014309622
812 The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates 2017 SIGMOD 0.00013729015
923 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013064753
949 DynaMat: A Dynamic View Management System for Data Warehouses 1999 SIGMOD 0.00012902181
1,150 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00011809311
1,160 P-Store: An Elastic Database System with Predictive Provisioning 2018 SIGMOD 0.00011769228
1,745 Selecting Subexpressions to Materialize at Datacenter Scale 2018 VLDB 9.7343818e-05
1,779 Lazy Maintenance of Materialized Views 2007 VLDB 9.6583009e-05
1,985 Continuous Analytics Over Discontinuous Streams 2010 SIGMOD 9.2521678e-05
2,084 An Architecture for Recycling Intermediates in a Column-store 2009 SIGMOD 9.0716512e-05
2,087 LINVIEW: Incremental View Maintenance for Complex Analytical Queries 2014 SIGMOD 9.068879e-05
2,324 Partial Results for Online Query Processing 2002 SIGMOD 8.6310477e-05
2,801 Supporting Multiple View Maintenance Policies 1997 SIGMOD 7.9914879e-05
3,112 Incremental View Maintenance with Triple Lock Factorization Benefits 2018 SIGMOD 7.6357579e-05
3,128 How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates 2016 SIGMOD 7.6151967e-05
3,419 Revisiting Reuse for Approximate Query Processing 2017 VLDB 7.3190065e-05
3,772 Query Suspend and Resume 2007 SIGMOD 7.0297582e-05
4,321 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.6660222e-05
4,832 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 6.3895407e-05
5,639 Revisiting Reuse in Main Memory Database Systems 2017 SIGMOD 6.0558642e-05
5,653 Staying FIT: Efficient Load Shedding Techniques for Distributed Stream Processing 2007 VLDB 6.0509231e-05
6,227 iOLAP: Managing Uncertainty for Efficient Incremental OLAP 2016 SIGMOD 5.8452386e-05
6,853 Utilizing IDs to Accelerate Incremental View Maintenance 2015 SIGMOD 5.6647271e-05
8,353 Resumable Online Index Rebuild in SQL Server 2017 VLDB 5.3484595e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 11,079 Efficient Approximate Query Processing with Block Sampling 2025 CIDR
2 10,148 Improving DBMS Scheduling Decisions with Accurate Performance Prediction on Concurrent Queries 2025 VLDB
3 10,289 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,845 Query Processing in Tertiary Memory Databases 1995 VLDB
5 852 Streaming Queries over Streaming Data 2002 VLDB
6 4,980 An Incremental Anytime Algorithm for Multi-Objective Query Optimization 2015 SIGMOD
7 8,780 QPPT: Query Processing on Prefix Trees 2013 CIDR
8 10,544 Approximate Query Processing under Updates 2026 SIGMOD
9 7,462 Update-Pattern-Aware Modeling and Processing of Continuous Queries 2005 SIGMOD
10 8,131 Thrifty Query Execution via Incrementability 2020 SIGMOD