The Database Doctor
Musing about Databases

Tag: data-model

Cover image for Finding things in Data Models with Property Bags
Finding things in Data Models with Property Bags

When designing database schemas, you may find yourself needing to create a property bag table that is in a 1-n relationship with an entity table. It isn't always viable to just add more a...

Cover image for What is a good database key?
What is a good database key?

A central value add of modeling databases for analytical purposes and speed is that you can restore the sanity, often lost in the source system, that comes from using good keys in each it...