• DocumentCode
    1055875
  • 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
  • Volume
    6
  • Issue
    2
  • fYear
    1994
  • fDate
    4/1/1994 12:00:00 AM
  • Firstpage
    316
  • Lastpage
    330
  • 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;
  • fLanguage
    English
  • Journal_Title
    Knowledge and Data Engineering, IEEE Transactions on
  • Publisher
    ieee
  • ISSN
    1041-4347
  • Type

    jour

  • DOI
    10.1109/69.277774
  • Filename
    277774