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: 9120
Venue: VLDB
Year: 2004
Pagerank: 0.00013309393
Overall Rank: 1,205 | 91.63%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,215	Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques	2008	SIGMOD	0.00013242358
1,427	Towards Scalable Dataframe Systems	2020	VLDB	0.00012033503
2,839	Intensional Associations Between Data and Metadata	2007	SIGMOD	8.0423129e-05
4,059	Query By Excel	2005	VLDB	6.4867352e-05
5,011	SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL	2024	VLDB	5.7544221e-05
7,476	Benchmarking Spreadsheet Systems	2020	SIGMOD	4.7143411e-05
7,786	Relational Support for Flexible Schema Scenarios	2008	VLDB	4.6469243e-05
8,604	Extending Relational Query Optimization to Dynamic Schemas for Information Integration in Multidatabases	2007	SIGMOD	4.4817085e-05
8,625	Predicate Pushdown for Data Science Pipelines	2023	SIGMOD	4.4784651e-05
9,850	COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics	2021	VLDB	4.2680295e-05
12,126	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD	4.1905499e-05
12,558	Bridging the Gap between OLAP and SQL	2005	VLDB	4.1905499e-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
640	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018780632
860	Storage and Querying of E-Commerce Data	2001	VLDB	0.00015804018
1,547	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	0.00011417795
2,220	On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS	1998	SIGMOD	9.2614686e-05
3,101	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB	7.5611936e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
786	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.00016624743
454	An Overview of Query Optimization in Relational Systems	1998	PODS	0.00022796106
12,126	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD	4.1905499e-05
3,761	Read-Optimized Databases, In Depth	2008	VLDB	6.7777865e-05
9,956	How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches	2025	VLDB	4.2332427e-05
3,101	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB	7.5611936e-05
2,244	Query Optimization in Microsoft SQL Server PDW	2012	SIGMOD	9.2095696e-05
1,581	Execution Strategies for SQL Subqueries	2007	SIGMOD	0.00011262795
728	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017459654
3,219	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD	7.3592303e-05