Microsoft Repository Phil Bernstein Microsoft Corp 1999 Microsoft

Introduction n Model – a labeled directed graph that describes a software artifact n n n SQL Schema OO interface XML DTD UML model n n n Workflow definition Web site map Computer system description A repository is a system to manage models © 1999 Microsoft Corp. . 2

Microsoft Repository Includes Update Marketing cust emp dept dno dna Authorize Credit Order Entry Bill Customer Schedule Delivery select all Information Model COM interfaces • SQL schema • Highly Extensible • Repository Engine Objects, properties • Rich relationships • Extensibility • Versioning Inventory ERD Spec Forms Model-Driven Tools Architecture Browser • XML import/export • Scripting language • Model editor • Component mgr Tables VB Code • VC++ Code Engine API Standard DB Engine • © 1999 Microsoft Corp. . SQL Server, Jet • Others from Platinum • Database System 3

The Killer Meta-Data App n Creating and maintaining a Data Warehouse is hard. You need tools, which require lots of meta-data Ø Ø Ø Inconsistent data formats Ø Missing or invalid data Ø Semantic inconsistencies Ø Data quality & timeliness Relate tech’l & business models Tracing data lineage Update Marketing n Meta-data driven data transformation tools cust emp dept dno dna select all ERD Ø Ø Ø Library of schemas and transformations Generate code for loading a data warehouse Version schemas & transformations for lineage © 1999 Microsoft Corp. . Authorize Credit Order Entry Bill Customer Schedule Delivery Inventory Forms Spec Architecture Tables VB Code VC++ Code 4

Data Transformation Service n Tool for building transformation scripts n Schemas and transformations are stored (versioned) in MS Repository Step 1 Source Step 2 Source VB Script Step 3 © 1999 Microsoft Corp. . SQL Query Destination OLE Object JScript Exec Utility 5

Data Lineage Repository Source Table Col 1 Col 2 . . . Package Version Data Transformation Services Package Executions Date/Time User Lineage. ID © 1999 Microsoft Corp. . Destination Table Col 1 Col 2 . . . Lineage. ID 6

Open Information Model n An OO meta-model to help tools share models Uml (Unified Modeling Language) OO Modeling Analysis and design (Visual Modeler) Cde Dbm (Component Description Model) (Database Model) Specifications Sharing and re-use (COM, Visual Component Mgr) © 1999 Microsoft Corp. . SQL and OLAP schemas Transformations (SQL Srv, DB 2, Oracle, Plato) 7

Open Info Model Structure n It’s highly expressive u Over 250 interfaces, 100 relationship types n It’s easy to understand u Industry-standard concepts, separable pieces n Originally, COM models for MS Repository n Now a Meta Data Coalition standard expressed in UML n New models: business processes, business rules, knowledge mgmt © 1999 Microsoft Corp. . 8