An architecture for recycling intermediates in a column-store

@article{Ivanova2009AnAF,
  title={An architecture for recycling intermediates in a column-store},
  author={Milena Ivanova and Martin L. Kersten and Niels Nes and Romulo Goncalves},
  journal={ACM Trans. Database Syst.},
  year={2009},
  volume={35},
  pages={24:1-24:43}
}
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… CONTINUE READING