An architecture for recycling intermediates in a column-store
Milena Ivanova, Martin L. Kersten, Niels J. Nes, Romulo A.P. Gonçalves · 2009
Automatically recycling (intermediate) results is a grand challenge for state-of-the-art databases to improve both query response time and throughput. Tuples are loaded and streamed through a tuple-at-a-time processing pipeline avoiding materialization of intermediates as much as possible. This limits the opportunities for reuse of overlapping computations to DBA-defined materialized views and function/result cache tuning.