Think Globally, Act Locally

The global data warehouse introduces a whole new world of design issues  As soon as the geographic spread of our data warehouse crosses a time...

Surrogate Keys

According to the Webster’s Unabridged Dictionary, a surrogate is an “artificial or synthetic product that is used as a substitute for a natural product.”...

A Dimensional Modeling Manifesto

Drawing the Line Between Dimensional Modeling and ER Modeling Techniques Dimensional modeling (DM) is the name of a logical design technique often used for data...

It’s Time for Time

The importance of the time dimension in data marts and data warehouses. The time dimension is a unique and powerful dimension in every data mart...

Data Warehouse Insurance

Insurance is an important and growing sector for the data warehousing market. Several factors have come together in the last year or two to...