Query processing on heterogeneous CPU/GPU systems
Due to their high computational power and internal memory bandwidth, graphic processing
units (GPUs) have been extensively studied by the database systems research community …
units (GPUs) have been extensively studied by the database systems research community …
[PDF][PDF] Umbra: A Disk-Based System with In-Memory Performance.
The increases in main-memory sizes over the last decade have made pure in-memory
database systems feasible, and in-memory systems offer unprecedented performance …
database systems feasible, and in-memory systems offer unprecedented performance …
Duckdb: an embeddable analytical database
M Raasveldt, H Mühleisen - … of the 2019 International Conference on …, 2019 - dl.acm.org
The immense popularity of SQLite shows that there is a need for unobtrusive in-process data
management solutions. However, there is no such system yet geared towards analytical …
management solutions. However, there is no such system yet geared towards analytical …
Photon: A fast query engine for lakehouse systems
Many organizations are shifting to a data management paradigm called the" Lakehouse,"
which implements the functionality of structured data warehouses on top of unstructured …
which implements the functionality of structured data warehouses on top of unstructured …
Query optimization through the looking glass, and what we found running the join order benchmark
Finding a good join order is crucial for query performance. In this paper, we introduce the
Join Order Benchmark that works on real-life data riddled with correlations and introduces …
Join Order Benchmark that works on real-life data riddled with correlations and introduces …
Relaxed operator fusion for in-memory databases: Making compilation, vectorization, and prefetching work together at last
In-memory database management systems (DBMSs) are a key component of modern on-
line analytic processing (OLAP) applications, since they provide low-latency access to large …
line analytic processing (OLAP) applications, since they provide low-latency access to large …
Everything you always wanted to know about compiled and vectorized queries but were afraid to ask
The query engines of most modern database systems are either based on vectorization or
data-centric code generation. These two state-of-the-art query processing paradigms are …
data-centric code generation. These two state-of-the-art query processing paradigms are …
To partition, or not to partition, that is the join question in a real system
An efficient implementation of a hash join has been a highly researched problem for
decades. Recently, the radix join has been shown to have superior performance over the …
decades. Recently, the radix join has been shown to have superior performance over the …
Main memory database systems
F Faerber, A Kemper, PÅ Larson… - … and Trends® in …, 2017 - nowpublishers.com
This article provides an overview of recent developments in mainmemory database systems.
With growing memory sizes and memory prices drop** by a factor of 10 every 5 years …
With growing memory sizes and memory prices drop** by a factor of 10 every 5 years …
BtrBlocks: efficient columnar compression for data lakes
Analytics is moving to the cloud and data is moving into data lakes. These reside on object
storage services like S3 and enable seamless data sharing and system interoperability. To …
storage services like S3 and enable seamless data sharing and system interoperability. To …