Title :
A partition model approach to updating universal scheme interfaces
Author :
Laurent, Dominique ; Spyratos, Nicolas
Author_Institution :
Dept. de Math. et Inf., Univ. d´´Orleans, France
fDate :
4/1/1994 12:00:00 AM
Abstract :
The updating of relational databases has received extensive attention in the past few years. However, the various methods proposed present two main drawbacks: either the method cannot perform some update because of nondeterminism, or the method is deterministic but leads to counterintuitive results. In this paper, we use partition semantics to study updating in universal scheme interfaces. It is shown that, contrary to other approaches, the main difficulties are due to nondeterminism of deletions. We characterize when a deletion is deterministic or not, and we show how partition semantics allow for choices in certain cases of nondeterminism
Keywords :
database theory; relational algebra; relational databases; counterintuitive results; deletions; functional dependency; nondeterminism; partition model; partition semantics; relational database updating; relational model; universal relation; universal scheme interface updating; Inference mechanisms; Relational databases; Spatial databases; Unemployment;
Journal_Title :
Knowledge and Data Engineering, IEEE Transactions on