Updating relational databases through views

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.

Unlike ordinary base tables in a relational database, a view does not form part of the physical schema: as a result set, it is a virtual table computed or collated dynamically from data in the database when access to that view is requested.

Microsoft SQL Server introduced in its 2000 version indexed views which only store a separate index from the table, but not the entire data. That means they should be updatable, just as "real" or base tables are. To purchase books, visit Amazon or your favorite retailer. See our FAQ or contact customer service: 1-800-889-8969 / [email protected]/Submit Errata Views are virtual tables.In some No SQL databases, views are the only way to query data.Views can provide advantages over tables: Just as a function (in programming) can provide abstraction, so can a database view.Read-only views do not support such operations because the DBMS cannot map the changes to the underlying base tables. Some systems support the definition of INSTEAD OF triggers on views.

You must have an account to comment. Please register or login here!