Basic HTML version of Foils prepared 7 October 97

Foil 34 Three Processing Phases in Parallel Query

From Second Part of RDBMS Discussion ARL Database Tutorial -- February 98. by Gang Cheng Marek Podgorny Chao-Wei Ou


1 Parse --- a query optimizer determines optimal execution plan, parallelize query if a full scan was included in the execution plan (note the query is parallelized dynamically at execution time, automatically adapting changes in data partition and server configuration)
2 Execute --- perform operations
3 Fetch (Queries) --- return rows from query server processes
The execution and fetch phases can be performed in parallel ( pipelined parallelism) by multiple server processes



© on Mon Oct 13 1997