View updates in relational databases with an independent scheme

Rom Langerak*

*Corresponding author for this work

    Research output: Contribution to journalArticleAcademicpeer-review

    38 Citations (Scopus)
    6 Downloads (Pure)

    Abstract

    A view on a database is a mapping that provides a user or application with a suitable way of looking at the data. Updates specified on a view have to be translated into updates on the underlying database. We study the view update translation problem for a relational data model in which the base relations may contain 1990 nulls. The representative instance is considered to be the correct representation of all data in the database; the class of views that is studied consists of total projections of the representative instance. Only independent database schemes are considered, that is, schemes for which global consistency is implied by local consistency. A view update can be an insertion, a deletion, or a modification of a single view tuple. It is proven that the constant complement method of Bancilhon and Spyratos is too restrictive to be useful in this context. Structural properties of extension joins are derived that are important for understanding views. On the basis of these properties, minimal algorithms for translating a single view-tuple update are given.

    Original languageEnglish
    Pages (from-to)40-66
    Number of pages27
    JournalACM transactions on database systems
    Volume15
    Issue number1
    DOIs
    Publication statusPublished - 3 Jan 1990

    Fingerprint

    Dive into the research topics of 'View updates in relational databases with an independent scheme'. Together they form a unique fingerprint.

    Cite this