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


Technology White Paper - Parallel Network Query to Speed up Slow Server

   Parallel Network Query may 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).



   All tables of the query may be replicated at the auxiliary servers 

       	      	 OR

   Tables may be grouped according to the table join order of query and moved or
   replicated at auxiliary servers and the remaining tables are created as
   Federated tables.



                              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.