DBScholar

Back to papers

Skipping-oriented Partitioning for Columnar Layouts

Summary: Introduces Generalized Skipping-Oriented Partitioning (GSOP) for columnar layouts. Jointly optimizes horizontal skipping and vertical partitioning to balance skip opportunities with tuple reconstruction, reducing scanned data and improving end-to-end queries vs. state-of-the-art on benchmarks and real workloads. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h2cf7775a3b3c13a2
Venue
VLDB
Year
2017
Pagerank
7.6653727e-05
Overall Rank
3,081 | 79.29%
DOI
10.14778/3021924.3021933

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{sun_vldb17,
        title = {{Skipping-oriented Partitioning for Columnar Layouts}},
        author = {Sun, Liwen and Franklin, Michael J. and Wang, Jiannan and Wu, Eugene},
        journal = {PVLDB},
        series = {{VLDB} '17},
        volume = {10},
        number = {4},
        pages = {421--432},
        doi = {10.14778/3021924.3021933},
        url = {https://doi.org/10.14778/3021924.3021933},
        year = {2017}
}

Incoming Citations (Sorted by Pagerank)

Showing 20 of 20 citing papers.

Rank Citing Paper Year Venue Pagerank
950 Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics 2021 CIDR 0.00012895553
1,132 Qd-tree: Learning Data Layouts for Big Data Analytics 2020 SIGMOD 0.00011898257
2,765 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 8.0439015e-05
2,882 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.9116043e-05
3,073 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6777283e-05
5,248 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.211056e-05
5,618 BinDex: A Two-Layered Index for Fast and Robust Scans 2020 SIGMOD 6.0630987e-05
5,854 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.9708829e-05
6,444 RTScan: Efficient Scan with Ray Tracing Cores 2024 VLDB 5.7825648e-05
6,970 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.6311067e-05
6,999 Statisticum: Data Statistics Management in SAP HANA 2017 VLDB 5.6252486e-05
7,245 Pruning in Snowflake: Working Smarter, Not Harder 2025 SIGMOD 5.5761132e-05
7,564 SIEVE: Effective Filtered Vector Search with Collection of Indexes 2025 VLDB 5.4955249e-05
8,199 Sieve: A Learned Data-Skipping Index for Data Analytics 2023 VLDB 5.3788727e-05
8,495 Provenance-based Data Skipping 2022 VLDB 5.3304338e-05
10,703 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.9793485e-05
11,113 Optimizing Block Skipping for High-Dimensional Data with Learned Adaptive Curve 2025 SIGMOD 4.9793485e-05
11,126 Dynamic Pruning for Recursive Joins 2025 SIGMOD 4.9793485e-05
11,601 Partition, Don’t Sort! Compression Boosters for Cloud Data Ingestion Pipelines 2024 VLDB 4.9793485e-05
11,727 SH2O: Efficient Data Access for Work-Sharing Databases 2023 SIGMOD 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 30 of 30 cited papers.

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

Rank Cited Paper Year Venue Pagerank
12 C-Store: A Column-oriented DBMS 2005 VLDB 0.00068998927
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00064031282
23 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00055406774
49 Dremel: Interactive Analysis of Web-Scale Datasets 2010 VLDB 0.00043160717
52 The Snowflake Elastic Data Warehouse 2016 SIGMOD 0.00041219077
61 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.000392237
88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035351639
123 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030762995
163 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.0002749118
179 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026611886
195 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025628849
216 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00024485024
233 Amazon Redshift and the Case for Simpler Data Warehouses 2015 SIGMOD 0.00023783585
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023358891
253 Database Cracking 2007 CIDR 0.00023042111
431 HYRISE—A Main Memory Hybrid Storage Engine 2011 VLDB 0.00018403783
1,036 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.00012377471
1,210 Processing a Trillion Cells per Mouse Click 2012 VLDB 0.00011527605
1,380 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010862758
1,642 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 0.00010006413
1,694 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8562172e-05
2,155 Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries 2008 VLDB 8.9456729e-05
2,383 The Uncracked Pieces in Database Cracking 2014 VLDB 8.5435328e-05
2,689 Major Technical Advancements in Apache Hive 2014 SIGMOD 8.1264718e-05
2,854 JSON Data Management – Supporting Schema-less Development in RDBMS 2014 SIGMOD 7.9394584e-05
2,903 Column-Oriented Storage Techniques for MapReduce 2011 VLDB 7.8810111e-05
3,440 Advanced Partitioning Techniques for Massively Distributed Computation 2012 SIGMOD 7.2986853e-05
3,856 Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2 2003 VLDB 6.96934e-05
6,763 Understanding Insights into the Basic Structure and Essential Issues of Table Placement Methods in Clusters 2013 VLDB 5.6874593e-05
7,199 A Comparison of Knives for Bread Slicing 2013 VLDB 5.5883682e-05
Previous Page 1 / 1 Next

Semantically Similar Papers