Collaborative Metadata Management

29  Download (0)

Full text

(1)

Collaborative Metadata

Management

Binzmühlestrasse 14, CH-8050 Zürich

e-mail: jossen@ifi.unizh.ch, http://www.ifi.unizh.ch

Department of Informatics

University of Zurich

Database Technology

Research Group

(2)

Agenda

Motivation

Metadata Management

Metadata Management System

(MDMS)

Metadata Workflow

Collaborative Metadata Management

(3)

Motivation

Joint work with the largest Swiss Health

Insurance Company: Helsana

Ca. 2 Million Customers

New Data Warehouse

Introducing SOA / SCA

Well-established Processmanagement

Problem: No central and standardized

(4)

Agenda

Motivation

Metadata Management

Metadata Management System

(MDMS)

Metadata Workflow

Collaborative Metadata Management

(5)
(6)
(7)

Metadata Management II

(8)

Agenda

Motivation

Metadata Management

Metadata Management System

(MDMS)

Metadata Workflow

Collaborative Metadata Management

(9)

Metadata-Dimensions

Model

Subject Area

Entity

a

ta

H

ie

ra

rc

h

y

Dimension 3: Abstraction

Sources

Data Warehouse

Reporting

Enterprise Information Model

Model

Subject Area

Entity

Attribute

Model

Subject Area

Entity

Attribute

Model

Subject Area

Entity

Attribute

Model

Subject Area

Entity

Attribute

Dimension 2: Data Flow

D

im

e

n

s

io

n

1

:

D

a

Model

Subject Area

Entity

Attribute

(10)

Metamodel – Data schema

<rdf:Description rdf:about=http://www.helsana.ch/mdm/models/BDWH>

<rdf:li>

<rdf:Description rdf:about=http://www.helsana.ch/mdm/entities/adr>

<rdf:li>

<rdf:Description rdf:about=http://www.helsana.ch/mdm/attributes/adr/sprache_c>

<mdmErwin:ParentAttribute rdf:resource=http://www.helsana.ch/mdm/attributes/adr_typ/sprache_c/>

<mdmERwin:Code rdf:resource=http://www.helsana.ch/mdm/code_templates/bdwh/sprache_c/>

</rdf:Description>

</rdf:li>

</rdf:li>

</rdf:Description>

</rdf:li>

</rdf:Description>

(11)

Metamodel - ETL

<rdf:Description rdf:about=http://www.helsana.ch/mdm/transformations/SourceDB1001>

<mdmETL:Type>S</mdmETL:Type>

<mdmETL:Step rdf:resource=http://www.helsana.ch/mdm/steps/SourceDB1001_1>

</rdf:Description>

<rdf:Description rdf:about=http://www.helsana.ch/mdm/steps/SourceDB1001_1>

<mdmETL:Source rdf:resource=http://www.helsana.ch/mdm/attributes/T_D H_RECH/sender_ean/>

<mdmETL:Source rdf:resource=http://www.helsana.ch/mdm/attributes/T_DH_RECHPOS/ean_responsible/>

<mdmETL:Target rdf:resource=http://www.helsana.ch/mdm/attributes/ean/ean/>

</rdf:Description>

</rdf:Description>

L: Lookup

C: Case

B: Calculation

S: Standard

G: Generated

(12)

Metamodel – Information model

<rdf:Description rdf:about=http://www.helsana.ch/mdm/entities/InfoModel/Adresse>

<mdmInfo:Definition>Die Adresse eines Partners…</mdmInfo:Definition>

<rdfs:SubClassOf rdf:resource= http://www.helsana.ch/mdm/entities/InfoModel/Partner>

</rdf:Description>

<rdf:Description rdf:about=http://www.helsana.ch/mdm/entities/adr>

<rdfs:type rdf:resource= http://www.helsana.ch/mdm/entities/InfoModel/Adresse>

<rdfs:type rdf:resource= http://www.helsana.ch/mdm/entities/InfoModel/Adresse>

</rdf:Description>

(13)

Metamodel - Overview

Http://www.helsana.ch/mdm/models/ Http://www.helsana.ch/mdm/entities/ mdmERwin:File_Name mdmERwin:File_Name mdmERwin:Model_Mart_Path Http://www.helsana.ch/mdm/attributes/ mdmERwin:Entity mdmERwin:Definition mdmERwin:Note Http://www.helsana.ch/mdm/domains/ Http://www.helsana.ch/mdm/subject_areas/ mdmERwin:Note_2 mdmERwin:Note_3 mdmERwin:Subject_Area mdmERwin:Definition mdmERwin:Referenced_Entities mdmERwin:UDP mdmERwin:Logical Only mdmERwin:Domain mdmERwin:Domain_Name mdmERwin:Type mdmERwin:Datatype mdmERwin:Logical_Datatype Http://www.helsana.ch/mdm/key_groups/ Http://www.helsana.ch/mdm/udp_definition_groups/ mdmERwin:Logical_Only mdmERwin:Physical_Name mdmERwin:Comment mdmERwin:Database mdmERwin:Physical_Only mdmERwin:Index_Generate mdmERwin:UDP_Row_Count mdmERwin:Type mdmERwin:View_With_Check mdmERwin:View_Where mdmERwin:View_Group_By mdmERwin:View_Having mdmERwin:View_Order_By mdmERwin:Attribute mdmERwin:Domain mdmERwin:Logical_Only mdmERwin:Definition mdmERwin:Note mdmERwin:UDP mdmERwin:Physical_Name mdmERwin:Datatype mdmERwin:Not_Null mdmERwin:Physical_Only mdmERwin:Comment mdmErwin:Physical_Order mdmErwin:Parent_Attribute mdmERwin:Physical_Name mdmERwin:Key_Group_Type mdmERwin:Index_Generate mdmERwin:Index mdmERwin:UDP_Definition mdmERwin:Type mdmERwin:Definition Http://www.helsana.ch/mdm/code_templates/ mdmERwin:Database mdmERwin:Query mdmERwin:Template mdmErwin:Code Http://www.helsana.ch/mdm/code_mappings/ mdmERwin:Source mdmERwin:Target

(14)

Architecture of the MDMS

MDMS User

Web Service Container

Relational Database

Java Web Container

SOAP

HTTP

SeRQL / SPARQL

Data Modelling Application

Local Model Manager

XMI files

SOAP

(15)
(16)

Agenda

Motivation

Metadata Management

Metadata Management System

(MDMS)

Metadata Workflow

Collaborative Metadata Management

(17)
(18)

(Meta-) Model-Operators I

µ

µ

µ

µ

(19)

(Meta-) Model-Operators II

στ

στ

στ

στ

(20)

(Meta-) Model-Operators III

µ

µ

µ

µ

: Transforms a simple RDF-Graph into a

versioned and authoring related RDF-Graph

σ

σ

σ

σ

: select - match - operator, returns an

integrated Graph out of two input

integrated Graph out of two input

RDF-Graphs, where one of them has to be

generated from the other by

µ.

τ

τ

τ

τ

: Reduces a versioned (temporal)

(21)

Agenda

Motivation

Metadata Management

Metadata Management System

(MDMS)

Metadata Workflow

Collaborative Metadata Management

(22)

Collaborative Approaches

Social Sciences:

Communities of Practice (CoP)

Computer Science:

Web 2.0: Social Software

Web 2.0: Social Software

(23)

Communities of Practice (CoP)

intra-/inter-organizational community

synchronous / ansynchronous

distributed

domain-based

no timetable

no timetable

self-organizing

(24)

(Semantic) Social Software

Forum -> thread-based

Blog -> documentation

Wiki -> versioned authoring

Portal -> information/application

integration

integration

And the winner is …

(25)
(26)

Agenda

Motivation

Metadata Management

Metadata Management System

(MDMS)

Metadata Workflow

Collaborative Metadata Management

(27)

Conclusion

The MDMS is now a stable and productive

application with a growing number of users

Implementation of the metadata authoring part

still needs to be done

In theory the wiki-approach fits the business

requirements -> let’s see what the users will do

with it…

(28)

Further Research

Integration of Service-Metadata:

RDF(S) und SOA (SAWSDL)

Connection and Visualization of Business

Processes (BPEL)

Processes (BPEL)

Upgrade to a full Knowledge Management

Portal (IT, Processes, Organization)

(29)

Questions? Comments?

Wer sonst hat

Wer sonst hat

soviele

soviele

Metadaten?

Metadaten?

Metadaten?

Metadaten?

Figure

Updating...

References

Related subjects : metadata management