초록 ▼

A technique for database management includes receiving an indication of a selected scope of a trigger. The scope is selected from a plurality of scopes of database management. The scope can be on the level of an individual table, or a schema associated with a user, or the database itself, or a syste

A technique for database management includes receiving an indication of a selected scope of a trigger. The scope is selected from a plurality of scopes of database management. The scope can be on the level of an individual table, or a schema associated with a user, or the database itself, or a system of databases, among others. The technique also includes receiving an indication of a selected event that belongs to the set of one or more events associated with the selected scope. Trigger metadata is stored that identifies both the selected scope and the selected event. A technique is also described for executing a process in this database management system. Flags indicative of one or more applicable events of the selectable events are loaded into a private cache of the process and checked when a new event occurs.

대표청구항 ▼

1. A method for creating triggers, the method comprising:receiving data that indicates a selected scope for a trigger, wherein the selected scope for the trigger is selected from a plurality of scopes of database management, wherein a first scope of the plurality of scopes consists of a single datab

1. A method for creating triggers, the method comprising:receiving data that indicates a selected scope for a trigger, wherein the selected scope for the trigger is selected from a plurality of scopes of database management, wherein a first scope of the plurality of scopes consists of a single database object of a particular type and a second scope of the plurality of scopes includes a plurality of database objects of the particular type, and wherein each scope of said plurality of scopes is associated with a set of one or more events; receiving data that indicates a selected event that belongs to the set of one or more events associated with the selected scope; and storing trigger metadata for said trigger, said trigger metadata including data identifying the selected scope and the selected event.