Skip to main content
Article
Updating Relational Views Using Knowledge at View Definition and View Update Time
Information Systems
  • James A. Larson
  • Amit P. Sheth, Wright State University - Main Campus
Document Type
Article
Publication Date
1-1-1991
Abstract

Updating a view requires deriving a translation which converts an update on a view into updates on underlying relations. We present a pragmatic approach that uses syntactic as well as semantic knowledge to decide an appropriate translation. The semantic knowledge belongs to database and application domains and is collected at view definition time as well as at view update time. We present a rule-based approach that is applicable to simple and nested relational views defined using operations such as set difference, union, intersection, selection, projection and join operations. Our approach extends previous work by allowing more types of views, by considering more alternative translations, and most importantly, by using more types of knowledge to choose the most appropriate translation. An implementation is briefly described along with a detailed example.

DOI
10.1016/0306-4379(91)90012-X
Citation Information
James A. Larson and Amit P. Sheth. "Updating Relational Views Using Knowledge at View Definition and View Update Time" Information Systems Vol. 16 Iss. 2 (1991) p. 145 - 168 ISSN: 0306-4379
Available at: http://works.bepress.com/amit_sheth/10/