View updating in practice?
Date: 08 Nov 2002 15:18:07 +0100
Message-ID: <m2of9087s0.fsf_at_pcwi1068.uni-muenster.de>
Dear reader,
Personally, I believe that view updates are dangerous in most situations as users cannot understand what is going on. To give two simple examples: In case of deletions from projections, users delete tuples they do not know completely. In case of insertions into joins, users do not know whether they are actually inserting into both operand relations or whether there was a dangling tuple in any of the operand relations that gets "absorbed" by the newly inserted tuple. It is easy to see that users will not be able to undo their view updates (such that the old _database_ state is reached) using further view updates in the above situations. If a was a user of such a database I would be very irritated.
I wrote a paper on this topic for ICDT'03. (Take a look at http://dbms.uni-muenster.de/publications/downloads/view-updates.pdf if you are interested in the details.) Unfortunately, the paper got rejected, but I'm not convinced by the reviewers' critique ;) Now, I would like to know what people do in practice. My questions are as follows:
- Do you use view updates? What is the scenario?
- If you do _not_ use view updates, did you at least think about using them? If so, what was the application scenario and why did you not implement it (e.g., no support by DBMS or too complicated
for users)?- Does anybody use SQL:1999 INSTEAD triggers to implement view
updates?
I would be delighted if anybody out there was willing to share their experiences with me.
Thanks in advance,
Jens
Follow-up set to: comp.databases.theory Received on Fri Nov 08 2002 - 15:18:07 CET