1 / 9

Microsoft Repository

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

teal
Download Presentation

Microsoft Repository

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Repository Phil Bernstein Microsoft Corp. © 1999 Microsoft Corp..

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

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

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

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

  6. Source Table Col1 Col2 ... Data Transformation Services Package Executions Date/Time User LineageID Destination Table Col1 Col2 ... LineageID Data Lineage Repository Package Version © 1999 Microsoft Corp..

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

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

  9. To find out more • Web sites • http://www.research.microsoft.com/~philbe • http://msdn.microsoft.com/repository • Email • philbe@microsoft.com © 1999 Microsoft Corp..

More Related