[cap-talk] capabilities for databases and database-like systems

[John Carlson]

>> 2. In most DB systems, There are restrictions on the operations that can
>> be performed using views. That is, views were added as an afterthought
>> rather than as an essential model.
>
>
> The restrictions on operations that can be performed on views are
> essential to the function of views, not just some omission because
> views are an "afterthought".  In particular views can be composed
> of joins of other tables.  If one is then going to update a view, which
> table or what from the tables gets updated?
>
You can put the keys to the underlying table in the view, and then
the underlying tables will get updated.  At least according to one
Oracle expert I talked to.  I've never tried it myself.

John