arrow
Return

On the relational representation of complex specialization structures

delete2000-09-01
delete3
PRE
AI
D
da Silva, AS *
A
Alberto H. F. Laender
M
Marco A. Casanova
DOI:10.1016/S0306-4379(00)00025-9delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
The mapping of entity-relationship schemas (ER schemas) that contain complex specialization structures into the relational model requires the use of specific strategies to avoid inconsistent states in the final relational database. In this paper, we show that for this mapping to be correct it is required to enforce a special kind of integrity constraint, the key pairing constraint (KPC). We present a mapping strategy that use simple inclusion dependencies to enforce KPC and show that this strategy can be used to correctly map specialization structures that are more general than the simple specialization structures considered by previous strategies. (C) 2000 Published by Elsevier Science Ltd.
Keywords:
ER model
relational database design
specialization structures
integrity constraints
AI Summary

AI Summary

Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.

Journal

Enterprise Information Systems cover
Enterprise Information Systems
IF:
3.9
Papers:
2.8K
Citations:
1.8K

Organization

No organization information available