Discovering the semantics of relational tables through mappings

Authors:
Yuan An;Alex Borgida;John Mylopoulos
Affiliations:
Department of Computer Science, University of Toronto, Canada;Department of Computer Science, Rutgers University;Department of Computer Science, University of Toronto, Canada
Venue:
Journal on Data Semantics VII
Year:
2005

Citing 16
Cited 12

Identifying Extended Entity-Relationship Object Structures in Relational Schemas

IEEE Transactions on Software Engineering
Data model and query evaluation in global information systems

Journal of Intelligent Information Systems - Special issue: networked information discovery and retrieval
Database Management Systems

Database Management Systems
Logic-based techniques in data integration

Logic-based artificial intelligence
Sweetening Ontologies with DOLCE

EKAW '02 Proceedings of the 13th International Conference on Knowledge Engineering and Knowledge Management. Ontologies and the Semantic Web
A Method for Transforming Relational Schemas Into Conceptual Schemas

Proceedings of the Tenth International Conference on Data Engineering
Query Folding

ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
Schema Mapping as Query Discovery

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Answering queries using views: A survey

The VLDB Journal — The International Journal on Very Large Data Bases
A survey of approaches to automatic schema matching

The VLDB Journal — The International Journal on Very Large Data Bases
On deep annotation

WWW '03 Proceedings of the 12th international conference on World Wide Web
OBSERVER: An Approach for Query Processing in Global Information Systems based on Interoperation across Pre-existing Ontologies

COOPIS '96 Proceedings of the First IFCIS International Conference on Cooperative Information Systems
iMAP: discovering complex semantic matches between database schemas

SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Answering queries using views: A KRDB perspective for the semantic Web

ACM Transactions on Internet Technology (TOIT)
Translating web data

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Inferring complex semantic mappings between relational tables and ontologies from simple correspondences

OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, COA, and ODBASE - Volume Part II

Maintaining Semantic Mappings between Database Schemas and Ontologies

Semantic Web, Ontologies and Databases
Round-Trip Engineering for Maintaining Conceptual-Relational Mappings

CAiSE '08 Proceedings of the 20th international conference on Advanced Information Systems Engineering
A Conceptual Modeling Framework for Expressing Observational Data Semantics

ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Towards a Compositional Semantic Account of Data Quality Attributes

ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Discovering Semantically Similar Associations (SeSA) for Complex Mappings between Conceptual Models

ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
A gauss function based approach for unbalanced ontology matching

Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Accessing and Documenting Relational Databases through OWL Ontologies

FQAS '09 Proceedings of the 8th International Conference on Flexible Query Answering Systems
Relationalization of provenance data in complex RDF reification nodes

Electronic Commerce Research
Automatic normalization and annotation for discovering semantic mappings

Search computing
Maintaining Mappings between Conceptual Models and Relational Schemas

Journal of Database Management
Bringing relational databases into the semantic web: a survey

Semantic Web
Bringing relational databases into the Semantic Web: A survey

Semantic Web - On real-time and ubiquitous social semantics

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.