O'Reilly logo

Data Model Scorecard: Applying the Industry Standard on Data Model Quality by Steve Hoberman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6 Category Three: Scheme How well does the model match its scheme?

The “Scheme” category checks that the data model we are reviewing matches our expectation for its scheme. The scheme includes level of detail (conceptual, logical, and physical), and also whether relational, dimensional, or NoSQL. For example, if we are reviewing a conceptual data model that has characteristics of a physical data model such as attribute formatting and nullability, we would catch it in this category. There are currently five cells covering ten schemes as shown in the following table:

There are conceptual and logical models that can be both ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required