Rolling Out the Real-Time Data Mart
Thursday, November 30th, 2006Today, a new approach -- often labeled master data management -- is emerging, one that takes a modular, orchestration-based approach to rationalizing data strewn across the enterprise in various formats and repositories.
Similar to a complete SOA deployment, however, a complete master data management effort is a huge undertaking, one that takes years and consumes a lot of resources with marginal interim benefit. "You just can't shut down the enterprise and do this major business re-engineering," says Don DePalma, chief researcher at I.T. consultancy Common Sense Advisory. So what is I.T. to do?
Increasingly, companies are revisiting a mid-1990s approach -- the data mart, now often called a system of record -- that fell by the wayside during the data warehouse and repository crazes. Creating a system of record is a good way to start down the path of an enterprisewide master data management system. It helps I.T. get a handle on key data, making it more available to enterprise users and providing a demonstrable ROI in the process.
Data warehouses and enterprise repositories shunted aside the data mart of yore. In most cases, the data mart couldn't do the job of being a timely data container, DePalma says. "It was a snapshot, so it was outdated," he notes. But data marts can now be near-real-time repositories, thanks to a variety of advances in the...