It’s tempting just to replicate all databases in the cloud, but it’s a much better approach to get your data house in order as part of the move. Last week I discussed database normalization as a best ...

I have an order table that is an order for a customer. I need to reference as a foreign key an unknown number of products that could make up the order (product_id) how do I do this? What am I missing.

When normalizing data structures, attributes congregate around the business keys that identify the grain at which those attributes derive their values. Attributes directly related to a person, ...

Junk dimensions are often misunderstood and avoided. And they should not be. Junk dimensions offer a strategy to remain true to dimensional intentions and to better focus one's design and sometimes ...