Inter-query parallelism is a form of parallelism in the evaluation of database queries, in which several different queries execute concurrently on multiple processors to improve the overall throughput of the system.
When multiple non-conflicting requests are submitted to a database management system, then the system can execute them in parallel to improve the overall throughput . This form of parallelism is called inter-query parallelism. Inter-query parallelism is a consequence of the concurrency of user requests. It is orthogonal to intra-query parallelism, in which several processors cooperate for the faster execution of a single query . Both forms of parallelism can co-exist in a database management system. Inter-query parallelism is common in on-line transaction processing (OLTP), where multiple concurrent users submit requests to the system. It is a challenge for the database management system to achieve high performance and maintain the ACID properties in the presence of multiple concurrently executing requests or transactions.
- 2.Graefe G. Encapsulation of parallelism in the volcano query processing system. In: Proceedings of the ACM SIGMOD international conference on management of data; 1990, p. 102–11.Google Scholar