Advertisement

2019: Full Scale Schema Modeling

Click to learn more about author Thomas Frisendal. Using Concerns to Navigate Data Architectures Welcome to 2019! This is the year that offers us a unique opportunity to re-architect the way we think schemas, data models and Data Architecture. We do indeed need to do some things better. The real world is full of concerns, […]

Design Thinking Data Models

Click to learn more about author Thomas Frisendal. I seriously believe, and I also know from professional experiences that Design Thinking is the secret sauce for creating high quality Data Models. This sounds contra intuitive, so we will have to do some debunking: ”Design Thinking – isn’t that for designing good looking products, like watches, […]

Surrogate Keys: Paving the Way for Graph / NoSQL Data Models

Click to learn more about video blogger Thomas Frisendal. Since the mid-seventies many SQL-databases have been modeled using the concept of surrogate keys: Non-information bearing primary keys Used for join purposes (inter-table relationships) System generated (integer) values Not to be shown to end-users The advantage of using surrogate keys is guaranteed persistence, even across changes in […]

We use technologies such as cookies to understand how you use our site and to provide a better user experience. This includes personalizing content, using analytics and improving site operations. We may share your information about your use of our site with third parties in accordance with our Privacy Policy. You can change your cookie settings as described here at any time, but parts of our site may not function correctly without them. By continuing to use our site, you agree that we can save cookies on your device, unless you have disabled cookies.
I Accept