PIVOT and UNPIVOTOptimization and Execution Strategies in an RDBMS [chapter]

C CUNNINGHAM, C GALINDOLEGARIA, G GRAEFE
2004 Proceedings 2004 VLDB Conference  
PIVOT and UNPIVOT, two operators on tabular data that exchange rows and columns, enable data transformations useful in data modeling, data analysis, and data presentation. They can quite easily be implemented inside a query processor, much like select, project, and join. Such a design provides opportunities for better performance, both during query optimization and query execution. We discuss query optimization and execution implications of this integrated design and evaluate the performance of
more » ... this approach using a prototype implementation in Microsoft SQL Server.
doi:10.1016/b978-012088469-8/50087-5 fatcat:eyyabip5ijfjld5eb6jxm4bg2m