MorphStore: Analytical Query Engine with a Holistic Compression-Enabled Processing Model

04/20/2020
by   Patrick Damme, et al.
0

In this paper, we present MorphStore, an open-source in-memory columnar analytical query engine with a novel holistic compression-enabled processing model. Basically, compression using lightweight integer compression algorithms already plays an important role in existing in-memory column-store database systems, but mainly for base data. In particular, during query processing, these systems only keep the data compressed until an operator cannot process the compressed data directly, whereupon the data is decompressed, but not recompressed. Thus, the full potential of compression during query processing is not exploited. To overcome that, we developed a novel compression-enabled processing model as presented in this paper. As we are going to show, the continuous usage of compression for all base data and all intermediates is very beneficial to reduce the overall memory footprint as well as to improve the query performance.

READ FULL TEXT
research
09/06/2022

An Adaptive Column Compression Family for Self-Driving Databases

Modern in-memory databases are typically used for high-performance workl...
research
05/19/2021

Revisiting Data Compression in Column-Stores

Data compression is widely used in contemporary column-oriented DBMSes t...
research
09/16/2021

SEACOW: Synopsis Embedded Array Compression using Wavelet Transform

Recently, multidimensional data is produced in various domains; because ...
research
09/07/2020

Conquery: an open source application to analyze high content healthcare data

Background: Big data in healthcare must be exploited to achieve a substa...
research
08/16/2023

Finding a Second Wind: Speeding Up Graph Traversal Queries in RDBMSs Using Column-Oriented Processing

Recursive queries and recursive derived tables constitute an important p...
research
04/17/2023

Hybrid Materialization in a Disk-Based Column-Store

In column-oriented query processing, a materialization strategy determin...
research
04/04/2021

EKO: Adaptive Sampling of Compressed Video Data

Researchers have presented systems for efficiently analysing video data ...

Please sign up or login with your details

Forgot password? Click here to reset