Oracle



[1] W. Kim, On Optimizing an SQL-Like Nested Query, ACM TODS, September 1982.

[2] U. Dayal, Of Nests and Trees: A Unified Approach to Processing Queries that Contain Nested Subqueries, Aggregates, and Quantifiers, Proceedings of the 13th VLDB Conference, Brighton, U.K., 1987.

[3] M. Muralikrishna, Improved Unnesting Algorithms for Join Aggregate SQL Queries, Proceedings of the 18th

VLDB Conference, Vancouver, Canada, 1992.

[4] H. Pirahesh, J.M. Hellerstein, and W. Hasan, Extensible Rule Based Query Rewrite Optimizations in Starburst, Proc. of ACM SIGMOD, San Diego, USA, 1992.

[5] S. Chaudhuri and K. Shim, Including Group-By in Query Optimization, Proceedings of the 20th VLDB Conference, Santiago, Chile, 1994.

[6] W.P.Yan and A.P.Larson, Eager Aggregation and Lazy Aggregation, Proceedings of the 21th VLDB Conference, Zurich, Switzerland, 1995.

[7] A. Witkowski, et al, Spreadsheets in RDBMS for OLAP, Proc. of ACM SIGMOD, San Diego, USA, 2003.

[8] R. Ahmed, et al, Cost-Based Query Transformation in Oracle, Proceedings of the 32th VLDB Conference, Seoul, S. Korea, 2006.

[9] M. Elhemali, C. Galindo-Legaria, et al, Execution Strategies for SQL Subqueries, Proc. of ACM SIGMOD, Beijing, China, 2007.

[10] A. Eisenberg, K. Kulkarni, et al, SQL: 2003 Has Been Published, SIGMOD Record, March 2004.

[11] F. Zemke, Rank, Moving and reporting functions for OLAP, 99/01/22 proposal for ANSI-NCITS.

[12] C. Zuzarte, et al, Method for Aggregation Subquery Join Elimination,

[13] C. Zuzarte, H. Pirahesh, et al, WinMagic: Subquery Elimination Using Window Aggregation, Proc. of ACM SIGMOD, San Diego, USA, 2003.

[14] TPC Benchmark H (Decision Support), Standart Specification Rev 2.8,

[15] TPC-DS Specification Draft , Rev 32, http://tpc.org/tpcds/spec/tpcds32.pdf

, , .




- -  - -  - -