How to benchmark a SQL database
To compare databases against each other, a benchmark like TPC-H is used.
Read MoreWhen the benchmark is too slow… (golang http server performance)
Just a shmankerl from the daily life of a developer.
Read MoreOn 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.
Read Morememcp: 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.
Read MoreMemory-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.
Read MoreHow 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.
Read MoreHow 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
Read MoreDesigning 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.
Read MoreOn 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
Read MoreWas ist ein Headless Online Shop?
Was ist die Zukunft der Digitalisierung? Und welche Rolle spielen Headless Online Shops dabei?
Read More