The ladder

Eight rungs from a spreadsheet to a semantic layer for AI agents. Every rung has the same five parts: the concept, the signs you are there, the decision, the tools, and the next trigger. Security, compliance, data modeling, and cost run through all of them.

1. 1Spreadsheet / POS exportOne person, one file, one source of truth by default. Perfectly good until a second person needs to write to it.
2. 2Managed database + live appMany people write, one place holds the truth, and something checks the data on the way in.
3. 3Containers + microservicesoutlineSplit the app along team lines so teams stop waiting on each other. Not before you have teams.
4. 4OLTP + first analyticsoutlineStop running reports on the database that runs the business.
5. 5Batch + streamingoutlineChanges flow out of the database as events; anyone who needs them subscribes instead of asking.
6. 6Data lake / warehouseoutlineOne governed place for everything, with layers that separate "what arrived" from "what we trust".
7. 7Data meshoutlineDomains own their data as products; the centre owns the standards, the catalog, and the platform — not the pipelines.
8. 8Golden layer + semantic layer for AI agentsoutlineGive machines the same trustworthy definitions humans fought for, so an agent's answer is the company's answer.