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

Resource Portals
Analytic Applications
Business Intelligence
Business Performance Management
Data Integration
Data Quality
Data Warehousing Basics
More Portals...


Information Center
DM Review Home
Conference & Expo
Web Seminars & Archives
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

General Resources
Industry Events Calendar
Vendor Listings
White Paper Library
Software Demo Lab

General Resources
About Us
Press Releases
Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Notes From the Giga Advisor:
Reports of the Demise of Meta Data Are Premature

  Column published in DM Review Magazine
March 2001 Issue
  By Lou Agosta

Reports of the demise of meta data are premature. It is now old news (September 25, 2000) that the Meta Data Coalition (MDC) closed up shop and merged with the Common Warehouse Metamodel (CWM). However, the glass is not half empty; it is half full. This is progress. This is not a breakdown - nothing went wrong here. No one needs two standards. Meta data consolidation will lead to useful results from which end users will see incremental tool and system interoperability, gains in economies of scope, and improvements in and reductions of coordination costs. The technology is still alive and well (or at least kicking vigorously); and, yes, XML will show up like the cavalry to rescue the tool interoperability wagon train.

Though this is not a tutorial on the two standards, context is required. Readers may recall that the two major differences were the repository metamodel and the meta data interchange standard. The CWM exploited the meta object facility (MOF) of the object management group (OMG) instead of the proprietary (i.e., patented) Microsoft Repository Technology Interface Model (RTIM). The CWM made use of an innovative idea of streaming XML meta data interchange (XMI) instead of pre-XML meta data interchange, sometimes also called XML interchange format (XIF). Otherwise, a strong case can be made that CWM was a superset of MDC and included such elements as the MDC's open information model (OIM), with the OIM's relational schema, data cube and the extract, transform and load (ETL) process. The CWM took the latter and added hierarchical, nonrelational data stores such as IBM's IMS and Hyperion Essbase (arguably already included in the data cube) as well as scheduling processes and business procedures as further forms of meta data. In this context, it should be noted that "super set" means "containing functionally equivalent classes or mechanisms to which the subset can be logically reduced" because strictly speaking, OIM is now obsolete.

At the same time, the meta data technology continues to play catch up with end-user requirements for all manner of data, application and system integration - architecture, database, workflow, B2B, you name it. Meta data remains a genuinely difficult problem. This is not anything going wrong - this is the complexity of technology. If we could solve the problem of meta data, then we would know how to make systems interoperate. This requires step- by-step progress, not a single act of breaking open the shrink wrap.

In conversations with Oracle representatives about the advanced meta data services of Oracle Warehouse Builder (OWB), they indicated XMI would be the interchange mechanism going forward. A single step of progress is in the offing as Oracle continues to integrate the acquired legacies (in the better sense of the word) of the OneMeaning Repository and the Carleton ETL suite of tools. In particular, OWB has bridges to Discoverer, Express and Designer. As Oracle further integrates the OneMeaning Repository, bridges to such design tools as Power-Designer and Erwin will become available using streaming XML based on the XMI to exchange content between tools and local repositories.

Meta data technology is still very much alive; and, as indicated earlier, a particular implementation of XML looks rather like the cavalry to the rescue of meta data in this context. The strategy is to use any meta data repository or tool that can encode and decode XMI streams to exchange meta data with other repositories or tools with the same capability. Thus, there is no need for products to implement the MOF-defined CORBA interfaces or even to "speak" CORBA at all. So yes, XML does represent a technology for defining the interoperability of tools and technologies.

However, the market is practical; and ETL vendors such as Informatica, Informix/DataStage, ETI and Sagent have stolen a march on the standards-based approach. They have captured an important position in the meta data narrative by being at the point where transactional data is mapped to decision support data warehouses. They, too, are working on XMI-oriented meta data processes. The intensity of the work is gated by such bootstrap effects as lack of other tools with which to exchange meta data. Naturally, a standards- based approach, such as Oracle is announcing, is precisely the sort of approach needed to act as a catalyst to create a network of interoperable tools. In the meantime, end users will continue to be challenged by the prospect that everything needed seems to be (as usual) shipping in the next release.

Even though the standard process is never as quick as required, the CWM specification is arguably complete enough to require vendors to implement it. XMI is a method of protecting investments already made in ETL, design and data presentation tools. The recommendation to clients is to grill their tool vendors at the front, middle and back ends about the plans to accommodate such standards-based meta data interchange. The resulting tool interoperability will mean both more end- user options and productivity. This win/win cycle is the whole point of meta data.


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

Lou Agosta is the lead industry analyst at Forrester Research, Inc. in data warehousing, data quality and predictive analytics (data mining), and the author of The Essential Guide to Data Warehousing (Prentice Hall PTR, 2000). Please send comments or questions to lagosta@acm.org.



Solutions Marketplace
Provided by IndustryBrains

Bowne Global Solutions: Language Services
World's largest language services firm offers translation/localization, interpretation, and tech writing. With offices in 24 countries and more than 2,000 staff, we go beyond words with an in depth understanding of your business and target markets

Award-Winning Database Administration Tools
Embarcadero Technologies Offers a Full Suite of Powerful Software Tools for Designing, Optimizing, Securing, Migrating, and Managing Enterprise Databases. Come See Why 97 of the Fortune 100 Depend on Embarcadero!

Online Backup and Recovery for Business Servers
Fully managed online backup and recovery service for business servers. Backs up data to a secure offsite facility, making it immediately available for recovery 24x7x365. 30-day trial.

Data Mining: Strategy, Methods & Practice
Learn how experts build and deploy predictive models by attending The Modeling Agency's vendor-neutral courses. Leverage valuable information hidden within your data through predictive analytics. Click through to view upcoming events.

Test Drive the Standard in Data Protection
Double-Take is more affordable than synchronous mirroring and enables you to recover from an outage more quickly than tape backup. Based upon the Northeast blackout and the west coast wild fires, can you afford to be without it?

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

Thomson Media

2005 The Thomson Corporation and DMReview.com. All rights reserved.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.