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: 11433
Venue: VLDB
Year: 2016
Pagerank: 5.3114559e-05
Overall Rank: 9,159 | 37.17%
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,742	Unified Data Analytics: State-of-the-art and Open Problems	2022	VLDB	5.227679e-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.00069513174
60	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.0003955489
186	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.00026182534
199	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00025612088
246	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.00023457421
471	Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems	2012	SIGMOD	0.0001793564
773	Low Overhead Concurrency Control for Partitioned Main Memory Databases	2010	SIGMOD	0.00014131021
1,395	Column-oriented Database Systems	2009	VLDB	0.00010928358
2,150	Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries	2008	VLDB	9.081101e-05
3,199	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD	7.6423984e-05
3,200	Locality-aware Partitioning in Parallel Database Systems	2015	SIGMOD	7.642132e-05
3,606	Operating System Extensions for the Teradata Parallel VLDB	2001	VLDB	7.2634066e-05
7,090	Optimizing Queries over Partitioned Tables in MPP Systems	2014	SIGMOD	5.706401e-05

Semantically Similar Papers

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