Please use this identifier to cite or link to this item: http://scholarbank.nus.edu.sg/handle/10635/99400
Title: Relational to entity-relationship schema translation using semantic and inclusion dependencies
Authors: Ling, Tok Wang 
Lee, Mong Li 
Issue Date: 1995
Source: Ling, Tok Wang,Lee, Mong Li (1995). Relational to entity-relationship schema translation using semantic and inclusion dependencies. Integrated Computer-Aided Engineering 2 (2) : 125-145. ScholarBank@NUS Repository.
Abstract: When a database is to be interoperated with others, its schema must first be converted to the canonical model of the federated system. This implies a knowledge acquisition process to upgrade the semantics of the local schema. This article addresses the problem of translating relational schemas to a semantically rich entity-relationship (ER) model. We introduce a concept called semantic dependency, which we define formally in both the ER and relational models. We use this concept to semantically enrich a relational schema before translating it to the corresponding ER schema. We show that using the concept of semantic dependency in addition to inclusion dependency, functional dependency, and multivalued dependency will result in a more accurate relational to ER schema translation.
Source Title: Integrated Computer-Aided Engineering
URI: http://scholarbank.nus.edu.sg/handle/10635/99400
ISSN: 10692509
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.

Page view(s)

45
checked on Apr 20, 2018

Google ScholarTM

Check


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.