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.3302146e-05
Overall Rank
8,490 | 42.94%
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,247 Pruning in Snowflake: Working Smarter, Not Harder 2025 SIGMOD 5.5734736e-05
8,408 FaDE: More Than a Million What-ifs Per Second 2025 VLDB 5.3364407e-05
10,853 I-Rex: An Interactive Debugger for SQL 2026 VLDB 4.9769913e-05
11,472 Towards an Objective Metric for Data Value Through Relevance 2024 CIDR 4.9769913e-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.00059813669
44 The R+-Tree: A Dynamic Multi-Dimensional Index for Objects 1987 VLDB 0.00045319457
88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035340164
190 Scorpion: Explaining Away Outliers in Aggregate Queries 2013 VLDB 0.0002582857
195 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025619089
216 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00024485637
238 Complexity of Answering Queries Using Materialized Views 1998 PODS 0.00023580688
408 DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views 2012 VLDB 0.00018894165
525 An Annotation Management System for Relational Databases 2004 VLDB 0.00016889428
553 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00016518678
671 A Formal Approach to Finding Explanations for Database Queries 2014 SIGMOD 0.00014948069
811 Provenance for Aggregate Queries 2011 PODS 0.00013746145
878 Interpretable and Informative Explanations of Outcomes 2015 VLDB 0.00013296412
1,531 Column Imprints: A Secondary Index Structure 2013 SIGMOD 0.00010344951
1,611 Efficient Provenance Storage 2008 SIGMOD 0.00010072076
1,713 SMOKE: Fine-grained Lineage at Interactive Speed 2018 VLDB 9.8129981e-05
1,812 ProvSQL: Provenance and Probability Management in PostgreSQL 2018 VLDB 9.5780882e-05
1,837 Merging What's Cracked, Cracking What's Merged: Adaptive Indexing in Main-Memory Column-Stores 2011 VLDB 9.5315292e-05
1,941 Caravan: Provisioning for What-If Analysis 2013 CIDR 9.3276626e-05
2,018 A Practical Scalable Distributed B-Tree 2008 VLDB 9.177956e-05
2,222 Explaining Query Answers with Explanation-Ready Databases 2016 VLDB 8.8106741e-05
2,418 The Semiring Framework for Database Provenance 2017 PODS 8.4904382e-05
2,812 Horizontal Data Partitioning In Database Design 1982 SIGMOD 7.9781733e-05
2,823 Vertical Partitioning for Database Design: A Graphical Algorithm 1989 SIGMOD 7.9667062e-05
3,083 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.6620866e-05
3,364 Efficient Querying and Maintenance of Network Provenance at Internet-Scale 2010 SIGMOD 7.3715499e-05
3,592 Two Birds, One Stone: A Fast, yet Lightweight, Indexing Scheme for Modern Database Systems 2017 VLDB 7.1807308e-05
4,066 Indexing on Modern Hardware: Hekaton and Beyond 2014 SIGMOD 6.8197032e-05
4,973 Efficient Bulk Updates on Multiversion B-trees 2013 VLDB 6.3299299e-05
5,628 Distributed Provenance Compression 2017 SIGMOD 6.0576733e-05
5,638 Revisiting Reuse in Main Memory Database Systems 2017 SIGMOD 6.0546358e-05
6,488 Approximate Summaries for Why and Why-not Provenance 2020 VLDB 5.7659318e-05
7,235 Hypothetical Reasoning via Provenance Abstraction 2019 SIGMOD 5.5765963e-05
7,712 Query Centric Partitioning and Allocation for Partially Replicated Database Systems 2017 SIGMOD 5.4705892e-05
7,823 You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance 2018 VLDB 5.4441002e-05
10,257 PROPOLIS: Provisioned Analysis of Data-Centric Processes 2013 VLDB 5.0490212e-05
12,243 Provenance Summaries for Answers and Non-Answers 2018 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Semantically Similar Papers