Database views are, in my opinion, the single most important virtualization tool the DBA has, and many of my previous writings extol the importance and value of using views in the database. Among the many benefits of views are the following:
· They can support multiple application-specific views of data, without having to modify the underlying database schema.
· They enable the decoupling of application code (and application objects) from the database schema. Changes can be made to the schema without breaking existing applications; views can also be used to transition applications from one view of the data to another.
· They can be given application-specific data names, lengths and datatypes, which can map directly ...