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: h7e28c4adcf87ab16
Venue: VLDB
Year: 2004
Pagerank: 9.8499097e-05
Overall Rank: 1,697 | 88.60%
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,370	Towards Scalable Dataframe Systems	2020	VLDB	0.00010895207
1,499	Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques	2008	SIGMOD	0.00010467167
3,148	SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL	2024	VLDB	7.5916864e-05
4,183	Intensional Associations Between Data and Metadata	2007	SIGMOD	6.7518322e-05
4,556	Query By Excel	2005	VLDB	6.5355246e-05
7,522	Benchmarking Spreadsheet Systems	2020	SIGMOD	5.5020393e-05
8,159	Predicate Pushdown for Data Science Pipelines	2023	SIGMOD	5.3866275e-05
8,295	Relational Support for Flexible Schema Scenarios	2008	VLDB	5.3589408e-05
8,799	Extending Relational Query Optimization to Dynamic Schemas for Information Integration in Multidatabases	2007	SIGMOD	5.2739832e-05
10,192	COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics	2021	VLDB	5.0628015e-05
12,612	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD	4.9769913e-05
13,038	Bridging the Gap between OLAP and SQL	2005	VLDB	4.9769913e-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
552	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00016530708
1,056	Storage and Querying of E-Commerce Data	2001	VLDB	0.00012243086
1,715	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	9.8056478e-05
3,088	On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS	1998	SIGMOD	7.6593918e-05
3,961	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB	6.8926339e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	272	An Overview of Query Optimization in Relational Systems	1998	PODS
2	7,202	Optimizing Queries over Partitioned Tables in MPP Systems	2014	SIGMOD
3	12,612	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD
4	10,144	How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches	2025	VLDB
5	3,548	Read-Optimized Databases, In Depth	2008	VLDB
6	3,961	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB
7	2,089	Query Optimization in Microsoft SQL Server PDW	2012	SIGMOD
8	1,378	Execution Strategies for SQL Subqueries	2007	SIGMOD
9	553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
10	3,145	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD