MemCP – Page 2

How to benchmark a SQL database

To compare databases against each other, a benchmark like TPC-H is used.

When the benchmark is too slow… (golang http server performance)

Just a shmankerl from the daily life of a developer.

On Compressing NULL values in bit-compressed Integer Storages

Usually, databases store NULL values in form of bitmasks. In this case, each value eats up 1 bit for the possibility to become NULL. I will prove that we can do better.

memcp: Eine OpenSource hochperformante Spaltenbasierte In-Memory-Datenbank als Alternative zu proprietären analytischen Datenbanken

In den letzten 13 Jahren gab es eine Menge Innovationen im Bereich spaltenbasierte Datenbanken. Zu verdanken ist das vor allem einem deutschen ERP-Hersteller, der sich entschieden hat, sich vom Datenbank-Marktführer abzusetzen und sein eigenes Ding zu machen. Es wurde zu einer Erfolgsstory. Zeit, dass OpenSource nachzieht.

Memory-Efficient Indices for In-Memory Storages

Most databases implement indices as a kind of tree. I will show you that columnar storages can do even better.

How In-Memory Compression Affects Performance

Modern computers are fast. So fast that there is a huge gap between computing speed and memory bandwith and latency in memory-heavvy applications.

How to balance a database between OLAP and OLTP workflows

In this blog article, we will be comparing OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) databases. We will discuss their differences and similarities, discuss the ideal database architecture for a database that can handle both OLAP and OLTP workloads, and provide a synthesis of

Designing a programming language for distributed systems and highly parallel algorithms

Almost 99% of all newly invented are imperative programming languages. But imperative languages have one drawback: their parallelization is hard.

On designing an interface for columnar in-memory storage in golang

The advantages for columnar storages over row based storages are the ability for good in-memory compression (low memory usage) and cache locality when accessing only few columns (performance). Designing an Interface When designing an interface for a storage engine for an in-memory database, a lot of

Category: MemCP