Updating relational databases through views No ties dating com

In database theory, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.This pre-established query command is kept in the database dictionary.

The proposed scheme is 100% consistent with the relational model, but rather different from the way updating works in SQL products today.

at view update time to capture additional application semantics and database semantics, respectively.

TAILOR uses this information to select from among several alternative update translations against the base relations when the user updates a view.

Therefore, an ORDER BY clause in the view definition is meaningless; the SQL standard (SQL:2003) does not allow an ORDER BY clause in the subquery of a CREATE VIEW command, just as it is refused in a CREATE TABLE statement.

However, sorted data can be obtained from a view, in the same way as any other table — as part of a query statement on that view.