Sequence Compression in In-Memory Database yields 99% memory savings and a total of 13%
One of the most interesting compression techniques on columnar storages is sequence compression. (mehr …)
Bitcoin – The Harder Drive
In this blogpost, I want to show you a video that in a very humorous way explains the stupidity behind bitcoin: (mehr …)
Walnut AI – a CPU-optimized AI neuronal network
Our brain is shaped like a walnut. And that's for a reason. (mehr …)
Accessing MemCP via scheme
MemCPs native access technology is the scheme scripting language. (mehr …)
Writing a SQL parser in scheme
Functional programming languages are a neat tool to write parsers, especially when equipped with a pattern matching mechanism. (mehr …)
How to benchmark a SQL database
To compare databases against each other, a benchmark like TPC-H is used. (mehr …)
When the benchmark is too slow… (golang http server performance)
Just a shmankerl from the daily life of a developer. (mehr …)
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. (mehr …)
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. (mehr …)
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 the two. By the end of this article, you will have a better understanding…
