Università degli Studi di Modena e Reggio Emilia The MOMIS project - Sonia Bergamaschi, Alberto...

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a

The MOMIS project - http://www.dbgroup.unimo.it/Momis

Sonia Bergamaschi, Alberto Corni, Francesco Guerra, Maurizio Vincini

D1.P1: Prototipo di ambiente di ausilio al progettista per la costruzione di una

vista globale basato su ontologie e assiomi

inter-schema

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


MOMIS Architecture

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Integration process

Localschemata

CommonThesaurus

Clusters

Global schemawith

mapping tables

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Example

Department(dept_code,dept_name,budget) Research_Staff(name,e_mail,dept-code,s_code)

FK dept_code REF Department, s_code REF SectionSchool_Member(name,school,year,e_mail)Section(s_code,section_name,length,room_code)

FK room_code REF Department, s_code REF RoomRoom(room_code,seats_number,notes)

<!ELEMENT ListOfStudent (Student*)><!ELEMENT Student

(name,s_code,school_name,e_mail,tax_fee)><!ELEMENT name (#PCDATA)>

University source (relational)

Tax_Position source (XML)

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


CS_Person(first_name,last_name) Professor:CS_Person(belongs_to:Division,rank)Student:CS_Person(year,takes:set<Course>,rank,e_mail)Division(description,address:Location)Location(city,street,number,country)Course(course_name,tought_by:Professor)

Computer_Science source (object)

Example

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Source Acquisition Module

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Common Thesaurus (Domain Ontology)

Set of terminological relationships between classes and attributes names (terms)

expresses both intra-schema and inter-schema knowledge

Relationships added to Common Thesaurus:(1) schema derived(2) lexicon derived(3) designer supplied(4) inferred exploiting ODB-Tools capabilities

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Schema-derived relationships

Terminological and extensional intra-schema relationships

RT relationships derived from foreign keys in a relational schema

UNI.Section RT UNI.Department

BT/NT relationships derived from inheritance relationships in a object-oriented

schema or integrity constraints in relational schema

CS.Student NT CS.CS_Person CS.Professor NT CS.CS_Person

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Schema Derived Relationships

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Lexicon-derived relationships

Extracted from WordNet lexical database (Princeton Un.)129625 lemma organized in 99759 synonym set (synset)

SynonymyPolysemy

Tax_position_xml.Student.name SYN University.School_member.name

CS.Professor NT CS.CS_Person

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Lexicon Derived Relationships

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Inferred relationships

Exploiting Description Logics techniques (ODB-Tools system) a new set of terminological relationships are inferred

University.Research_Staff RT CS.Course

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Common Thesaurus

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Mediator global schema

Global schema generation (interaction with ARTEMIS module):

Affinity calculationCluster generationGlobal attributes and mapping table

generationA global class gci is generated for each cluster Cli

SI-Designer builds the attributes set to be associated to the cluster:

–Union of the attributes of all classes belonging to the cluster–Fusion of “similar attributes”

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Affinity tree and Cluster

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Mapping table example– each global class includes mapping rules between global and local attributes (and/or relationships, default/null values)

– a mapping is generated for each global class gci

Univ

ers

ità d

eg

li S

tud

i di M

od

ena e

Regg

io E

mili

a


Mapping table

Università degli Studi di Modena e Reggio Emilia The MOMIS project - Sonia Bergamaschi, Alberto...

Documents

Transcript of Università degli Studi di Modena e Reggio Emilia The MOMIS project - Sonia Bergamaschi, Alberto...