Logo image
Back
Discovering the Semantics of Relational Tables Through Mappings
Book chapter   Open access   Peer reviewed

Discovering the Semantics of Relational Tables Through Mappings

Yuan An, Alex Borgida and John Mylopoulos
Journal on Data Semantics VII, pp 1-32
2006
DOI: https://doi.org/10.1007/11890591_1
url
http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.98.2222View
SubmittedOpen Access (License Unspecified),  Open

Abstract

mappings ontologies semantic interoperability Semantics
Many problems in Information and Data Management require a semantic account of a database schema. At its best, such an account consists of formulas expressing the relationship (“mapping”) between the schema and a formal conceptual model or ontology (CM) of the domain. In this paper we describe the underlying principles, algorithms, and a prototype tool that finds such semantic mappings from relational tables to ontologies, when given as input simple correspondences from columns of the tables to datatype properties of classes in an ontology. Although the algorithm presented is necessarily heuristic, we offer formal results showing that the answers returned by the tool are “correct” for relational schemas designed according to standard Entity-Relationship techniques. To evaluate its usefulness and effectiveness, we have applied the tool to a number of public domain schemas and ontologies. Our experience shows that significant effort is saved when using it to build semantic mappings from relational tables to ontologies.

Metrics

16 Record Views
19 citations in Web of Science
32 citations in Scopus

Details

InCites Highlights

Data related to this publication, from InCites Benchmarking & Analytics tool:

Collaboration types
Domestic collaboration
International collaboration
Web of Science research areas
Computer Science, Theory & Methods
Logo image