A theory for Entity-Relationship view updates

0
160

Authors: Mong Li Lee, Tok Wang Ling

Tags: 1992, conceptual modeling

The traditional problem of updating relational databases through views is an important practical problem that has attracted much interest. In this paper, we examine the problem of view update in Entity-Relationship based database management systems [17] where the conceptual schema is represented by a normal form ER diagram [16] and views may be modelled by ER diagrams. We develop a theory within the framework of the ER approach that characterizes the conditions under which there exist mappings from view updates into conceptual schema updates. Concepts such as virtual updates and three types of insertability are introduced.

Read the full paper here: https://link.springer.com/chapter/10.1007/3-540-56023-8_17