Query evaluation techniques for large databases
ACM Computing Surveys (CSUR)
IBM Systems Journal
Orthogonal optimization of subqueries and aggregation
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Volcano— An Extensible and Parallel Query Evaluation System
IEEE Transactions on Knowledge and Data Engineering
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
Oracle Parallel Warehouse Server
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
TOPAZ: a Cost-Based, Rule-Driven, Multi-Phase Parallelizer
VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Spreadsheets in RDBMS for OLAP
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
SQL memory management in Oracle9i
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Journal of Systems and Software
Adaptive hybrid partitioning for OLAP query processing in a database cluster
International Journal of High Performance Computing and Networking
Distributed data-parallel computing using a high-level programming language
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Validating the Oracle SQL engine
Proceedings of the Second International Workshop on Testing Database Systems
A Query Cache Tool for Optimizing Repeatable and Parallel OLAP Queries
DEXA '09 Proceedings of the 20th International Conference on Database and Expert Systems Applications
Distributed aggregation for data-parallel computing: interfaces and implementations
Proceedings of the ACM SIGOPS 22nd symposium on Operating systems principles
Parallel OLAP with the Sidera server
Future Generation Computer Systems
Sidera: a cluster-based server for online analytical processing
OTM'07 Proceedings of the 2007 OTM confederated international conference on On the move to meaningful internet systems: CoopIS, DOA, ODBASE, GADA, and IS - Volume Part II
OSDI'08 Proceedings of the 8th USENIX conference on Operating systems design and implementation
Apuama: combining intra-query and inter-query parallelism in a database cluster
EDBT'06 Proceedings of the 2006 international conference on Current Trends in Database Technology
| Hi-index | 0.01 |
This paper describes the new architecture and optimizations for parallel SQL execution in the Oracle 10g database. Based on the fundamental shared-disk architecture underpinning Oracle's parallel SQL execution engine since Oracle7, we show in this paper how Oracle's engine responds to the challenges of performing in new grid-computing environments. This is made possible by using advanced optimization techniques, which enable Oracle to exploit data and system architecture dynamically without being constrained by them. We show how we have evolved and re-architected our engine in Oracle 10g to make it more efficient and manageable by using a single global parallel plan model.