Category History

Cantor & Codd

If you’ve ever queried a database with SQL (Structured Query Language) then you’ve been standing on the mathematical shoulders of Georg Cantor. His 19th-century work on set theory laid the conceptual foundation that later revolutionised how we store and retrieve…

The Logical Model

The backbone of any data modelling strategy. A backbone so critical, so important, so key that … it is almost always ignored. See my post that talks to this: So why is the logical model not something that has equal…

Edgar Codd’s 12 Rules

In the late 1960s, Edgar F. Codd, an Oxford-educated mathematician working at IBM’s research lab in San Jose looked at the way data was being stored and thought “…this is far too messy” (probably). Back then, data lived in hierarchical…

Lamport Timestamps

You don’t need to understand the origin stories of why technology works the way it does. But we stand on the shoulders of giants that dedicated their time to solving hard problems. Leslie Lamport was one of those people. You…

Peter Chen’s ERD

Everything is obvious once you know the answer. The paperclip looks simple only because someone else did the hard work to invent it. The same applies to the Entity Relationship Diagram (ERD). In the mid-1970s, databases were getting bigger, more…

The Conceptual Model

A conceptual model is an abstract representation of business concepts and the relationships between them. It is used to convey meaning to stakeholders and technical teams. The term itself dates back to the 1970s and was used in:the 1975 paper:…