Please use this identifier to cite or link to this item: http://scholarbank.nus.edu.sg/handle/10635/99463
Title: View update in entity-relationship approach
Authors: Ling, T.W. 
Lee, M.L. 
Keywords: Entity-relationship based database management systems
View updatability
View update translation
Issue Date: May-1996
Citation: Ling, T.W.,Lee, M.L. (1996-05). View update in entity-relationship approach. Data and Knowledge Engineering 19 (1) : 135-169. ScholarBank@NUS Repository.
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.
Source Title: Data and Knowledge Engineering
URI: http://scholarbank.nus.edu.sg/handle/10635/99463
ISSN: 0169023X
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.

Page view(s)

28
checked on May 11, 2018

Google ScholarTM

Check


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.