Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search

View all Portals

Scheduled Events
Archived Events

White Paper Library
Research Papers

View Job Listings
Post a job


DM Review Home
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

Buyer's Guide
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

About Us
Press Releases
Advertising/Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Meta Data & Knowledge Management:
MME Best Practices Case Study Allstate Insurance, Part 5

  Column published in DM Review Magazine
June 2005 Issue
  By David Marco

This column is adapted from the book Universal Meta Data Models by David Marco & Michael Jennings, John Wiley & Sons, 2004.

In the first four parts of this series on Allstate's managed meta data environment (MME), I walked through their data stewardship organization, MME solutions overview, meta data sourcing layer and the meta data delivery layer of their MME. In this, the fifth and final installment, I will discuss their MME future directions and return on investment (ROI).

Allstate's Future MME Directions

While many corporations would be happy to rest on their laurels, this is not the case with Allstate, as they are constantly looking to build on their success.

Business Rules

Allstate believes that business rules are another area where they can add value to their enterprise. Rules engines from various vendors are likely to show up in an organization of Allstate's size. Rather than struggle to impose a particular engine on a specific application, Allstate's approach is to define and capture the common meta data around a business rule in which they have interest. Allstate plans to extend their MME to accommodate this additional meta data and provide a central place where users can obtain reliable information on what rules may already exist concerning a specific topic.

ETL Tool Integration

Allstate has recently chosen an enterprise solution for its extract, transform and load (ETL) needs. It is now working on a bidirectional meta data bridge that will push logical model information, codes and values to the ETL tool and pull back transformation meta data. This will be stored centrally in Allstate's MME and passed through the same meta data generation process into their data warehousing environment. In addition, Allstate will also gather load statistics and data quality statistics from actual runs of the ETL tool, and plans to present that information to business users of key reports.

Process Definitions

Process definitions and data about processes are other areas where Allstate is considering expansion. Allstate currently has a group that will help their business area document and subsequently improve their current process.


Another group within Allstate is exploring the creation of an enterprise taxonomy, or classification scheme, to be used for searching and general knowledge management of Allstate's Internet and intranet offerings. Allstate's Vincent DiGiannantonio, team leader of Data Administration and Common Name Space, observes, "In general, we listen closely to what our application services people and ultimately our business community is saying. We position ourselves to provide tangible benefits to the community through our work, thus enabling us to continue to add value to the corporation."

MME Challenges

Allstate's MME implementation is one of the most advanced meta data management applications in existence. An application of this magnitude requires sufficient upfront investment and sustained organizational support. It has been Allstate management's unwavering support that has allowed this effort to prosper. Linda Hall, director of Enterprise Data Management and Data Warehousing, stated: "You must have an excellent vision, coupled with a strong development team ... We have real strong visionaries, and those visionaries have continued to support us. They continue to set our sights onto the future."


Allstate calculated the cost for the development and maintenance of the infrastructure needed to build and support the MME. Added to that is the cost of all groups responsible for working with the application areas and gathering the meta data to populate the repository. Allstate's company policy prohibits the publication of actual costing numbers; however, like any major IT initiative, it is not a minor investment. Linda Hall mentioned, "Now we get lots of IT reuse, and this shows up in faster and cheaper application development."

While the investment in meta data management is not trivial, Allstate's tremendous success has provided them an equally impressive return through the IT reuse. Doug Stacey commented, "Consider the effort that goes into researching codes for an application. If we did not have the repository as a base for this information, we would be forced to repeat that effort every time a new requirement for the application arises or a set of codes changes. This savings is significant and results in real dollars to our organization." Allstate is currently achieving a reuse factor of 7.5, meaning that for every domain in production mapped to a physical column, it is actually mapped to an average of 7.5 columns. In addition, more than 50 percent of the domains captured in the MME are mapped to more than one physical column.

Allstate has estimated both the costs of the MME and the savings realized through reuse, and feels comfortable stating that it has achieved a significant return on investment. Doug Stacey stated, "Our repository has been invaluable to our company. The ability to manage our systems in a more flexible manner has made the repository pay for itself several times over."


For more information on related topics visit the following related portals...
Knowledge Mgmt. and Meta Data.

David Marco is an internationally recognized expert in the fields of enterprise architecture, data warehousing and business intelligence and is the world's foremost authority on meta data. He is the author of Universal Meta Data Models (Wiley, 2004) and Building and Managing the Meta Data Repository: A Full Life-Cycle Guide (Wiley, 2000). Marco has taught at the University of Chicago and DePaul University, and in 2004 he was selected to the prestigious Crain's Chicago Business "Top 40 Under 40."  He is the founder and president of Enterprise Warehousing Solutions, Inc., a GSA schedule and Chicago-headquartered strategic partner and systems integrator dedicated to providing companies and large government agencies with best-in-class business intelligence solutions using data warehousing and meta data repository technologies. He may be reached at (866) EWS-1100 or via e-mail at DMarco@EWSolutions.com.

Solutions Marketplace
Provided by IndustryBrains

See Enterprise Business Intelligence in Action
See how business intelligence can be used to solve real business problems with this live demo from Information Builders

Autotask: The IT Business Solution
Run your tech support, IT projects and more with our web-based business management. Optimizes resources and tracks billable project and service work. Get a demo via the web, then try it free with sample data. Click here for your FREE WHITE PAPER!

Design Databases with ER/Studio: Free Trial
ER/Studio delivers next-generation data modeling. Multiple, distinct physical models based on a single logical model give you the tools you need to manage complex database environments and critical metadata in an intuitive user interface.

Data Quality Tools, Affordable and Accurate
Protect against fraud, waste and excess marketing costs by cleaning your customer database of inaccurate, incomplete or undeliverable addresses. Add on phone check, name parsing and geo-coding as needed. FREE trial of Data Quality dev tools here.

Free EII Buyer's Guide
Understand EII - Trends. Tech. Apps. Calculate ROI. Download Now.

Click here to advertise in this space

View Full Issue View Full Magazine Issue
E-mail This Column E-Mail This Column
Printer Friendly Version Printer-Friendly Version
Related Content Related Content
Request Reprints Request Reprints
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.