Re: question: approaches to view update problem
Date: 2000/06/23
Message-ID: <8j0t09$raa$1_at_nnrp1.deja.com>#1/1
Date, C. J.; RELATIONAL DATABASE: SELECTED WRITINGS; "Updating VIEWs";
(ISBN 0-201-14196-5).
Goodman, Nathan; INFODB Vol 5, No 2 (Summer 1990); "VIEW Update is
Practical".
Umeshar, Dayal & P. A. Bernstein; ACM TRANSACTIONS ON DATABASE SYSTEMS
Vol 7, No 3 (Dec 1982); "On the Correct Translation of Update
Operations on Relational VIEWs".
Another feature, which is not used enough, is the WITH CHECK OPTION
clause on a VIEW. It is a bit tricky, but if you would like I can post
a section from SQL FOR SMARTIES on this feature.
--CELKO--
Joe Celko, SQL and Database Consultant
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc)
which can be cut and pasted into Query Analyzer is appreciated.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Jun 23 2000 - 00:00:00 CEST