An architecture for recycling intermediates in a column-store

Milena G. Ivanova, Martin Kersten, Niels Nes, Romulo Gonçalves

2009 · 76 citations · 22 references

DOIFull text

Open access

Concepts

Abstract

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.

References

22