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.661199e-05
Overall Rank
6,807 | 54.38%
DOI
10.14778/3342263.3342278
PDF
Download (CC BY-NC-ND 4.0)

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,110 Lux: Always-on Visualization Recommendations for Exploratory Dataframe Workflows 2022 VLDB 7.6228505e-05
5,210 Crystal: A Unified Cache Storage System for Analytical Databases 2021 VLDB 6.2142008e-05
6,724 Tempura: A General Cost-Based Optimizer Framework for Incremental Data Processing 2021 VLDB 5.6834238e-05
6,835 CrocodileDB: Efficient Database Execution through Intelligent Deferment 2020 CIDR 5.6527238e-05
7,741 Resource-efficient Shared Query Execution via Exploiting Time Slackness 2021 SIGMOD 5.4469162e-05
8,154 Thrifty Query Execution via Incrementability 2020 SIGMOD 5.3732833e-05
8,585 Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI) 2022 SIGMOD 5.2943199e-05
9,014 Resource-Adaptive Query Execution with Paged Memory Management 2025 CIDR 5.2235585e-05
9,354 CrocodileDB in Action: Resource-Efficient Query Execution by Exploiting Time Slackness 2020 VLDB 5.1751422e-05
10,955 Storing and Indexing Multiple Tables by Interesting Orderings: For Efficient Joins, Groupings, and Updates in Relational Databases 2026 VLDB 4.9605343e-05
11,312 Agamotto: Scheduling of Deadline-Oriented Incremental Query Execution under Uncertain Resource Price 2025 VLDB 4.9605343e-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.0023948467
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061463175
25 NiagaraCQ: A Scalable Continuous Query System for Internet Databases 2000 SIGMOD 0.00053734242
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00046445099
62 Maintaining Views Incrementally 1993 SIGMOD 0.00038944207
89 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035265687
100 HoloClean: Holistic Data Repairs with Probabilistic Inference 2017 VLDB 0.00033951027
112 TelegraphCQ: Continuous Dataflow Processing for an Uncertain World 2003 CIDR 0.00032341214
264 Record Linkage: Similarity Measures and Algorithms 2006 SIGMOD 0.0002276412
328 The Dataflow Model: A Practical Approach to Balancing Correctness, Latency, and Cost in Massive-Scale, Unbounded, Out-of-Order Data Processing 2015 VLDB 0.00020889528
348 Discovering Denial Constraints 2013 VLDB 0.00020216677
408 DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views 2012 VLDB 0.00018836656
458 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00017870238
544 ERACER: A Database Approach for Statistical Inference and Data Cleaning 2010 SIGMOD 0.00016584014
652 Don’t be SCAREd: Use SCalable Automatic REpairing with Maximal Likelihood and Bounded Changes 2013 SIGMOD 0.00015117165
656 Materialization Optimizations for Feature Selection Workloads 2014 SIGMOD 0.00015052106
680 Load Shedding in a Data Stream Manager 2003 VLDB 0.00014799878
746 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.0001426147
815 The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates 2017 SIGMOD 0.00013682594
927 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013020035
953 DynaMat: A Dynamic View Management System for Data Warehouses 1999 SIGMOD 0.0001287248
1,150 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00011766641
1,157 P-Store: An Elastic Database System with Predictive Provisioning 2018 SIGMOD 0.00011748784
1,757 Selecting Subexpressions to Materialize at Datacenter Scale 2018 VLDB 9.7050769e-05
1,790 Lazy Maintenance of Materialized Views 2007 VLDB 9.6228433e-05
1,997 Continuous Analytics Over Discontinuous Streams 2010 SIGMOD 9.217553e-05
2,083 LINVIEW: Incremental View Maintenance for Complex Analytical Queries 2014 SIGMOD 9.0563677e-05
2,092 An Architecture for Recycling Intermediates in a Column-store 2009 SIGMOD 9.0432353e-05
2,340 Partial Results for Online Query Processing 2002 SIGMOD 8.598874e-05
2,809 Supporting Multiple View Maintenance Policies 1997 SIGMOD 7.9616655e-05
3,122 Incremental View Maintenance with Triple Lock Factorization Benefits 2018 SIGMOD 7.6091671e-05
3,138 How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates 2016 SIGMOD 7.5866991e-05
3,428 Revisiting Reuse for Approximate Query Processing 2017 VLDB 7.2957009e-05
3,779 Query Suspend and Resume 2007 SIGMOD 7.0032366e-05
4,338 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.6413964e-05
4,855 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 6.3657929e-05
5,642 Revisiting Reuse in Main Memory Database Systems 2017 SIGMOD 6.0370517e-05
5,667 Staying FIT: Efficient Load Shedding Techniques for Distributed Stream Processing 2007 VLDB 6.0280889e-05
6,232 iOLAP: Managing Uncertainty for Efficient Incremental OLAP 2016 SIGMOD 5.8255726e-05
6,873 Utilizing IDs to Accelerate Incremental View Maintenance 2015 SIGMOD 5.6436117e-05
8,373 Resumable Online Index Rebuild in SQL Server 2017 VLDB 5.3282795e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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