CSS metrics review - Metadata Standard

CSS metrics review - Metadata Standard

ISO/IEC JTC1/SC32/WG2 N1527 Information Management Metamodel Pete Rivett, CTO Adaptive OMG Architecture Board [email protected] 2011-05-11 1 The Information Management Conundrum We all have Datado we have Information? Data is defined, modeled, stored in islands of technologies and exchanged via many incompatible formats It is difficult to trace business Terms to models, XML Schemas, data stores (structured and semi/unstructured), applications, Services, processes Impact analysis of changes spanning across the life-cycle of Information and lines of business is even harder

Semantic nuances and geographically relevant variations of business Terms and rules is not often well documented and traceable Seamless integration across data life-cycle management tools and formats is flaky at the best All of the above issues result in poor quality Information leading to poor and costly business decisions 2 Common Warehouse Metamodel (CWM) precursor of IMM Warehouse Management Analysis Resources Warehouse Process

Transformation ObjectOriented OLAP Relational (Object Model) Foundation Warehouse Operation Business Data Information Types

Data Mining Information Visualization RecordOriented Expressions Business Nomenclature Multi Dimensional Keys Type

Index Mapping XML Software Deployment Object Model (Core, Behavioral, Relationships, Instance) 3 What is IMM? UML has not been very data modeling friendly*! Data modelers simply like the Crows Feet even though a UML Class Diagram can be a good precursor of a Conceptual Data Model IMM, an OMG standard, is being developed to:

Facilitate modeling of structured and un/semi structured Information by standardizing traditional data modeling concepts and notations Enable bi-directional traceability & lineage from business Terms to Object Oriented models, data models, XML Schemas, Ontologies, Services, Processes Exchange of Information life-cycle metadata across tools as XMI (an OMG standard) Harmonization with other Information management related standards such as Semantics of Business Rules and Vocabulary (SBVR) and Ontology Definition Metamodel (ODM) * As the data modeling community would like it to be! 4 Background OMGs Common Warehouse Metamodel (CWM, http://www.omg.org/technology/cwm/ ) has been implemented by

many vendors and used by end users primarily for metadata interchange across tools In use across data modeling, business intelligence, ETL tools and metadata repositories The uptake has been somewhat hampered by CWMs name many of the potential uses of CWM have no connection with building or managing data warehouses. Hence the proposed name for the new standard is Information Management Metamodel instead of CWM 2.x. Over the years, many UML vendors and end users have expressed a desire to use UML for data and XML modeling and ended up defining their own tool-specific profiles for each As a result, there is neither an accepted standard nor interoperability of models developed using such profiles/tools IMM will become the bridge between UML, data and XML modeling Islands IMM will complement OMGs business vocabulary and Ontology modeling standards by enabling consistent understanding, modeling and interchange of Information across Business and IT

Business driven Information management: Nirvana State! Business Define Business Concepts, Rules in Natural Language, targeted at the Business User -Policy is an Agreement between 2 Parties (Seller, Buyer) -Agreement is Policy in Life and P&C Line of Business Information Architects, Modelers, DW/ETL, BI staff

Import Business Vocabulary, Rules into data modeling tool that can Transform it into Conceptual model Data modeler can further develop logical, physical, dimensional models (automation of vocabulary to data models >> modeler productivity) Trace (bi-directionally) Business Concepts to data models, XML Schema elements, Core Components Import Vocabulary/Rules, models into ETL, Data Quality, BI tools - For Annuity it is a Contract -Policy is inforce if

the Policy has not expired and.. SBVR IMM Import into Ontology modeling tool -Develop Ontology, (output RDF, OWL) - Vocabulary validation, reasoning ODM ODM Application, Service development

Import Business Vocabulary, Rules to develop: Use Cases Class diagrams, Services UML, UPMS IMM Scope UML2 Profile The World of Business Related Models ERD DB Design

The World of Data Bases ER Metamodel UML2 Profile Ontology Metamodel Relational Metamodel Semantics of Business Vocabulary and Rules

XML Schema IMM XML Schema Metamodel MOF2 UML2 Profile Core UML Metamodel Traceability Metamodel

Managing it All UML Diagram LDAP Metamodel UML2 Profile LDAP Listing UML2 Profile The World of Applications

7 IMM Components Overview 8 IMM for Entity Relationship Modeling (Illustrative) Sample Logical Model 9 IMM ER Metamodel - Attributes 10 IMM ER Metamodel - Relationships

11 IMM ER Metamodel - Constraints 12 IMM ER Metamodel Misc 13 IMM for Relational Database Design Sample Model 14 IMM for XML Schemas Sample XML Schema

15 IMM Core Common concepts: Attribute Association Thing Type Mix-in concept library: Identifier specification Reference Reference Attribute Binding Composition

Common Mix-in Separate Metamodels Technology-specific Technology-specific concepts: Relational examples: Table, Row, Column, Primary Key, Foreign Key XML Schema examples: Element, Complex Type, Sequence, Group 16 IMM Core - Fragment 17 IMM: Traceability and Lineage

Traceability The connection between information model elements . Lineage Operational movement of data which may involve transformation. For example, ETL links Dependency (mapping) The fact that changing one element has an impact on others. Used in impact analysis For example Entities -> Tables Tables -> Software Versions 18 IMM Traceability Metamodel 19

IMM: Lineage Metamodel 20 From Vocabulary to Data Model Transform Vocabulary to Model Each open rental must be guaranteed by a credit card that is held by the renter who is responsible for the rental the actual pick-up date/time of an open rental must occur before the scheduled return date/time of the rental It is prohibited that a barred driver is a driver of a rental It is obligatory that each driver of a rental has a valid driver license at pick-up date-time of the

rental It is prohibited that a rental car is driven by a driver who is intoxicated Vocabulary written using Business Vocabulary Modeling Language (SBVR) Based on IMM 21 Work Remaining Streamline wording Make more spec-like Complete LDAP metamodel and profile Extend worked example to ODM integration 22

Recently Viewed Presentations

  • Information@Oxford for postgraduates Judith Pinfold Subject Librarian for

    [email protected] for postgraduates Judith Pinfold Subject Librarian for

    Endnote (c£90 from OUCS) ProCite, Reference Manager similar. RefWorks (free[to you], web-based) Zotero - free Firefox add-on. Courses available, at OUCS and in libraries. Store references in a database plus links to pdfs, pictures etc. Reformat instantly. There is a...
  • School of Computer Science Advanced Interfaces Group

    School of Computer Science Advanced Interfaces Group

    School of Computer Science Advanced Interfaces Group Extensive expertise in R&D of VR software systems and applications MAVERIK VR software downloaded by over 25,000 sites worldwide
  • Sed Euismod Risus Scelerisque Aliquet

    Sed Euismod Risus Scelerisque Aliquet

    Appropriated in a previous year's Long Bill with Capital Construction or General Funds and the institution received funding for that project; or . Appropriated in a previous year's Long Bill with Capital Construction or General Funds and the institution did...
  • Intelligent Information Retrieval - DePaul University

    Intelligent Information Retrieval - DePaul University

    Intelligent Information Retrieval. Thesaurus-Based Query Expansion. For each term, t, in a query, expand the query with synonyms and related words of . t. from the thesaurus. May weight added terms less than original query terms. Generally increases recall. May...
  • Teen Pregnancy in Kent County, MI

    Teen Pregnancy in Kent County, MI

    Sex education curriculums can assess direct measures of teen comprehension regarding pregnancy by incorporating learning tools such as term papers, presentations, and class projects. Indirect measures of teen comprehension of pregnancy in Kent County, MI would be evaluated by city...
  • Chapter 18

    Chapter 18

    Lacey Act. One of the earliest laws in the U.S. to control the trade of wildlife. First passed in 1900, the act prohibited the transport of illegally harvested game animals, primarily birds and mammals, across state lines.
  • If you always do what you always did - you'll always get what ...

    If you always do what you always did - you'll always get what ...

    If you always do what you always did - you'll always get what you always got…..Unknown If the next generation is to face the future with zest and self-confidence, we must educate them to be original as well as competent…..Mihaly...
  • United States Academic Decathlon Super Quiz Relay PowerPoint

    United States Academic Decathlon Super Quiz Relay PowerPoint

    PowerPoint Test 6 (45) Round 1. 1. The artist who represented Realism most forcefully was ... The _____ screened nearly every American film from mid-1942 to late 1943 and evaluated each for its content and perspective on the war. ......