Hybrid Row-Column Partitioning in Teradata

Summary: Hybrid row-column partitioning in Teradata stores row, column, or mixed partitions under a unified storage layer. The paper covers implementation, partitioned-table query optimization, and a study on how partition choices shape mixed-workload performance. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h4bc95a6f74bf5f5d
Venue: VLDB
Year: 2016
Pagerank: 5.1922811e-05
Overall Rank: 9,331 | 37.27%
DOI: 10.14778/3007263.3007275

Incoming Non-self Citations Over Time

Authors

1. Mohammed Al-Kateb (Teradata)
2. Paul Sinclair (Teradata)
3. Grace Au (Teradata)
4. Carrie Ballinger (Teradata)

BibTeX Citation

@article{alkateb_vldb16,
        title = {{Hybrid Row-Column Partitioning in Teradata}},
        author = {Al-Kateb, Mohammed and Sinclair, Paul and Au, Grace and Ballinger, Carrie},
        journal = {PVLDB},
        series = {{VLDB} '16},
        volume = {9},
        number = {13},
        pages = {1353--1364},
        doi = {10.14778/3007263.3007275},
        url = {https://doi.org/10.14778/3007263.3007275},
        year = {2016}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
9,922	Unified Data Analytics: State-of-the-art and Open Problems	2022	VLDB	5.1103839e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 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
61	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.000392237
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
243	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.00023358891
472	Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems	2012	SIGMOD	0.00017692264
797	Low Overhead Concurrency Control for Partitioned Main Memory Databases	2010	SIGMOD	0.00013922631
1,327	Column-oriented Database Systems	2009	VLDB	0.00011003776
2,155	Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries	2008	VLDB	8.9456729e-05
3,143	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD	7.5981026e-05
3,239	Locality-aware Partitioning in Parallel Database Systems	2015	SIGMOD	7.5007569e-05
3,643	Operating System Extensions for the Teradata Parallel VLDB	2001	VLDB	7.1402215e-05
7,200	Optimizing Queries over Partitioned Tables in MPP Systems	2014	SIGMOD	5.5872813e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,143	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD
2	3,549	Read-Optimized Databases, In Depth	2008	VLDB
3	2,882	Optimal Column Layout for Hybrid Workloads	2019	VLDB
4	2,811	Horizontal Data Partitioning In Database Design	1982	SIGMOD
5	6,213	Data Partitioning for In-Memory Systems: Myths, Challenges, and Opportunities	2019	CIDR
6	195	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD
7	3,081	Skipping-oriented Partitioning for Columnar Layouts	2017	VLDB
8	8,605	A Storage Advisor for Hybrid-Store Databases	2012	VLDB
9	1,200	Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads	2016	SIGMOD
10	331	Column-Stores vs. Row-Stores: How Different Are They Really?	2008	SIGMOD