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: 9119
Venue: VLDB
Year: 2004
Pagerank: 0.00013320373
Overall Rank: 1,203 | 91.64%
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,216	Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques	2008	SIGMOD	0.00013232841
1,427	Towards Scalable Dataframe Systems	2020	VLDB	0.0001204248
2,832	Intensional Associations Between Data and Metadata	2007	SIGMOD	8.050082e-05
4,053	Query By Excel	2005	VLDB	6.4929934e-05
5,012	SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL	2024	VLDB	5.7599595e-05
7,477	Benchmarking Spreadsheet Systems	2020	SIGMOD	4.7188671e-05
7,786	Relational Support for Flexible Schema Scenarios	2008	VLDB	4.6513838e-05
8,606	Extending Relational Query Optimization to Dynamic Schemas for Information Integration in Multidatabases	2007	SIGMOD	4.4860094e-05
8,645	Predicate Pushdown for Data Science Pipelines	2023	SIGMOD	4.4772518e-05
9,850	COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics	2021	VLDB	4.2721228e-05
12,118	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD	4.1945683e-05
12,549	Bridging the Gap between OLAP and SQL	2005	VLDB	4.1945683e-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
639	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018791492
864	Storage and Querying of E-Commerce Data	2001	VLDB	0.00015813082
1,549	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	0.00011428835
2,216	On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS	1998	SIGMOD	9.2699038e-05
3,096	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB	7.5678495e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
454	An Overview of Query Optimization in Relational Systems	1998	PODS	0.00022734812
7,098	Optimizing Queries over Partitioned Tables in MPP Systems	2014	SIGMOD	4.833012e-05
12,118	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD	4.1945683e-05
9,957	How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches	2025	VLDB	4.2373024e-05
3,764	Read-Optimized Databases, In Depth	2008	VLDB	6.7797554e-05
3,096	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB	7.5678495e-05
2,241	Query Optimization in Microsoft SQL Server PDW	2012	SIGMOD	9.2191212e-05
1,582	Execution Strategies for SQL Subqueries	2007	SIGMOD	0.00011265079
731	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017468889
3,214	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD	7.3661891e-05