View updates for an extended entity-relationship model

https://doi.org/10.1016/0020-0255(92)90024-3Get rights and content

Abstract

Recently, several graphical query languages have emerged that allow users to manipulate a database schema with diagram-manipulation operators until the modified schema represents the view of the data that satisfies a user query. The research in this area has also shown how updates can be graphically specified and how updates propagate for various semantic models. In this paper we continue this work by investigating view definition and view updates for an extended entity-relationship model. We define views by invoking diagram-manipulation operators to transform an original schema into a view schema. Our diagram-manipulation operators have an object-traceability property that allows us to trace the identity of any entity object in any view to a unique entity object in the underlying database and to trace the identity of any relationship object in any view either to a unique relationship object or to a unique set of component relationship objects in the underlying database. Based on object traceability, we define and discuss properties of update operators to modify, insert, and delete objects in views.

References (25)

  • D.M. Campbell et al.

    Graphical query formulation for an entity-relationship model

    Data & Knowledge Eng.

    (June 1987)
  • R. Elmasri et al.

    The category concept: An extension to the entity-relationship model

    Data & Knowledge Eng.

    (June 1985)
  • F. Bancilhon et al.

    Update semantics of relational views

    ACM Trans. Database Systems

    (Dec. 1981)
  • D. Bryce et al.

    snap: A graphics-based schema manager

  • D.M. Campbell et al.

    A relationally complete query language for an entity-relationship model

  • P.P. Chen

    The entity-relationship model—toward a unified view of data

    ACM Trans. Database Systems

    (Mar. 1976)
  • S.S. Cosmadakis et al.

    Updates of relational views

    J. Assoc. Comput. Mach.

    (Oct. 1984)
  • B. Czejdo et al.

    An algebra for an entity-relationship model and its application to graphical query processing

  • D. Czejdo et al.

    Graphical query formulation by manipulating relational schema diagrams

    Systems Sci.

    (1986)
  • B. Czejdo et al.

    An approach to computation specification for an entityrelationship query language

  • B. Czejdo et al.

    An algebraic language for graphical query formulation using an extended entity-relationship model

  • B. Czejdo et al.

    Semantics of update operations for an extended entity-relationship model

    • Cited by (3)

    • View update in entity-relationship approach

      1996, Data and Knowledge Engineering

    • Solving the problem of semantic heterogeneity in defining mediator update translators

      1999, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

    • Operators in an extended entity-relationship model and their applications

      1997, Proceedings - 35th Annual Southeast Regional Conference, ACM-SE 1997
    View full text
    Copyright © 1992 Published by Elsevier Inc.