When Database Design Breaks: Real-World Patterns and Pitfalls
Database design sounds clean on paper. You draw boxes, connect them with lines, normalize to 3NF. But in real projects, it's rarely that tidy. I've se...
Design Databases That Last: Ethical Schemas, Sustainable Indexing, and Long-Term Impact
Explore principles and practices for building data foundations that remain resilient, fair, and performant through years of growth and change.
Articles — Page 3
What to Fix First When Your Database Model Outpaces Your Ethical Framework
You're staring at a users table that's grown like kudzu — columns for location, purchase history, browsing time, even a sentiment_score some intern ad...
Choosing a Foreign Key That Respects Both Performance and Human Dignity
Foreign keys are the glue of relational databases. But picking the wrong one? That's how you end up with a schema that's both slow and a pain to debug...
When Schema Rigidity Blocks Climate Adaptation: Designing for Uncertainty
You're three years into a flood monitoring database. Then a new satellite feeds precipitation data at a resolution your schema never anticipated. Your...
Sustainable Index Strategies
When a Sustainable Index Becomes a Liability: Planning for Regulatory Shifts and Moral Obsolescence
In 2022, the EU's Sustainable Finance Disclosure Regulation (SFDR) forced a sudden reclassification of thousands of funds. Overnight, indexes that had...
Sustainable Index Strategies
What to Fix First When Your Green Index Strategy Ignores Supply Chain Dignity
You've built a green index that beats the benchmark on emissions. But what about the factory where a worker sews for 16 hours without overtime pay? Th...
Sustainable Index Strategies
When Provenance Beats Pure Performance: An Index Built for Trust
I spent last Tuesday in a windowless conference room with three pension-fund analysts and a data vendor who kept apologising for his own slides. 'We h...
Sustainable Index Strategies
Choosing a Sustainability Filter That Weights Future Climate Scenarios, Not Past Emissions
A pension fund trustee once told me: We have a 2050 net-zero target, but our index still holds oil majors because their 2022 emission were slightly be...
Sustainable Index Strategies
When Your Index Outpaces Your Ethics: Aligning Carbon Goals with Data Growth
Picture this: your sustainable index just beat the benchmark by 2%. The board is happy. But the data center powering that index’s top hold is gu...
Long-Term Data Provenance
Choosing a Provenance Policy That Doesn't Lock Future Generations Into Today's Assumptions
You are choosing a provenance policy today. Maybe for a digital archive, a scientific data repository, or a national record. The temptation is to spec...
Long-Term Data Provenance
When Your Data Provenance Outlives Your Organization: Planning for Institutional Death
You build a provenance system to track every transformation, every source, every trust anchor. Ten years later, your company is acquired and dissolved...
Legacy Migration Ethics
When Speed of Migration Undermines Sustainability of Trust
In 2018, a major UK bank attempted a weekend migration of its core banking platform. By Monday morning, 600,000 customers could not access their accou...