Tags
AI, arms, Artificial Intelligence, backfill, chatgpt, code, code-cortex, Data Warehouse, database, EDW, llm, oracle, progresql, reinventing-the-wheel, snowflake, tech-hour, technology
Martyn Rhisiart Jones, Madrid, Friday 27th March 2026
Warehousing Your Data: A No-Nonsense Guide to the Right DBMS in 2026
Listen, you glorious data martyrs. You noble sufferers who have spent far too many evenings coaxing historical rows into slowly changing dimension tables while the rest of the office has gone home to sensible lives. You know the drill. The star schema looks perfect on paper, the fact table is append-only and cooperative, but then someone asks for last year’s corrected customer segments. Suddenly, your backfill script is performing open-heart surgery on a live production warehouse.
In 2026, vendors are still shouting about infinite scalability and “agentic AI” (whatever that means this week), but what actually matters is a system that lets you shove yesterday’s data into those dimension objects without it feeling like a hostage negotiation.
I have been asked to examine the most appropriate database management systems for effective data warehousing, with particular attention to the pain of backfilling dimensional tables. The brief is clear: functionality, reliability, scalability, extensibility, maintainability, performance, cost, ease of use, and a total lack of corporate nonsense.
Continue reading
