ScienceDirect® Home Skip Main Navigation Links
You have guest access to ScienceDirect. Find out more.
 
Home
Browse
My Settings
Alerts
Help
 Quick Search
 Search tips (Opens new window)
    Clear all fields    
advertisementadvertisement
Data & Knowledge Engineering
Volume 19, Issue 2, 1 June 1996, Pages 135-169
 
Font Size: Decrease Font Size  Increase Font Size
 Abstract - selected
Purchase PDF (2303 K)

 
 
 
Related Articles in ScienceDirect
View More Related Articles
 
View Record in Scopus
 
doi:10.1016/0169-023X(95)00042-Q    How to Cite or Link Using DOI (Opens New Window)
Copyright © 1996 Published by Elsevier Science B.V.

Paper

View update in entity-relationship approach

Tok Wang LingCorresponding Author Contact Information, E-mail The Corresponding Author and Mong Li Lee

Department of Information Systems & Computer Science, National University of Singapore, 10 Kent Ridge Crescent, Singapore 0511, Singapore

Received 20 May 1994; 
revised 18 August 1995; 
accepted 20 November 1995. ;
Available online 3 August 2001.

Purchase the full-text article



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

Article Outline

• References

 
Home
Browse
My Settings
Alerts
Help
Elsevier.com (Opens new window)
About ScienceDirect  |  Contact Us  |  Information for Advertisers  |  Terms & Conditions  |  Privacy Policy
Copyright © 2008 Elsevier B.V. All rights reserved. ScienceDirect® is a registered trademark of Elsevier B.V.