Databases Articles

Build a purpose-built time-series database — covering LSM storage, time-based partitioning, downsampling, retention policies, and compression for metrics.

Combine the best of data lakes and data warehouses — covering Delta Lake, Apache Iceberg, ACID on object storage, and unified analytics.

Understand how columnar storage works — row vs column layout, run-length encoding, dictionary encoding, predicate pushdown, and vectorized execution.

Understand log-structured file systems — append-only writes, garbage collection, segment cleaning, crash recovery, and their influence on modern databases.

Build a knowledge graph to represent entities and relationships — covering graph modeling, SPARQL queries, entity linking, and semantic search.