Master Reference Data Governance And Maintenance For Analytics And Operations

Reference data is often the orphan child of Master Data Management, sometimes segregated from MDM entirely or assumed to come along for the ride as MDM strategies are implemented for other domains.

But reference data is at the core of your enterprise semantics -- it describes your business -- and as such requires a holistic approach to its governance and mastering. Tools and processes need to be in place to harmonize reference data across the enterprise, since application systems tend to proliferate their own coding and classification schemes with varying but overlapping taxonomies.

This case study will describe both a toolset and a governance model, developed first in the data warehouse space and now extended to the operational realm. We first addressed the problem at the focal point of data integration, our Enterprise Data Warehouse, in which reference domains from multiple systems needed to be rationalized into an enterprise standard. This led us to develop a tool (the Reference Table Utility, or RTU) and a data store (the Corporate Reference Center, or CRC), and to engage business stakeholders in governance over reference data. Now, as we build a new operational platform with federated components integrated via Service Oriented Architecture (SOA), the same processes and toolkits are being leveraged to essentially virtualize the master reference data hub in the operational realm.