Rule-based logical views

Previous Next

Views present data from one or more tables to the user in some way that is attractive to business users, but departs from the underlying table structure in which the data is actually stored. Unfortunately, you cannot always automatically manipulate data in views in the same way as in the underlying tables.

Rule-based Logical Views solve this. They let you determine what should happen when a user manipulates the view. You do this by declaring special rules that execute when a user performs the DML action via the view. This way, you take command of some or all of the DML actions (insert, update, delete) that users perform through the view.

For example, you can make sure that when a user inserts a record in a Logical View, this action is translated by the special rules into multiple insert operations into two or more different underlying tables.

 

 

collapseFlagging a rule-based logical view
collapseDeclaring underlying rules

 

See also

Logical views

How to define a rule-based logical view

Example: Rule-based logical view