PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS

Summary: PIVOT and UNPIVOT are row/column exchange operators integrated into the RDBMS query processor to support cross-tab transformations. By co-optimizing and co-executing them with existing operators, the approach yields performance benefits, demonstrated via a SQL Server prototype. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9310
Venue: VLDB
Year: 2004
Pagerank: 9.9999141e-05
Overall Rank: 1,691 | 88.40%
DOI: 10.1016/B978-012088469-8.50087-5

Incoming Non-self Citations Over Time

Authors

1. Conor Cunningham (Microsoft)
2. César A. Galindo-Legaria (Microsoft)
3. Goetz Graefe (Microsoft)

BibTeX Citation

@article{cunningham_vldb04,
        title = {{PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS}},
        author = {Cunningham, Conor and Galindo-Legaria, César A. and Graefe, Goetz},
        journal = {PVLDB},
        series = {{VLDB} '04},
        pages = {998--1009},
        doi = {10.1016/B978-012088469-8.50087-5},
        url = {https://doi.org/10.1016/B978-012088469-8.50087-5},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,431	Towards Scalable Dataframe Systems	2020	VLDB	0.00010807221
1,477	Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques	2008	SIGMOD	0.00010654969
4,095	Intensional Associations Between Data and Metadata	2007	SIGMOD	6.9065838e-05
4,367	SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL	2024	VLDB	6.7395125e-05
4,477	Query By Excel	2005	VLDB	6.6793744e-05
7,389	Benchmarking Spreadsheet Systems	2020	SIGMOD	5.6266966e-05
8,109	Relational Support for Flexible Schema Scenarios	2008	VLDB	5.4843869e-05
8,465	Predicate Pushdown for Data Science Pipelines	2023	SIGMOD	5.4194578e-05
8,630	Extending Relational Query Optimization to Dynamic Schemas for Information Integration in Multidatabases	2007	SIGMOD	5.3967753e-05
10,002	COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics	2021	VLDB	5.1814573e-05
12,315	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD	5.093636e-05
12,742	Bridging the Gap between OLAP and SQL	2005	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
543	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.0001682612
1,038	Storage and Querying of E-Commerce Data	2001	VLDB	0.00012476189
1,687	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	0.00010005718
3,036	On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS	1998	SIGMOD	7.8287552e-05
3,889	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB	7.0440224e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,090	Optimizing Queries over Partitioned Tables in MPP Systems	2014	SIGMOD
2	664	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD
3	12,315	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD
4	10,106	How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches	2025	VLDB
5	3,489	Read-Optimized Databases, In Depth	2008	VLDB
6	3,889	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB
7	2,078	Query Optimization in Microsoft SQL Server PDW	2012	SIGMOD
8	1,362	Execution Strategies for SQL Subqueries	2007	SIGMOD
9	559	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
10	3,199	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD