DBScholar

Back to papers

Provenance-based Data Skipping

Summary: Proposes provenance-based data skipping (PBDS) that builds compact provenance sketches encoding data relevance for a query, e.g., HAVING and top-k. These sketches speed up subsequent queries and can leverage physical design artifacts like indexes and zone maps. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h8036c3eded510a16
Venue
VLDB
Year
2022
Pagerank
5.3126038e-05
Overall Rank
8,505 | 43.00%
DOI
10.14778/3494124.3494130
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{niu_vldb22,
        title = {{Provenance-based Data Skipping}},
        author = {Niu, Xing and Glavic, Boris and Liu, Ziyu and Li, Pengyuan and Gawlick, Dieter and Krishnaswamy, Vasudha and Liu, Zhen Hua and Porobic, Danica},
        journal = {PVLDB},
        series = {{VLDB} '22},
        volume = {15},
        number = {3},
        pages = {451--464},
        doi = {10.14778/3494124.3494130},
        url = {https://doi.org/10.14778/3494124.3494130},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank Citing Paper Year Venue Pagerank
7,264 Pruning in Snowflake: Working Smarter, Not Harder 2025 SIGMOD 5.5557256e-05
8,425 FaDE: More Than a Million What-ifs Per Second 2025 VLDB 5.3187951e-05
10,914 I-Rex: An Interactive Debugger for SQL 2026 VLDB 4.9605343e-05
11,524 Towards an Objective Metric for Data Value Through Relevance 2024 CIDR 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 37 of 37 cited papers.

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

Rank Cited Paper Year Venue Pagerank
17 Provenance Semirings 2007 PODS 0.00059660827
44 The R+-Tree: A Dynamic Multi-Dimensional Index for Objects 1987 VLDB 0.00045231517
89 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035265687
191 Scorpion: Explaining Away Outliers in Aggregate Queries 2013 VLDB 0.0002578784
196 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025581936
216 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00024446892
239 Complexity of Answering Queries Using Materialized Views 1998 PODS 0.00023510465
408 DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views 2012 VLDB 0.00018836656
529 An Annotation Management System for Relational Databases 2004 VLDB 0.00016834919
556 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00016470022
672 A Formal Approach to Finding Explanations for Database Queries 2014 SIGMOD 0.00014903109
811 Provenance for Aggregate Queries 2011 PODS 0.00013713646
879 Interpretable and Informative Explanations of Outcomes 2015 VLDB 0.00013255435
1,532 Column Imprints: A Secondary Index Structure 2013 SIGMOD 0.00010312002
1,621 Efficient Provenance Storage 2008 SIGMOD 0.00010039235
1,722 SMOKE: Fine-grained Lineage at Interactive Speed 2018 VLDB 9.781628e-05
1,822 ProvSQL: Provenance and Probability Management in PostgreSQL 2018 VLDB 9.5464187e-05
1,846 Merging What's Cracked, Cracking What's Merged: Adaptive Indexing in Main-Memory Column-Stores 2011 VLDB 9.5057831e-05
1,953 Caravan: Provisioning for What-If Analysis 2013 CIDR 9.297314e-05
2,028 A Practical Scalable Distributed B-Tree 2008 VLDB 9.1500243e-05
2,233 Explaining Query Answers with Explanation-Ready Databases 2016 VLDB 8.7844607e-05
2,427 The Semiring Framework for Database Provenance 2017 PODS 8.4673732e-05
2,823 Horizontal Data Partitioning In Database Design 1982 SIGMOD 7.9522816e-05
2,833 Vertical Partitioning for Database Design: A Graphical Algorithm 1989 SIGMOD 7.9443787e-05
3,094 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.637515e-05
3,373 Efficient Querying and Maintenance of Network Provenance at Internet-Scale 2010 SIGMOD 7.348575e-05
3,601 Two Birds, One Stone: A Fast, yet Lightweight, Indexing Scheme for Modern Database Systems 2017 VLDB 7.1582591e-05
4,087 Indexing on Modern Hardware: Hekaton and Beyond 2014 SIGMOD 6.7974724e-05
4,998 Efficient Bulk Updates on Multiversion B-trees 2013 VLDB 6.3089994e-05
5,641 Distributed Provenance Compression 2017 SIGMOD 6.0377578e-05
5,642 Revisiting Reuse in Main Memory Database Systems 2017 SIGMOD 6.0370517e-05
6,502 Approximate Summaries for Why and Why-not Provenance 2020 VLDB 5.7468661e-05
7,252 Hypothetical Reasoning via Provenance Abstraction 2019 SIGMOD 5.5583413e-05
7,725 Query Centric Partitioning and Allocation for Partially Replicated Database Systems 2017 SIGMOD 5.4526728e-05
7,840 You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance 2018 VLDB 5.4260988e-05
10,288 PROPOLIS: Provisioned Analysis of Data-Centric Processes 2013 VLDB 5.0323262e-05
12,286 Provenance Summaries for Answers and Non-Answers 2018 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Semantically Similar Papers