Copyright © 1996 Published by Elsevier Science B.V.
Paper
View update in entity-relationship approach
Received 20 May 1994;
References and further reading may be available for this article. To view references and further reading you must purchase this article.
Abstract
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 [1] where the conceptual schema is represented by a normal form ER diagram [2] 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 updates on the conceptual schema. Concepts such as virtual updates and three types of insertability are introduced. We also present two algorithms, the View Updatability Algorithm and the View Update Translation Algorithm.
Author Keywords: Entity-Relationship based database management systems; View Updatability; View Update Translation







E-mail Article
Add to my Quick Links

Cited By in Scopus (1)






