Database system event triggers
US6405212B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 27, 1999 |
| Grant date | Jun 11, 2002 |
| Priority date | — |
| Expiry date | Sep 27, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99944
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.