P  A  R  A  L  L  E  L     U  N  I  V  E  R  S  E


1. Parallel Network Query (Distributed Query) ver 5.5-3.1 only


   Parallel Network Query joins local tables of the server with remote tables of
   other servers in the network where remote table processing is delegated to
   the host servers. (remote tables represented as Federated tables).

   Under Parallel Network Query, servers are numbered according to the table
   join order of query (forming server pipeline) and each server processes its
   own tables.  Query result is built by concatenating processed tables of each
   server along the server pipeline achieving unprecedented speed.





                              Server Diagram


  ---------             ---------                               ---------      
 |         |           |         |                             |         |     
 | Storage |           | Storage |                             | Storage |     
 |         |           |         |                             |         |     
  ---------             ---------                               ---------      
      |                     |                                       |          
      | 1st group           | 2nd group                             | Last group
      | of tables           | of tables                             | of tables
      v                     v                                       v          
  ---------             ---------                               ---------      
 |Auxiliary|           |Auxiliary|                             |  Base   |     
 | Server  | --------> | Server  | -------->   .  .  .   ----> | Server  |     
 |    1    |  Partial  |    2    |  Partial                    |         |     
  ---------   Query     ---------   Query                       ---------      
      ^       Result        ^       Result                       |  ^  |       
      |                     |                                    |  |  | Full  
      |                     |                                    |  |  | Query 
       -------------------------------------             --------   |  | Result
                        Same Query                                  |  |       
                                                                    |  v
                                                                    |   
                                                                  Query


   1. Base server receives a query.
   2. Base server reissues the same query to auxiliary servers.
   3. Each auxiliary server reads its own group of tables, processes and
      appends them to partial query result.
   4. Base server reads the last group of tables, processes and appends them to
      partial query result to generate the full query result.

See Technology and Benchmarks page.



2. Parallel Network Query to Speed up Slow Server

   Parallel Network Query may also be used to speed up slow server by
   distributing tables of the query to multiple servers for processing which
   effectively aggregates server resources (such as disk I/O bandwidth and
   CPU/cores).

See Technology and Benchmarks page.