Updating Relational Views Using Knowledge at View Definition and View Update Time

TitleUpdating Relational Views Using Knowledge at View Definition and View Update Time
Publication TypeJournal Article
Year of Publication1991
AuthorsAmit Sheth, J. Larson
JournalInformation Systems: An International Journal
Keywordsintegration, semantic integrity constraints, view update
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.

Full Text

J. Larson and A. P. Sheth, 'Updating Relational Views Using Knowledge at View Definition and View Update Time,'Information Systems: An International Journal 16 (no. 2), 1991.

related resource url: http://scholar.google.com/citations?view_op=view_citation&hl=en&user=2T3...