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.6620866e-05
Overall Rank
3,083 | 79.28%
DOI
10.14778/3021924.3021933
PDF
Download (CC BY-NC-ND 4.0)

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.00012889569
1,128 Qd-tree: Learning Data Layouts for Big Data Analytics 2020 SIGMOD 0.00011901941
2,765 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 8.0401855e-05
2,880 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.9118308e-05
3,075 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6742518e-05
5,250 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.2092552e-05
5,619 BinDex: A Two-Layered Index for Fast and Robust Scans 2020 SIGMOD 6.0602908e-05
5,842 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.971167e-05
6,447 RTScan: Efficient Scan with Ray Tracing Cores 2024 VLDB 5.7798274e-05
6,971 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.628441e-05
7,000 Statisticum: Data Statistics Management in SAP HANA 2017 VLDB 5.6226404e-05
7,247 Pruning in Snowflake: Working Smarter, Not Harder 2025 SIGMOD 5.5734736e-05
7,570 SIEVE: Effective Filtered Vector Search with Collection of Indexes 2025 VLDB 5.4929234e-05
8,207 Sieve: A Learned Data-Skipping Index for Data Analytics 2023 VLDB 5.3763264e-05
8,490 Provenance-based Data Skipping 2022 VLDB 5.3302146e-05
10,713 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.9769913e-05
11,122 Optimizing Block Skipping for High-Dimensional Data with Learned Adaptive Curve 2025 SIGMOD 4.9769913e-05
11,135 Dynamic Pruning for Recursive Joins 2025 SIGMOD 4.9769913e-05
11,607 Partition, Don’t Sort! Compression Boosters for Cloud Data Ingestion Pipelines 2024 VLDB 4.9769913e-05
11,733 SH2O: Efficient Data Access for Work-Sharing Databases 2023 SIGMOD 4.9769913e-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.0006897844
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00064013679
23 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00055384955
49 Dremel: Interactive Analysis of Web-Scale Datasets 2010 VLDB 0.0004314366
52 The Snowflake Elastic Data Warehouse 2016 SIGMOD 0.00041210636
61 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.00039236924
88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035340164
123 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030749898
163 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027480091
178 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026620521
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
233 Amazon Redshift and the Case for Simpler Data Warehouses 2015 SIGMOD 0.00023774958
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023349603
252 Database Cracking 2007 CIDR 0.00023101361
431 HYRISE—A Main Memory Hybrid Storage Engine 2011 VLDB 0.00018400856
1,036 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.00012372946
1,210 Processing a Trillion Cells per Mouse Click 2012 VLDB 0.0001152237
1,380 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010858313
1,642 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 0.00010002341
1,693 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8522869e-05
2,157 Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries 2008 VLDB 8.9425625e-05
2,384 The Uncracked Pieces in Database Cracking 2014 VLDB 8.5401256e-05
2,689 Major Technical Advancements in Apache Hive 2014 SIGMOD 8.1227087e-05
2,854 JSON Data Management – Supporting Schema-less Development in RDBMS 2014 SIGMOD 7.93571e-05
2,903 Column-Oriented Storage Techniques for MapReduce 2011 VLDB 7.877293e-05
3,440 Advanced Partitioning Techniques for Massively Distributed Computation 2012 SIGMOD 7.2954357e-05
3,857 Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2 2003 VLDB 6.9662462e-05
6,769 Understanding Insights into the Basic Structure and Essential Issues of Table Placement Methods in Clusters 2013 VLDB 5.6847727e-05
7,201 A Comparison of Knives for Bread Slicing 2013 VLDB 5.5857284e-05
Previous Page 1 / 1 Next

Semantically Similar Papers