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