A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2006; you can also visit the original URL.
The file type is application/pdf.
PIVOT and UNPIVOTOptimization and Execution Strategies in an RDBMS
[chapter]
2004
Proceedings 2004 VLDB Conference
Preserved Fulltext
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
doi:10.1016/b978-012088469-8/50087-5
fatcat:eyyabip5ijfjld5eb6jxm4bg2m