Re: question: approaches to view update problem

From: Joe Celko <71062.1056_at_compuserve.com>
Date: 2000/06/27
Message-ID: <8j93u1$dgp$1_at_nnrp1.deja.com>#1/1


>> An interesting list of references. Date also has a discussion of
WITH CHECK OPTION in one of his SELECTED WRITINGS series. <<

I have a pretty good chapter in one of my books, too.

>> Much more interesting is Date's treatment of UNION, INTERSECT and
DIFFERENCE views in the 1991-1994 book (work done with David McGoveran). Interestingly, this book is not listed at Amazon, not even as out of print. My copy is at home or I'd give the ISBN, etc. ... I believe you'd find this to be what Date regards as his current beliefs on view updating. They seem cogent and valid to me. <<

The basic idea is that if you can logically map from the VIEW to a base table in a consistent fashion, then you can update it. It is a semantic rather than a syntax approach.

>> Do you happen to know where article such as Goodman's INFODB one are
available online? <<

Not that I know of ..

--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 Tue Jun 27 2000 - 00:00:00 CEST

Original text of this message