Relational database triggers

Abstract

A database procedure, also named a trigger, is a powerful procedural construct. It forms part of the database definition and is stored in a compiled form for efficient execution. A trigger mechanism consists of actions to enforce predefined constraints, when specific events activate the triggers. The PowerHouseStarBase relational database management system supports a state-of-the-art implementation of the trigger mechanism. These triggers can be used to enforce the relational integrity constraints, as well as application constraints and logic. They are also used to implement updatable views properly. In addition, they can be used for various aspects of database management. There are, however, shortcomings in the implementation of triggers in StarBase, some of which could be overcome by the implementation of the suggested extensions.