View Updating And Relational Theory
By C J Date
Language: English
Category: Ebook - Computer/Internet
Categories: Computer/Internet
Uploader: fgxn
Uploaded At: 2013-01-25 11:51:37
C. J. Date introduces a method for updatable views based on the foundations of the relational model
Description
Views are "virtual" tables. That means they should be updatable, just as "real" or base tables are. In fact, view updatability isn't just desirable, it's "crucial," for practical reasons as well as theoretical ones. But view updating has always been a controversial topic. Ever since the relational model first appeared, there has been widespread skepticism as to whether (in general) view updating is even possible...this book shows how views, just like base tables, can "always" be updated (so long as the updates don't violate any integrity constraints). More generally, it shows how updating "always" ought to work, regardless of whether the target is a base table or a view. The proposed scheme is 100% consistent with the relational model, but rather different from the way updating works in SQL products today.