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.637515e-05
Overall Rank
3,094 | 79.27%
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
955 Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics 2021 CIDR 0.00012856295
1,132 Qd-tree: Learning Data Layouts for Big Data Analytics 2020 SIGMOD 0.00011873466
2,772 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 8.0148928e-05
2,891 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.887378e-05
3,081 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6515625e-05
5,272 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.1887235e-05
5,632 BinDex: A Two-Layered Index for Fast and Robust Scans 2020 SIGMOD 6.0402517e-05
5,856 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.9514226e-05
6,459 RTScan: Efficient Scan with Ray Tracing Cores 2024 VLDB 5.7607157e-05
6,977 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.6135617e-05
7,019 Statisticum: Data Statistics Management in SAP HANA 2017 VLDB 5.6041386e-05
7,264 Pruning in Snowflake: Working Smarter, Not Harder 2025 SIGMOD 5.5557256e-05
7,585 SIEVE: Effective Filtered Vector Search with Collection of Indexes 2025 VLDB 5.4747603e-05
8,222 Sieve: A Learned Data-Skipping Index for Data Analytics 2023 VLDB 5.3585489e-05
8,505 Provenance-based Data Skipping 2022 VLDB 5.3126038e-05
10,774 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.9605343e-05
11,183 Optimizing Block Skipping for High-Dimensional Data with Learned Adaptive Curve 2025 SIGMOD 4.9605343e-05
11,195 Dynamic Pruning for Recursive Joins 2025 SIGMOD 4.9605343e-05
11,654 Partition, Don’t Sort! Compression Boosters for Cloud Data Ingestion Pipelines 2024 VLDB 4.9605343e-05
11,777 SH2O: Efficient Data Access for Work-Sharing Databases 2023 SIGMOD 4.9605343e-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.00068985264
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00063972112
23 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00055523999
49 Dremel: Interactive Analysis of Web-Scale Datasets 2010 VLDB 0.00043085722
52 The Snowflake Elastic Data Warehouse 2016 SIGMOD 0.00041439488
61 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.00039323387
89 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035265687
122 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030701814
161 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027629724
177 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026571747
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
226 Amazon Redshift and the Case for Simpler Data Warehouses 2015 SIGMOD 0.0002389883
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023296011
253 Database Cracking 2007 CIDR 0.00023037921
431 HYRISE—A Main Memory Hybrid Storage Engine 2011 VLDB 0.00018411252
1,039 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.00012349128
1,212 Processing a Trillion Cells per Mouse Click 2012 VLDB 0.00011493478
1,383 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010826996
1,646 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 9.9748468e-05
1,696 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8272691e-05
2,168 Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries 2008 VLDB 8.9159881e-05
2,392 The Uncracked Pieces in Database Cracking 2014 VLDB 8.5172189e-05
2,700 Major Technical Advancements in Apache Hive 2014 SIGMOD 8.096888e-05
2,862 JSON Data Management – Supporting Schema-less Development in RDBMS 2014 SIGMOD 7.9096239e-05
2,918 Column-Oriented Storage Techniques for MapReduce 2011 VLDB 7.8517976e-05
3,453 Advanced Partitioning Techniques for Massively Distributed Computation 2012 SIGMOD 7.2720027e-05
3,867 Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2 2003 VLDB 6.9438458e-05
6,785 Understanding Insights into the Basic Structure and Essential Issues of Table Placement Methods in Clusters 2013 VLDB 5.6659903e-05
7,219 A Comparison of Knives for Bread Slicing 2013 VLDB 5.5673339e-05
Previous Page 1 / 1 Next

Semantically Similar Papers