The Community for Technology Leaders
RSS Icon
Subscribe
Issue No.02 - April (1994 vol.6)
pp: 316-330
ABSTRACT
<p>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.</p>
INDEX TERMS
relational databases; relational algebra; database theory; partition model; universal scheme interface updating; relational database updating; nondeterminism; counterintuitive results; partition semantics; deletions; universal relation; relational model; functional dependency
CITATION
D. Laurent, N. Spyratos, "A Partition Model Approach to Updating Universal Scheme Interfaces", IEEE Transactions on Knowledge & Data Engineering, vol.6, no. 2, pp. 316-330, April 1994, doi:10.1109/69.277774
20 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool