Interquery vs Intraquery Parallelism

Interquery vs Intraquery Parallelism

1. Interquery Parallelism

   • Side by side execution
     • Queries
     • Transactions
   • Supports multiple transactions
   • Implementation
     • Simple
       • Shared-memory
     • Complicated
       • Shared-disk
       • Shared-nothing

2. Intraquery Parallelism

   • Definition
     • One query
     • Different processors or disks
   • Reduces execution time
     • Long queries
   • Forms of parallelization
     • Interoperation parallelism
       • One operation
     • Intraoperation parallelism
       • Multiple operations
     • Combination of both