A theory for Entity-Relationship view updates [chapter]

Tok -Wang Ling, Mong -Li Lee
1992 Lecture Notes in Computer Science  
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
more » ... rom view updates into conceptual schema updates. Concepts such as virtual updates and three types of insertability are introduced.
doi:10.1007/3-540-56023-8_17 fatcat:jtjin4jecrhefev3ue24nriya4