Exploiting pipeline interruptions for efficient memory allocation
Josep Aguilar-Saborit, Mohammad Reza Jalali, Dave Sharpe, Víctor Muntés-Mulero · 2008
Efficiency of memory-intensive operations is a key factor in obtaining good performance during multi-join query processing. The pipelined execution of these queries forces the operations in the query plan to be processed concurrently. Making a wrong decision regarding the amount of memory allocated for such operations can have a drastic impact on the response time. However, some of the execution algorithms used at run time interrupt the pipelined execution, ensuring that some operations are never executed concurrently. Because of this, it is essential to explore new approaches in order to improve memory exploitation.