Università degli Studi di Modena e Reggio Emilia
D1.P1: Prototipo di ambiente di ausilio al
progettista per la costruzione di una vista
globale basato su ontologie e assiomi
inter-schema
Sonia Bergamaschi, Alberto Corni,
Francesco Guerra, Maurizio Vincini
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
MOMIS Architecture
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Integration process
Local
schemata
Common
Thesaurus
Clusters
Global schema
with
mapping tables
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Example
Università degli Studi di Modena e Reggio Emilia
University source (relational)
Department(dept_code,dept_name,budget)
Research_Staff(name,e_mail,dept-code,s_code)
FK dept_code REF Department, s_code REF Section
School_Member(name,school,year,e_mail)
Section(s_code,section_name,length,room_code)
FK room_code REF Department, s_code REF Room
Room(room_code,seats_number,notes)
Tax_Position source (XML)
<!ELEMENT ListOfStudent (Student*)>
<!ELEMENT Student
(name,s_code,school_name,e_mail,tax_fee)>
<!ELEMENT name (#PCDATA)>
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Example
Università degli Studi di Modena e Reggio Emilia
Computer_Science source (object)
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)
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Source Acquisition Module
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
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
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Schema-derived relationships
Università degli Studi di Modena e Reggio Emilia
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
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Schema Derived Relationships
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Lexicon-derived relationships
Extracted from WordNet lexical database (Princeton Un.)
129625 lemma organized in 99759 synonym set (synset)
Synonymy
Polysemy
Tax_position_xml.Student.name SYN
University.School_member.name
CS.Professor NT CS.CS_Person
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Lexicon Derived Relationships
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Lexicon Derived Relationships
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Lexicon Derived Relationships
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Lexicon Derived Relationships
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Lexicon Derived Relationships
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Inferred relationships
Exploiting Description Logics techniques (ODB-Tools system)
a new set of terminological relationships are inferred
University.Research_Staff RT CS.Course
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Common Thesaurus
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Mediator global schema
Global schema generation
(interaction with ARTEMIS module):
Affinity calculation
Cluster generation
Global attributes and mapping table generation
A 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”
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Affinity tree and Cluster
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Affinity tree and Cluster
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Affinity tree and Cluster
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Mapping table example
Università degli Studi di Modena e Reggio Emilia
– 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
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Mapping table
The MOMIS project - http://www.dbgroup.unimo.it/Momis
Università degli Studi di Modena e Reggio Emilia
Mapping table
The MOMIS project - http://www.dbgroup.unimo.it/Momis