Adaptive and big data scale parallel execution in oracle

Proceedings of the VLDB Endowment

Volumn 6, Issue 11, 2013, Pages 1102-1113

  Liang, Vince ^a   Bellamkonda, Srikanth ^a   Li, Hua Gang ^a   Jagtap, Unmesh ^a   Zhu, Yali ^a   Cruanes, Thierry ^a  

^a ORACLE CORPORATION   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ADVANCED ANALYTICS; DATA ANALYTICS; QUERY PROCESSING; RELATIONAL DATABASE SYSTEMS;

ADAPTIVE EVALUATION; DATA DISTRIBUTION; MASSIVELY PARALLELS; PARALLEL EXECUTIONS; PARALLELIZATION TECHNIQUES; PARALLELIZATIONS; QUERY EXECUTION TIME; WINDOW FUNCTIONS;

BIG DATA;

EID: 84891067027     PISSN: None     EISSN: 21508097     Source Type: Journal    
DOI: 10.14778/2536222.2536235     Document Type: Article

References (15)

1. R. Ahmed, et al, "Cost-Based Query Transformation in Oracle", Proceedings of the 32nd VLDB Conference, Seoul, S. Korea, 2006.
2. S. Bellamkonda, et al, "Enhanced Subquery Optimizations in Oracle", Proceedings of the 35th VLDB Conference, Lyon, France, 2009.
3. A. Eisenberg, K. Kulkarni, et al, "SQL: 2003 Has Been Published", SIGMOD Record, March 2004.
4. SQL - Part2: Foundation, ISO/IEC 9075:1999
5. TPC-H (Decision Support), Standard Specification Rev 2.8, TPC-DS Specification Draft, Rev 32, http://www.tpc.org/
6. OLAP Council, APB-1 OLAP Benchmark, Release II, http://olapcouncil.org/research/APB1R2_spec.pdf
7. S. Agarwal, et al, "On the Computation of Multidimensional Aggregates", Proceedings of the 22nd VLDB Conference, Mumbai (Bombay), India, 1996.
8. Map Join Optimization, Apache Hive, https://cwiki.apache.org/Hive/joinoptimization.html
9. C. Zuzarte, et al, "WinMagic: Subquery Elimination Using Window Aggregation", Proceedings of the 2003 ACM SIGMOD Conference, San Diego, USA.
10. Y. Cao, et al, "Optimization of Analytic Window Functions", Proceedings of the 38th VLDB Conference, Istanbul, 2012.
11. Y. Xu, et al, "Handling Data Skew in Parallel Joins in Shared-Nothing", Proceedings of the 2008 ACM SIGMOD Conference, Vancouver, BC, Canada.
12. C. Kim, et al, "Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs", Proceedings of the 35th VLDB Conference, Lyon, France, 2009.
13. Y. Ye, et al, "Scalable Aggregation on Multicore Processors", Proceedings of the 7th International Workshop on Data Management on New Hardware, Athens, 2011.
14. J. Gray, et al, "Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab and Sub-Totals", Data Mining and Knowledge Discovery, 1997.
15. V. Harinarayan, et al, "Implementing Data Cubes Efficiently", Proceedings of the 1996 ACM SIGMOD Conference, New York, USA.