Subscribe to DMU

Search DMU Library

Categories

Menu

Architecture

Dimensional Data Modeling Fact Qualifier Matrix

Fact Qualifier Matrix capabilities can be expanded to improve the value of conformed dimensions in business intelligence and analytics systems Introduction The venerable Fact Qualifier Matrix (FQM) has been a tool long used for demonstrating for dimensional models how fact and dimension tables intersect to ensure that dimensional models are conformed. A key principle of dimensional modeling is that dimensions must

Read More

Performance Benefits of Surrogate Keys in Dimensional Models

There are many benefits to implementing surrogate keys in a dimensional model design for a data warehouse data model Introduction There are many reasons for implementing surrogate keys in Dimensional Models (enterprise data modeling) such as insulating dimensions from changes to source systems and enabling historical versioning of dimension members. However, query performance in the data warehouse  is another primary

Read More

Migrating From “Independent” Data Marts

Independent data marts cause many problems in data warehouse architecture; combining to result in numerous issues for business intelligence and analytics solutions. Introduction A severe disease has spread to epidemic proportions throughout our society.  This disease is particularly dangerous as it effects are not readily identifiable at the time of infection.  However if this condition goes untreated it can be

Read More

The Evolution of the Corporate Information Factory

Introduction In the beginning were applications.  And applications served the corporation well until there was a desire for integration of historical information. However, applications supported neither integration nor historical data.  When it was noticed that applications – once built and put into production – were unable to be reshaped, the limitations of trying to get information out of applications became

Read More

Data Mart Migration

Fully architected solutions to data warehouse / analytics systems, not independent data marts, is the right way to ensure all the benefits of integrated data Introduction The need for an architected solution to decision support / analytics data, as opposed to the proliferation of independent data marts is becoming increasingly apparent.  The spread of independent data marts  have created “islands

Read More

Stranded on Islands of Data

Independent data marts create stranded, unusable data.  Independent data marts can spread like a disease through an organization and must be eradicated. There is a severe disease that has spread to epidemic proportions throughout our society. This disease is particularly dangerous as its effects are not readily identifiable at the time of infection. However, if this condition goes untreated, it

Read More

Contact us

  • This field is for validation purposes and should be left unchanged.

Request a free consultation
with a DMU Expert

  • This field is for validation purposes and should be left unchanged.