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

Meta Data and Data Administration:
Meta Data: The Key to Decision Support

  Column published in DM Review Magazine
February 1999 Issue
  By David Marco

This column is dedicated to meta data and data administration. During the coming months we will examine such topics as meta data ROI, architecture (distributed vs. centralized vs. decentralized), data administration staffing and organizing, meta data delivery, and the future trends shaping the meta data and data administration arena. In addition, we will examine some "best practice" case studies of companies that are doing meta data well. If you believe your company is one of them please feel free to contact me.

Building a meta data repository is critical for accessing, maintaining and controlling the vital information stored in our decision support systems (DSSs). While meta data has always been a central covenant of data warehousing, over the last couple of years it has been brought further into the spotlight as most Fortune 1000 companies have some sort of DSS system currently in place - most for several years. The vast majority of these companies have had to struggle with the task of managing the exponential growth of these decision support systems over time. Without meta data, the task of managing this growth becomes overly difficult and time-consuming. This need has driven many major software vendors such as Microsoft, Platinum, Oracle and IBM to enter the meta data marketplace with significant product offerings. This month's column focuses on clearly presenting the benefits of implementing a meta data repository to support a company's decision support system efforts.

Reduced Development Costs

DSS systems grow very rapidly. As a result, the data warehouse will need to be modified through a process of iterative steps. Each of these steps will require an analysis of the current warehouse environment. The repository will significantly reduce the cost of development and the time to do it. It accomplishes this by documenting the data transformation rules, data sources, data structures and the context of the data in the data warehouse and data marts. This is critical because without the repository, the transformation rules would only be contained in the IT staff's collective memory. The meta data significantly aids analysts as they examine the impact of proposed changes in the DSS environment. This benefit will reduce the costs of future releases and help to reduce the propensity of new development errors.

Improved Error Resolution

The meta data repository will reduce the turnaround time for production-related problem resolution. If a DSS production problem is identified, the development team can use the repository to quickly gather information related to the problem. This is very valuable, as the business users have come to depend on the information contained within the data warehouse to make their strategic decisions. The less "down time" the warehouse experiences, the greater payback the business users will experience.

Delivering Business Intelligence

A central objective of any corporation's business intelligence strategy is to improve the value that the information in the DSS system provides to the business user. The ultimate goal of the meta data repository is to drive the business users' access to the information stored in the DSS system. This can be achieved as the business and technical meta data are directly linked to the information stored in the DSS system. This greatly increases the usability of the DSS systems to the business users.

To understand meta data's vital role in the data warehouse, consider the purpose of a card catalog in a library (see Figure 1). The card catalog identifies what books are in the library and where they are physically located. It can be searched by subject area, author or title. By showing the author, number of pages, publication date and revision history of each book, the card catalog helps you determine which books will satisfy your needs. Without the central card catalog information system, finding books in the library would be a cumbersome and time-consuming chore.

Figure 1: Meta Data Repositories and Card Catalogs

Meta data is the card catalog in a data warehouse. By defining the contents of a data warehouse, it helps the user locate relevant information for analysis. In addition, the meta data allows the user to trace data from the data warehouse to its operational source (drill-down) and to related data in other subject areas (drill-across). By managing the structure of the data over a broad spectrum of time, it provides a context for interpreting the meaning of the information. As meta data is extracted and stored over several years, snapshots of the data exist for each year. In order to accomplish this, the meta-model tables need to be captured with a "from" and "to" date on each column. This will allow the users to easily trace through the repository to past versions of the meta data.

A meta data repository built with the business users in mind and created on a technologically sound architecture lifts the data warehouse from a stovepipe application to a true business intelligence system. Even with the immature state of the meta data repository marketplace, the alternative of not building a repository will not satisfy the needs of the business users or the data warehouse staff that will need to maintain the DSS system. This challenge of implementing a meta data repository is one of the chief mitigating factors that has prevented most organizations from achieving successful data warehouse and data mart implementations.


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

Numara Track-It! Help Desk Software
Numara provides Track-It! - the leading help desk solution for call tracking, problem resolution, IT asset management, LAN/PC auditing, patch management, electronic software distribution, remote control, and more. Free demo

Strategic CRM Analytics White Paper
This white paper explores how companies can extend their CRM applications by using BI tools to turn CRM data into actionable information to drive strategic decision-making and improve ROI.

Metadata Management Software
MetaCenter: Plug & play metadata management software for enterprise systems. Features: data dictionary, process documentation, impact analysis, search across multiple systems, web-based interface, reports, dashboards, import, export and more!

Website tracking, web statistics and analytics
Watch your visitors in real time as they browse your site. Website statistics provide insight. Understanding website traffic and visitor clickstream behavior is crucial to managing a website on a daily basis. Real-Time reporting. 4 week free trial.

Blackfox is the world premier IPC Certification Co
Blackfox is the premier IPC Certification and Training Center, offering all 5 IPC Certifications. We also specialize in manufacturing skill training and processes, including Lean and Lead Free Processes

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.