Relational to Entity-Relationship Schema Translation Using Semantic and Inclusion Dependencies

Article type: Research Article

Authors: Ling, Tok Wang^{; *} | Lee, Mong Li

Affiliations: Department of Information Systems and Computer Science, National University of Singapore, 10 Kent Ridge Crescent, Singapore 0511, Singapore

Correspondence: [*] To whom all correspondence should be addressed.

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.

DOI: 10.3233/ICA-1995-2203

Journal: Integrated Computer-Aided Engineering, vol. 2, no. 2, pp. 125-145, 1995