Shared scans on main memory column stores


Loading...

Date

2012-07

Publication Type

Report

ETH Bibliography

yes

Citations

Altmetric

Data

Abstract

Column stores and shared scans have been found to be effective techniques in order to improve performance for many workloads. Another recent hardware trend makes it possible to keep most data in main memory. This paper builds upon these trends and explores how to implement shared scans on column stores in main memory efficiently. In particular, this paper proposes new approaches to avoid unnecessary work and to best implement position lists in such a query processing archi tecture. Performance experiments with real workloads from the travel industry show the advantages of combining column stores and shared scans in main memory over traditional database architectures.

Publication status

published

External links

Editor

Book title

Volume

769

Pages / Article No.

Publisher

ETH Zurich, Department of Computer Science

Event

Edition / version

Methods

Software

Geographic location

Date collected

Date created

Subject

Organisational unit

03689 - Kossmann, Donald (ehemalig) check_circle
03506 - Alonso, Gustavo / Alonso, Gustavo check_circle
02150 - Dep. Informatik / Dep. of Computer Science

Notes

Funding

Related publications and datasets