Refining semantic mappings from relational tables to ontologies

Authors:
Yuan An;Alexander 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:
SWDB'04 Proceedings of the Second international conference on Semantic Web and Databases
Year:
2004

Citing 5
Cited 8

Identifying Extended Entity-Relationship Object Structures in Relational Schemas

IEEE Transactions on Software Engineering
Schema Mapping as Query Discovery

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Representing and reasoning about mappings between domain models

Eighteenth national conference on Artificial intelligence
Fundamentals of Database Systems (5th Edition)

Fundamentals of Database Systems (5th Edition)
Translating web data

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases

Intensional associations between data and metadata

Proceedings of the 2007 ACM SIGMOD international conference on Management of data
A Formal Semantics-Preserving Translation from Fuzzy Relational Database Schema to Fuzzy OWL DL Ontology

ASWC '08 Proceedings of the 3rd Asian Semantic Web Conference on The Semantic Web
Formal Semantics-Preserving Translation from Fuzzy ER Model to Fuzzy OWL DL Ontology

WI-IAT '08 Proceedings of the 2008 IEEE/WIC/ACM International Conference on Web Intelligence and Intelligent Agent Technology - Volume 01
Formal semantics-preserving translation from fuzzy ER model to fuzzy OWL DL ontology

Web Intelligence and Agent Systems
A database trigger strategy to maintain knowledge bases developed via data migration

EPIA'05 Proceedings of the 12th Portuguese conference on Progress in Artificial Intelligence
Reasoning of fuzzy relational databases with fuzzy ontologies

International Journal of Intelligent Systems
Construction of fuzzy ontologies from fuzzy XML models

Knowledge-Based Systems
Construction of ontologies from object-oriented database models

Integrated Computer-Aided Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

To support the Semantic Web, it will be necessary to construct mappings between legacy database schemas and ontologies. We have developed a prototype tool which starts from a simple set of correspondences from table columns to ontology components, and then helps derive algorithmically candidate logical mappings between complete tables and the ontology. We report here some refinements of this algorithm inspired by an analysis of the ways in which relational schemas are standardly derived from Extended Entity Relationship diagrams, and relate this to the main heuristic used by the Clio system [6], which maps between relational database schemas.