Affecting database file performance by allowing delayed query language trigger firing
AssigneeInternational Business Machines Corporation
InventorsRafal Przemyslaw Konik, Mark William Theuer, Michael Alan Venz
Life of this patent
Estimating the term…
Abstract
Embodiments of the invention provide techniques for processing database triggers having delay attributes. In general, delay attributes may selectively introduce a delay between the firing of a trigger and the execution of the triggered action. The delay may be based on waiting for a specified time interval, waiting until a specified time, or reaching a predetermined threshold of a measure of system performance. The use of delay attributes may enable greater control over the timing of the execution of the triggered action, resulting in reduced impact on the performance of an underlying system.
Claims21
A computer-implemented method for controlling the firing of database triggers, comprising:
- receiving an I/O event affecting a database trigger, the trigger being defined to fire in response to the I/O event;
- and
- in response to receiving the I/O event and before firing the database trigger:
- identifying one or more delay conditions defined for the database trigger;
- and
- delaying the firing of the database trigger until the one or more identified delay conditions are satisfied.
A computer-readable storage medium containing a program which, when executed, performs an operation, comprising:
- receiving an I/O event affecting a database trigger, the trigger being defined to fire in response to the I/O event;
- and
- in response to receiving the I/O event and before firing the database trigger:
- identifying one or more delay conditions defined for the database trigger;
- and
- delaying the firing of the database trigger until the one or more identified delay conditions are satisfied.
A system, comprising:
- a processor;
- and
- a memory containing a program configured to compose a query of hierarchical data by performing an operation, comprising:
- receiving an I/O event affecting a database trigger, the trigger being defined to fire in response to the I/O event;
- and
- in response to receiving the I/O event and before firing the database trigger:
- identifying one or more delay conditions defined for the database trigger;
- and
- delaying the firing of the database trigger until the one or more identified delay conditions are satisfied.
Dependencies are inferred from the claim text.