The Database Doctor
Musing about Databases

Tag: column

Cover image for TPC series - TPC-H Query 6 - Expression Optimisation
TPC series - TPC-H Query 6 - Expression Optimisation

Reading Time: 5 min, Date: 10/13/2025

And now, for something completely different. This week on TPC-H query analysis - we are not going to look at join ordering. Today's query does not have any joins. But as we shall see, is to...

Cover image for Introducing the TPC series - TPC-H Query 1: Column Storage and Local Aggregation
Introducing the TPC series - TPC-H Query 1: Column Storage and Local Aggregation

Reading Time: 9 min, Date: 7/14/2025

After the wonderful feedback on the previous blog about Iceberg - it is now time to switch gears. Databases are more than row storage engines. They are algorithm machines, helping that...

Cover image for Row or Column based Storage?
Row or Column based Storage?

Reading Time: 4 min, Date: 4/7/2023

These days, columnar storage formats are getting a lot more attention in relational databases. Parquet, with its superior compression, is quickly taking over from CSV formats. SAP a...