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

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

Metadata Management & Enterprise Architecture:
Industry Specific MME Applications, Part 4

  Column published in DM Review Magazine
January 2006 Issue
  By David Marco

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

In the first three parts of this series on industry-specific managed metadata environment (MME) applications, I walked through examples in the banking, healthcare insurance, manufacturing, national defense and pharmaceutical industries. This month I will conclude this four-part series by addressing the retail and telecommunications industries.

Retail Industry Example

Retail companies were early adopters of data warehousing technology. They have been lagging somewhat on the adoption of MME compared to industries such as healthcare and banking, which were also early data warehouse adopters. The need for MME applications in the retail industry is absolutely critical because retail companies have inflated IT budgets, and there is a great deal of decision-making and client interfacing that occurs among various stores.

MegaMart is a large nationwide retailer with more than 1,000 stores. A few years ago, MegaMart was wise enough to build an MME that would manage both technical and business metadata around their systems. MegaMart has a corporate goal of consolidating three of its current systems into a new enterprise resource planning (ERP) system. In order to accomplish this task, MegaMart needs to know where its customer data resides within these systems. Figure 1 shows where customer data exists by attribute, with the attribute definition and the estimated number of records.

Figure 1: Customer Data by Attribute

If the ERP implementation team didn't have the MME, they would need to manually do the impact analysis shown in Figure 1. Typically, this degree of manual impact analysis takes months to accomplish. An impact analysis generated from the MME takes only hours or days.

Telecommunications Industry Example

A great number of regulations have an impact on the telecommunications industry. It is quite common for firms in this space to pay literally tens and even hundreds of millions of dollars in penalty fees for not adhering to these regulations.

NoTeleCo is a large telecommunications company that provides long-distance and local phone service. NoTeleCo has an extensive MME that targets business and technical metadata. In addition, NoTeleCo has a data warehouse that focuses on phone usage. When a customer places a call through a telephone service provider, the phone lines used typically are not owned by one service provider. Usually, the phone call will go across several telecommunications companies' equipment. As a result, NoTeleCo needs a report (see Figure 2) that shows the amount of phone usage by their customers that is occurring on other carriers' (telecommunications service providers) lines.

Figure 2: Usage Report

A knowledge-worker at NoTeleCo would be working with this report and might want to better understand the Discounted Usage column. Figure 3 shows the worker hotkeying on the Discounted Usage column to get a business metadata definition for the field.

Figure 3: Business Metadata Definition

As the knowledge-worker is looking through the business metadata definition for "Discounted Usage," he sees that discounted usage is defined as "non-prime, holiday and rate specials." These fields are underlined. This formatting lets the user know that business metadata definitions exist for these fields and that the end user can click on these fields to receive a business metadata definition. This type of functionality is common in well-designed MMEs.

In our example, this worker may want to learn when non-prime phone usage rates apply by clicking the non-prime field to get a business metadata definition for this field. Figure 4 shows the definition for "non-prime." The user discovers that non-prime time is defined as phone usage between 8:00 p.m. and 7:00 a.m.

Figure 4: Non-Prime Definition


Check out DMReview.com's resource portals for additional related content, white papers, books and other resources.

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

Data Validation Tools: FREE Trial
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.

Speed Databases 2500% - World's Fastest Storage
Faster databases support more concurrent users and handle more simultaneous transactions. Register for FREE whitepaper, Increase Application Performance With Solid State Disk. Texas Memory Systems - makers of the World's Fastest Storage

Manage Data Center from Virtually Anywhere!
Learn how SecureLinx remote IT management products can quickly and easily give you the ability to securely manage data center equipment (servers, switches, routers, telecom equipment) from anywhere, at any time... even if the network is down.

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.

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.