A different type of choice

How you model your data is a core part of your data platform.

Many data modeling options sit before you.

You can view it as an exclusive choice.

I pick A or B.

I choose pattern X or Z.

...

Or you can view it as an inclusive choice.

I pick A and B

I chose patterns X and Z.

...

The industry vendors or gurus will beat the drum on exclusive choice.

“It’s star-schema or bust!”

“The Data Vault 2.0 is the most robust practice available”.

But Data Modeling is and not or. It’s an inclusive choice.

Your data architecture could very likely include:

• Data Vault and Kimball Star Schema

• Kimball Star Schema and OneBigTable

• Inmon Warehouse and Kimball Star Schema

• Data Vault and OneBigTable

Data modeling is not a one-time choice. Nor is it a single choice.

Your data model revolves around business objectives which means your model looks like and more than or.

I’m here,

Sawyer

from ​The Data Shop