loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Nusrat Jahan Lisa 1 ; Annett Ungethüm 1 ; Dirk Habich 1 ; Nguyen Duy Anh Tuan 2 ; Akash Kumar 2 and Wolfgang Lehner 1

Affiliations: 1 Database Systems Group, Technische Universität Dresden, Dresden and Germany ; 2 Processor Design Group, Technische Universität Dresden, Dresden and Germany

Keyword(s): Column Stores, Scan Operation, Vectorization, FPGA, Pipeline.

Related Ontology Subjects/Areas/Topics: Data Engineering ; Database Architecture and Performance ; Databases and Data Security ; Query Processing and Optimization

Abstract: The key objective of database systems is to reliably manage data, whereby high query throughput and low query latency are core requirements. To satisfy these requirements for analytical query workloads, in-memory column store database systems are state-of-the-art. In these systems, relational tables are organized by column rather than by row, so that a full column scan is a fundamental key operation and thus, the optimization of the key operation is very crucial. For this reason, we investigated the optimization of a well-known scan technique using SIMD (Single Instruction Multiple Data) vectorization as well as using Field Programmable Gate Arrays (FPGA). In this paper, we present both optimization approaches with the goal to increase the intra-instruction execution parallelism to process more columns values in a single instruction simultaneously. For both, we present selective results of our exhaustive evaluation. Based on this evaluation, we draw some lessons learned for our ongoi ng research activities. (More)

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 44.203.219.117

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Lisa, N.; Ungethüm, A.; Habich, D.; Tuan, N.; Kumar, A. and Lehner, W. (2018). Column Scan Optimization by Increasing Intra-Instruction Parallelism. In Proceedings of the 7th International Conference on Data Science, Technology and Applications - DATA; ISBN 978-989-758-318-6; ISSN 2184-285X, SciTePress, pages 344-353. DOI: 10.5220/0006897003440353

@conference{data18,
author={Nusrat Jahan Lisa. and Annett Ungethüm. and Dirk Habich. and Nguyen Duy Anh Tuan. and Akash Kumar. and Wolfgang Lehner.},
title={Column Scan Optimization by Increasing Intra-Instruction Parallelism},
booktitle={Proceedings of the 7th International Conference on Data Science, Technology and Applications - DATA},
year={2018},
pages={344-353},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006897003440353},
isbn={978-989-758-318-6},
issn={2184-285X},
}

TY - CONF

JO - Proceedings of the 7th International Conference on Data Science, Technology and Applications - DATA
TI - Column Scan Optimization by Increasing Intra-Instruction Parallelism
SN - 978-989-758-318-6
IS - 2184-285X
AU - Lisa, N.
AU - Ungethüm, A.
AU - Habich, D.
AU - Tuan, N.
AU - Kumar, A.
AU - Lehner, W.
PY - 2018
SP - 344
EP - 353
DO - 10.5220/0006897003440353
PB - SciTePress