Categories
Search DMU Library
ARTICLE ARCHIVE
28
Jun
2018
17
May
2018
9
May
2018
4
May
2018
11
Apr
2018
23
Mar
2018
15
Mar
2018
21
Feb
2018
16
Feb
2018
9
Jan
2018
8
Dec
2017
16
Nov
2017
3
Nov
2017
17
Oct
2017
1 Oct, 2008
Dimensional Data Modeling Fact Qualifier Matrix
01 October, 2008
Pete Stiglich
Data Warehousing
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 th
1,365 views
0 comments
1 Apr, 2007
Performance Benefits of Surrogate Keys in Dimensional Models
01 April, 2007
Pete Stiglich
Data Warehousing
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
703 views
0 comments
1 Apr, 2006
Migrating From “Independent” Data Marts
01 April, 2006
David P. Marco
Data Warehousing
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 unt
837 views
0 comments
1 Oct, 2001
The Evolution of the Corporate Information Factory
01 October, 2001
Bill Inmon
Data Warehousing
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 appl
814 views
0 comments
1 Jan, 1999
Data Mart Migration
01 January, 1999
David P. Marco
Data Warehousing
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 "island
597 views
0 comments
1 Jan, 1999
Stranded on Islands of Data
01 January, 1999
David P. Marco
Data Warehousing
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 c
956 views
0 comments
DMU Sponsors
View all podcasts
View Our Podcasts
DMU provides regular podcasts of our best webinars, expert speaking events and our 3 minute Data Management Moment teaching videos.
The First Steps in Building a World Class Data Management Program
Date : 15 Nov 2018, Time : 1:00 PM, USA/Chicago
Presenter:David Marco
Registration Opens December 11, 2017.
During this webinar international speaker and bestselling author, David Marco will walk us through the key first steps needed in building a world-class data management program.
