Distributed Metadata Management Stu Carty April 9 2003

Metadata Management Architectures Centralized Real-Time Hybrid (passive) copies and/or physically stores meta data definitions active, real-time access to meta data (no copy / storage) real-time access with some copy / storage 2 Copyright 1999 -2003 Data Advantage Group, Inc. www. dag. com

Meta. Center™ Architecture Unique Ability, Patent Pending 3 Copyright 1999 -2003 Data Advantage Group,

Meta. Center - Easy to Use & Navigate 4 Copyright 1999 -2003 Data Advantage

Meta. Center is 100% Extensible You can model any type of metadata Add any object-types, attributes, or relationships Entity - Name - Definition - Data-type - Data-Values Critical Success Factor - Name - Definition - Policy Maker - Controllability Rating Business Rule - Name - Definition - Policy Maker - Manager Technical Table - Name - Syntax - Column - Data Steward Operating Platform - Definition - Location - Specifications Mapping - Name - Comment - Version - Application 5 Copyright 1999 -2003 Data Advantage Group, Inc. www. dag. com

IRMAC - Key Questions to Address Key Features & Functions Meta. Center version 2. 7 Meta. Center version 3. 0 (shipping today) (launches Q 2/2003) 100% Java Yes Windows-based 100% Java Independent, Standalone Repository product Yes 100% extensible meta-model: object-types, attributes, and relationships Yes Non-Proprietary Repository based on standard, open 3 rd-party RDBMS Yes Repository DBMS accessible thru 3 rd-party tools Yes Open Import thru Flat Files (CSV) Yes Open Interchange thru CWM/XMI no Yes Repository Export thru CWM/XMI no Yes Import mapping wizard Yes Export mapping wizard no Yes Informatica, Business Objects, ERwin, Oracle DBMS, SQL/Server DBMS plus Micro. Strategy, DB 2/UDB, Cognos, and others US$80, 000 to $150, 000 5 days Web Portal / Browser-based interface Favorites Dashboard Administrator interface Real-time (Active. Linx) meta data interfaces Pricing - 200 users + interfaces Typical installation, setup, and training 6 Copyright 1999 -2003 Data Advantage Group, Inc. www. dag. com

Customer Examples 7 Copyright 1999 -2003 Data Advantage Group, Inc. www. dag. com

Meta. Center Customer Example Centralized (passive) copies and/or physically stores meta data definitions v Business Audience – dozens of users v Uses Meta. Center to document, store, and manage Business meta data for internal “Finance Data Library” 8 Copyright 1999 -2003 Data Advantage Group, Inc. www. dag. com

Meta. Center Customer Example Major Sportswear Company v v v Real-Time active, real-time access to meta data (no copy / storage) Technical Audience Uses Meta. Center to help manage 1100 ETL mappings across 13 separate, physical ETL repositories Emphasis on Data Lineage, Mapping Analysis, Impact Analysis reporting 9 Copyright 1999 -2003 Data Advantage Group, Inc. www. dag. com

Meta. Center Customer Example v v Both Business & Technical audience – over 200 users DW tools = Informatica, Erwin, MS-SQL/Server Previously using Excel spreadsheets to manage metadata! Uses Meta. Center to document, store, and manage both Business and Technical metadata from their DW environment Hybrid real-time access with some copy / storage 10 Copyright 1999 -2003 Data Advantage Group, Inc. www. dag. com

Customer Write-Ups Available please visit our website at www. dag. com 11 Copyright 1999

What the Experts Say "Data Advantage Group brings a fresh, modern "Meta. Center is a truly unique product perspective to the world of enterprise offering. Its innovative approach metadata management. I've reviewed this of real-time interfacing sets it apart from company in detail, and can honestly say that legacy repository products. Meta. Center's their background and experience is ease of use helps it to be implemented exceptional. I'm very impressed with their across a broader audience from business innovative product and service offerings. " users to IT staff. " Bill Inmon "The Father of Data Warehousing" & Leading Expert in Metadata Management President, Billinmon. com LLC Adrienne Tannenbaum Leading Authority in Metadata Mgmt President, Database Design Solutions “… Metadata is back on the agenda and Data Advantage Group certainly understand it and have a viable, pragmatic and unique approach. ” Gareth Morfill Senior Analyst, Ovum 12 Copyright 1999 -2003 Data Advantage Group, Inc. www. dag. com