Architecture

The link between data warehousing and MDM

Arun Mysore

An international survey by Baseline Consulting has explored the link between data warehousing (DW) and master data.

An international survey by Baseline Consulting has explored the
link between data warehousing (DW) and master data.

Key findings from the research study included the following:

* Almost half (46 percent) of organizations surveyed have one or
more DW and MDM implementations. Relatively few (7 percent) had
only MDM.

* Encouragingly, 57 percent of MDM implementations are
“enterprise-wide”; for DW’s this number is 75 percent.

* The MDM implementations surveyed manage a median of 4 million
records; the biggest DW’s are around 500 – 800 terabytes in size
with a mean size of 34 terabytes.

* Two-thirds of organizations have data governance in place,
showing an improvement over earlier studies.

* Two-thirds consider their MDM and DW implementations to be at
least moderately successful.

Jill Dyché, co-founder of Baseline Consulting, said, “It’s not
surprising that companies with mature data warehouses are turning
their heads to MDM to address data quality and reconciliation
issues in a more sustainable way. What is surprising is that MDM is
often adopted by data warehousing teams in advanced operational
applications. This reconfirms that MDM and data governance are
being deployed incrementally by the early adopters.”

More than 200 respondents completed the survey from companies
worldwide. Over half of the respondents came from companies with
annual revenues greater than $1 billion.

You can access the complete survey at Baseline web site.

Author
Comments
comments powered by Disqus