Study notes · Data Modeling

Banking Data Models — 12 Approaches, 4 Eras

A learning-in-public post: I worked through every major approach to modeling banking data — from Inmon's CIF and Kimball's dimensional model through BIAN, ISO 20022, FIBO, Data Vault, Lakehouse Medallion, Data Mesh, Activity Schema, and the AI-native hybrids of 2024+. With diagrams, trade-offs, and a decision tree.

"My takeaway from the reading: no holy grail. Each approach does one thing well — the question is composing them right."

Data ModelingBankingLakehouseData Mesh~35 min read

Read the post →All posts

1992

Era 1

Classical

2004

Era 2

Standards

2013

Era 3

Lakehouse

2023

Era 4

AI-Era

12

Approaches

13

Diagrams

~35 min

Reading

12 approaches · 4 eras · 13 diagrams

Side project · Audio engineering

DQ-DSP

Couldn't get a $200 miniDSP shipped to Vietnam, so I built one for $20. An ESP32-S3 plus two cheap I²S DACs that drive my DIY 2-way active speakers and tune live from any Chrome tab. Open-source firmware + UI, GPLv3.

"miniDSP wants $200. Mine costs $5 and a few weekends. Sounds great, runs forever, fits in a tin."

ESP32-S3USB Audio ClassWeb SerialActive Bi-AmpGPLv3DIY

Try the live UI →Read the story