• No results found

Collaborative Metadata Management

N/A
N/A
Protected

Academic year: 2021

Share "Collaborative Metadata Management"

Copied!
29
0
0

Loading.... (view fulltext now)

Full text

(1)

Collaborative Metadata

Management

Binzmühlestrasse 14, CH-8050 Zürich

e-mail: [email protected], 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?

References

Related documents

21 Therefore, the additional experiment (Experiment 4) was performed to investigate the effect of bisulfite concentration in the TPN solution con- taining both lipid

Helsana Supplementary Insurances Ltd and the other companies in the Helsana Group handle the personal information of insured persons for the purposes of contractual processing and

The responsible call center agents received a one-day training to be informed about the accompanying marketing activities and to get an overview over the process steps the

You can apply in person at any New York State Department of Motor Vehicles office that processes driver license transactions.. Vision Registry provider is valid for

Agent User Agent Message Transfer Agent POP3 SMTP SMTP Internet Lehrstuhl für Informatik 4. Kommunikation und verteilte Systeme SMTP -

If the FTP client requests a file, then it first selects a random port B, sets up a data transfer process and tells the server the port number by using the control connection. The

Agent Agent User User Agent Message Transfer Agent User Agent User Agent User Agent User Agent Message Transfer Agent POP3 SMTP SMTP Internet Lehrstuhl für Informatik

The nitration reactions can be readily carried out by placing the nitrating agents, phenols (1 or 4) and the solvent used in a reaction vessel and efficiently stirring the