This is the first in a series about cross format data modeling principles.

Names are Simple, Right?

In the data modeling realm, there is perhaps no example that is as ubiquitous as modelling personal names. After all, things don’t get much simpler than a name:

Simple, right? Well, not so fast. This isn’t really a model, but rather an instance of a model - an actual example that proves out the model. There are, however, a number of ways that…

Recently, creators of JSON databases have dealt with a fundamental problem. Simply storing and retrieving a given document by a specific key, while useful in any number of scenarios, is not so useful when people want to query that JSON…

Data modeling is usually one of those subjects that make people's eyes glaze over. It's not really programming, though understanding programming concepts such as objects, inheritance, polymorphism and similar multisyllabic words is usually helpful to do modeling. It's not a business analyst function, though most BAs end up participating in the modeling process. Perhaps the best way of thinking about modeling is to see it as a way to describe a business in clearly defined pieces.

From…

A funny thing happened in the last few years. We began to lose the Closed World Assumption.

Now I can understand that this is not exactly huge, earth-shattering news; most people do not in fact realize that they've been using the Closed World Assumption to begin with. However, I'd contend that…