Agenda

1
(No Transcript)
2
Agenda

• Objective of this Presentation Introductions
• Overview of referenced ISO/OMG standards and
  specifications
• The OSFI Metadata Repository Connection
• OSFI Business and Technical Reference Models
• Detail Walkthrough of multi-metadata models
  involved
• Wrap-up

3
Objectives of this presentation

• Use Case of metadata repository implementation in
  progress at OSFI
• Show how multiple metadata models were defined
  and used towards the procurement and
  implementation of a metadata repository
• Showcase the span of metadata and data management
  standards that contributed to this effort

4
Office of the Superintendent of Financial
Institutions (OSFI), Canada

• The primary regulator and supervisor of
• all banks in Canada,
• all federally incorporated or registered
• trust and loan companies,
• insurance companies,
• co-operative credit associations,
• fraternal benefit societies and
• federally administered pension plans.
• Its mission is to safeguard policy holders,
  depositors and pension plan members from undue
  loss

5
Baba Piprani Consultant, SICOM, Canada

• Over 25 years of experience and involvement in
  Metadata/Database Standards and Data Management
• Canadian Delegate in ISO SQL (WG3) and Metadata
  Working Groups (WG2)
• Past Chair of ISO Conceptual Schema WG and Govt.
  of Canada Treasury Board IT Standards (TBITS SQL)
• Author of several publications
• Highly successful DW and metadata based
  implementations

6
Ginette Levesque Hansma, OSFI, Canada

• Over 20 years of Data Management
• Data Architecture Group manager
• Overseeing the implementation of the Metadata
  Repository at OSFI
• Initiated Enterprise Data Controls that include
  data standards, data warehouse standards and
  enterprise control lists (value domains)
• Actively promote Enterprise Data Architecture
  with emphasis on data quality and data integrity

7
The ISO/IEC 11179 Metadata Registries standard
consists of 6 parts

• Part 1 - Framework
• Part 2 - Classification
• Part 3 - Registry metamodel and basic attributes
• Part 4 - Formulation of data definitions
• Part 5 - Naming and identification principles
• Part 6 - Registration
• Part 1 explains the purpose of each part.
• Part 3 specifies the metamodel that defines the
  registry
• The other parts specify various aspects of the
  use of the registry

8
Each Data element in ISO/IEC 11179 Metadata
Registries

• should be registered according to the
  Registration guidelines (11179-6)
• will be uniquely identified within the register
  (11179-5)
• should be named according to Naming and
  Identification Principles (11179-5)
• should be defined by the Formulation of Data
  Definitions rules (11179-4)
• may be classified in a Classification Scheme
  (11179-2)

9
The ISO/IEC 19763 Framework for Metamodel
Interoperability standard consists of 4 parts

• Part 1 Reference Model
• Part 2 Core Model
• Part 3 Metamodel for Ontology Registration
• Part 4 Metamodel for Model Mapping
• Part 1 describes concepts and architecture to be
  applied in the development and registration of
  individual metamodel frameworks in other parts.
• Part 2 specifies the core model to describe
  metamodel items
• Part 3 specifies the metamodel that provides a
  facility to register administrative information
  about ontologies
• Part 4 provides a metamodel for describing
  differences in format and type of objects and
  transformation rules to be exchanged or shared

10
Common Warehouse Metamodel (CWM)
Courtesy OMG
11
CWM PACKAGES

• CWMs 4 layers describe metamodel packages that
  address the complete lifecycle of data warehouse
  applications

12
CWM Foundation Package
Sub-package Representing
Business Information package business information about model elements.
Data Types package constructs that modelers can use to create the specific data types they need.
Expressions package expression trees.
Keys and Indexes package keys and indexes.
Software Deployment package how software is deployed in a data warehouse.
Type Mapping package mapping of data types between different systems.
Courtesy Doug Mann
13
CWM Resource Package
Sub-package Representing
Relational package metadata of relational data resources.
Record package metadata of record data resources.
Multidimensional package metadata of multidimensional data resources.
XML package metadata of XML data resources.
Courtesy Doug Mann
14
CWM Analysis Package
Sub-package Representing
Transformation package metadata of data transformation tools.
OLAP package metadata of on-line analytical processing tools.
Data Mining package metadata of data mining tools.
Information Visualization package metadata of information visualization tools.
Business Nomenclature package metadata on business taxonomy and glossary.
Courtesy Doug Mann
15
CWM Management Package
Sub-package Representing
Warehouse Process package metadata of warehouse processes.
Warehouse Operation package metadata of results of warehouse operations.
Courtesy Doug Mann
16
Common Warehouse Metamodel (CWM)

• CWM allows for metadata interchange amongst
• Organizations data assets
• BI and Data Warehouse
• Knowledge management
• Services that Encompass life cycle of metadata
  including
• Analysis and Modelling
• Heterogeneous Databases and legacy systems
• ETL and mappings, transformations
• That support the managing of structured and
  unstructured data
• CWM also supports ER along with UML to enable
  integration

17
OSFIs Realization of Metadata Repository(Standar
ds based)
Topic Multi-Metadata Models Framework
Standards/Specification ISO 19763 OMG MOF
Topic OSFI Metadata
- Reference metamodels - Reference Frameworks
Standards based implementation of - OSFI
Metadata Framework - OSFI Metadata Reference
Models In OSFI Metadata Repository
- Concepts - Definitions - Designations - Data
Elements

• Reference Packages
• Multi Metadata models
• Export/Import XML XMI

Topic Data
Standards ISO 11179 Metadata Registries
Topic IM, IT, DW
Standards and Specification ISO 9075 OMG
Common Warehouse Metamodel

• - Mappings
• DB Schemas, Keys/Indexes
• Relational DB Structure
• Record Structure
• Transformation Tools
• Analytical Tools
• Data Mining Tools
• Warehouse Processes
• Warehouse operations

18
OSFI Metadata Repository - Objectives

• Technical perspective
• Easy access to accurate and complete inventory
  of information assets relevant to IT
• data models (meta data about models and
  publishable format),
• process models (meta data about models and
  publishable format),
• data base schemas (meta data about schemas and
  schema content),
• data definitions (meta data about definitions and
  all content),
• Enterprise Control Lists (ECL) (meta data about
  ECL, all their content, lexicon, thesaurus ad
  control vocabulary),
• data usage and dependencies,
• business rules (meta data about rules and all
  content),
• mappings and transformations (meta data about
  mappings and transformation and all content),
• reports and their content (meta data about
  reports and their layout).
• Capabilities to perform impact analysis of
  changes to data/applications
• Enables re-usability of assets

19
OSFI Metadata Repository - Objectives

• Business perspective
• Easy access to accurate and complete inventory
  of information assets relevant to the business
• data captured, generated and maintained at OSFI
  (submodel of ISO 11179-3),
• Business process models (meta data about models
  and publishable format),
• data definitions (meta data about definitions and
  all content),
• data usage,
• business rules (meta data about rules and all
  content),
• mappings and transformations (meta data about
  mappings and transformation and all content),
• data ownership and custodianship,
• reports and their content (meta data about
  reports and their layout).
• Capabilities to perform impact analysis of
  changes to data
• Enables efficient Change Management
• document of new requirements,
• review of proposed new information and approval,
• retirement, etc

20
OSFI Metadata Repository Overview

• Metadata Repository tool will
• Store OSFIs metadata
• Import/extract metadata from OSFI disparate
  electronic sources
• Allows direct input for new requirements
• Provide official enterprise lists and standard
  values
• Allow capabilities to manage the metadata
• Administration (access control, create links/
  dependencies, etc.)
• Validation
• Reconciliation
• Impact Analysis
• Publish metadata
• Reporting and publishing
• Queries

21
OSFI Metadata Repository Business Model
Management
Business Community
IM Data Architect
Change and Asset Management
Repository

Standards / Impact Analysis Documentation /
Change Management / Add new requirements
Asset Discovery / Documentation / Usage Guidelines
Metadata Standards
Developers
Business Analysts

Data Definitions / ECL / Impact Analyst
/ Information re-use
Asset Discovery / Impact Analysis / Information
re-use / Document new requirements
Enabling Processes and Technologies
22
Metadata Framework at OSFI
23

• OSFI Metadata Repository Overview

24

• OSFI Metadata Repository Technical Reference Model

25
Model of the OSFI Metadata Repository Technical
Reference Model
Please note Notation used in this presentation
is OSFI standard modelling notation IDEF1X
26
(No Transcript)
27
OSFI Metadata Repository Technical Reference
Model Flow Contents
Seq Source Name Target Name Meta Info Flow Name Data Model Reference for Involved Object in Meta Flow
1 Modelling Tools Repository ERWin Models CA Fusion Models MF1
2 Modelling Tools DB DB Object Declarations MF2
3 Modelling Tools DW DM DW DM Object Declarations MF3
4 Modelling Tools BI BI Object Declarations MF4
5 DB Repository DB Schema Declarations MF5
6 DB DW DM DB Schema Declarations MF6
7 DB ETL DB Mapping Declarations MF7
8 DW DM Repository DW DM Schema Declarations MF8
9 DW DM BI DW DM Schema Objects MF9
10 DW DM ETL DW DM Schema Mappings MF10
28
Seq Source Name Target Name Meta Info Flow Name Data Model Reference for Involved Objects in Meta Flow
11 ETL Repository ETL Mappings Transformation MF11
12 ETL BI Schema Views Mappings MF12
13 BI Repository Report Formats, Cubes, Schema Objects MF13
14 Manual Input Repository Pre-Model Metadata MF14
15 EDMS Repository EDMS Metadata MF15
16 WorkFlow Repository WorkFlow Metadata MF16
17 ERP Repository ERP Schema Declarations MF17
17 Admin Modules Repository Admin metadata MF18
19 Future (Emails, Documents, Thesaurus, Records) Repository Future metadata MF19
20 Future - SDLC Repository SDLC Tracking MF20
29
Contents of Meta Flow MF1 ERWin Data Models, CA
Fusion Process Models
30
(No Transcript)
31
Contents of Meta Flow MF2 DB Object
Declarations
32
(No Transcript)
33
Contents of Meta Flow MF3 DW DM Object
Declarations
34
(No Transcript)
35
Contents of Meta Flow MF4 BI Object
Declarations
36
(No Transcript)
37
Contents of Meta Flow MF5 DB Schema
Declarations
38
(No Transcript)
39
Contents of Meta Flow MF11 ETL Mappings
Transformation
40
(No Transcript)
41
Contents of Meta Flow MF13 Report Formats,
Cubes and Schema Objects
42
Risk Factors

• New Technology at OSFI
• Time and Budget constraints
• New approach at OSFI impacts current processes
  and procedures
• Industry standards for MDR just started to be
  used across industries

43
Status and Next Steps at OSFI

• Milestones completed
• Requirements (product and services) documented
  and products reviewed
• Metadata Repository initiative funded
• Input from major players in the Business
• Metadata Repository requirements approved
• Request for Proposal issued
• Metadata Repository Vendor responses received
• Next steps
• Evaluation, selection and contract (in progress)
• Develop new processes and procedures for
  Management of Metadata (in progress)
• Develop interim data holding metadata schemas and
  databases to support part of required functions
  and collection of data (in progress)
• Installation and configuration the new Metadata
  Repository
• Communication and training

44
Summary of Metadata Repository Implementation at
OSFI

• Metadata being shared
• Need to understand the meaning and context of all
  data within the enterprise
• Provide reference points for technologists and
  users
• Track information from definition, design,
  collection to delivery

45
Summary of Metadata Repository Implementation at
OSFI

• Used ISO Metadata Standards And OMG
  Specifications to stabilize requirements and
  approach (ISO 11179, ISO 19763, ISO 9075, TR9007,
  ISO 10032 (RMDM), ISO 10728 (IRDS), CWM, MOF
• Our Standards based local Metadata Framework,
  Reference Models and Data Standards have provided
  a stable platform and road map for implementation
  and integration
• Best-of-breed integration, managing data
  enterprise-wide
• Thank you ISO and OMGand OFMR(Kobe)2006 for the
  opportunity to share this presentation