US5564047A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Trigger generation in an active database management system
Assignee: International Business Machines Corp
•
Filing: 1995-04-11
•
Granted: 1996-10-08
•
Expires: 2015-04-11
Abstract
Abstract Triggers for automatically starting an extract process in response to the committing of update data to a repository by an update process. In one embodiment, triggers are associated with particular extract processes and are started upon the committing of update data to the repository by an update process. Upon being started, each trigger determines whether any of the update data is within the extract view of the extract process that it is associated with and, if so, evaluates a predetermined condition specified for the trigger. If the condition is satisfied, the trigger translates the update data within the extract view into the extract view and starts the extract process. In another embodiment, triggers are bound to repository entities within the view of an extract process and are started upon the updating of the corresponding entities. Upon being started, each trigger evaluates a predetermined condition specified for entity post-image and, if the condition is satisfied, adds the post-image to data being accumulated for the extract process. Upon the commitment of the update, all extract processes for which data has been accumulated are started after making available the data accumulated for the process. In yet another embodiment, if the condition specified for the entity post-image is satisfied, the trigger executes a trigger query against the updated entity instance to dynamically generate a list of triggers which are then executed.
Inventors
- 👤 Wouter Bloem
- 👤 Wiel A. G. Bruls
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-09 15:41
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2455; G06F16/24564; G06F16/24565; Y; Y10; Y10S; Y10S707/00; Y10S707/99931
Claims Analysis
Total Claims: 25
Claim 1
Independent Claim
194 words
In an active database management system in which at least one update process updates an entity in a data repository to form a post-image of said entity and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, a method for automatically starting said extract process in response to the committing of update data to said repository by said update process, said method comprising the steps of: (a) in response to the updating of an entity in said repository by said update process, evaluating a predetermined condition specified for said entity; and (b) in response to an evaluation of said predetermined condition as true, adding said post-image of said entity to data accumulated for said extract process; and (c) in response to the committing of update data to said repository by said update process, starting said extract process and making the accumulated data available to said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 2
Dependent Claim
194 words
In an active database management system in which at least one update process updates an entity in a data repository to form a post-image of said entity and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, a method for automatically starting said extract process in response to the committing of update data to said repository by said update process, said method comprising the steps of: (a) in response to the updating of an entity in said repository by said update process, evaluating a predetermined condition specified for said entity; and (b) in response to an evaluation of said predetermined condition as true, adding said post-image of said entity to data accumulated for said extract process; and (c) in response to the committing of update data to said repository by said update process, starting said extract process and making the accumulated data available to said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 3
Dependent Claim
19 words
The method of claim 1 in which said predetermined condition is a function of said post-image of said entity.
Claim 4
Dependent Claim
31 words
The method of claim 1 in which said update process performs an update of a selected update type on said entity, said predetermined condition being a function of said update type.
Claim 5
Dependent Claim
32 words
The method of claim 1 in which said repository contains a plurality of entities, said steps (a)-(b) being performed for each of said entities within the extract view of said extract process.
Claim 6
Dependent Claim
41 words
The method of claim 4 in which a plurality of extract processes extract data from said repository, said steps (a)-(b) being performed for each of said extract processes for each of said entities within the extract view of the extract process.
Claim 7
Dependent Claim
37 words
The method of claim 5 in which said step (c) comprises the steps of: (1) starting all extract processes for which data has been accumulated; and (2) making the accumulated data available to the started extract processes.
Claim 8
Dependent Claim
168 words
In an active database management system in which at least one update process updates one or more entities in a data repository to form a post-image of said entities and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, a method for automatically starting said extract process in response to the committing of update data to said repository by said update process, said method comprising the steps of: (a) in response to the updating of a specified entity in said repository by said update process, evaluating a predetermined condition specified for said entity; and (b) in response to an evaluation of said predetermined condition as true, executing a specified trigger query on said post-image of said entity to generate a list of one or more triggers; and (c) executing the one or more triggers contained in said list.
Claim 9
Dependent Claim
168 words
In an active database management system in which at least one update process updates one or more entities in a data repository to form a post-image of said entities and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, a method for automatically starting said extract process in response to the committing of update data to said repository by said update process, said method comprising the steps of: (a) in response to the updating of a specified entity in said repository by said update process, evaluating a predetermined condition specified for said entity; and (b) in response to an evaluation of said predetermined condition as true, executing a specified trigger query on said post-image of said entity to generate a list of one or more triggers; and (c) executing the one or more triggers contained in said list.
Claim 10
Dependent Claim
29 words
The method of claim 7 in which first and second extract processes-are defined, said list containing respective first and second triggers associated with said first and second extract processes.
Claim 11
Dependent Claim
193 words
In an active database management system in which at least one update process updates an entity in a data repository to form a post-image of said entity and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, apparatus for automatically starting said extract process in response to the committing of update data to said repository by said update process, said apparatus comprising: (a) means responsive to the updating of an entity in said repository by said update process for evaluating a predetermined condition specified for said entity; and (b) means responsive to an evaluation of said predetermined condition as true for adding said post-image of said entity to data accumulated for said extract process; and (c) means responsive to the committing of update data to said repository by said update process for starting said extract process and making the accumulated data available to said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 12
Dependent Claim
193 words
In an active database management system in which at least one update process updates an entity in a data repository to form a post-image of said entity and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, apparatus for automatically starting said extract process in response to the committing of update data to said repository by said update process, said apparatus comprising: (a) means responsive to the updating of an entity in said repository by said update process for evaluating a predetermined condition specified for said entity; and (b) means responsive to an evaluation of said predetermined condition as true for adding said post-image of said entity to data accumulated for said extract process; and (c) means responsive to the committing of update data to said repository by said update process for starting said extract process and making the accumulated data available to said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 13
Dependent Claim
33 words
The apparatus of claim 9 in which said repository contains a plurality of entities, said apparatus containing said means (a)-(b) for each of said entities within the extract view of said extract process.
Claim 14
Dependent Claim
167 words
In an active database management system in which at least one update process updates one or more entities in a data repository to form a post-image of said entities and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, apparatus for automatically starting said extract process in response to the committing of update data to said repository by said update process, said apparatus comprising: (a) means responsive to the updating of a specified entity in said repository by said update process for evaluating a predetermined condition specified for said entity; (b) means responsive to an evaluation of said predetermined condition as true for executing a specified trigger query on said post-image of said entity to generate a list of one or more triggers; and (c) means for executing the one or more triggers contained in said list.
Claim 15
Dependent Claim
167 words
In an active database management system in which at least one update process updates one or more entities in a data repository to form a post-image of said entities and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, apparatus for automatically starting said extract process in response to the committing of update data to said repository by said update process, said apparatus comprising: (a) means responsive to the updating of a specified entity in said repository by said update process for evaluating a predetermined condition specified for said entity; (b) means responsive to an evaluation of said predetermined condition as true for executing a specified trigger query on said post-image of said entity to generate a list of one or more triggers; and (c) means for executing the one or more triggers contained in said list.
Claim 16
Dependent Claim
212 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for automatically starting an extract process in response to the committing of update data to a repository by an update process in an active database management system in which at least one update process updates an entity in a data repository to form a post-image of said entity and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, said method steps comprising: (a) in response to the updating of an entity in said repository by said update process, evaluating a predetermined condition specified for said entity; and (b) in response to an evaluation of said predetermined condition as true, adding said post-image of said entity to data accumulated for said extract process; and (c) in response to the committing of update data to said repository by said update process, starting said extract process and making the accumulated data available to said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 17
Dependent Claim
212 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for automatically starting an extract process in response to the committing of update data to a repository by an update process in an active database management system in which at least one update process updates an entity in a data repository to form a post-image of said entity and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, said method steps comprising: (a) in response to the updating of an entity in said repository by said update process, evaluating a predetermined condition specified for said entity; and (b) in response to an evaluation of said predetermined condition as true, adding said post-image of said entity to data accumulated for said extract process; and (c) in response to the committing of update data to said repository by said update process, starting said extract process and making the accumulated data available to said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 18
Dependent Claim
21 words
The program storage device of claim 12 in which said predetermined condition is a function of said post-image of said entity.
Claim 19
Dependent Claim
33 words
The program storage device of claim 12 in which said update process performs an update of a selected update type on said entity, said predetermined condition being a function of said update type.
Claim 20
Dependent Claim
34 words
The program storage device of claim 12 in which said repository contains a plurality of entities, said steps (a)-(b) being performed for each of said entities within the extract view of said extract process.
Claim 21
Dependent Claim
43 words
The program storage device of claim 15 in which a plurality of extract processes extract data from said repository, said steps (a)-(b) being performed for each of said extract processes for each of said entities within the extract view of the extract process.
Claim 22
Dependent Claim
38 words
The program storage of claim 16 in which said step (c) comprises the steps of: (1) starting all extract processes for which data has been accumulated; and (2) making the accumulated data available to the started extract processes.
Claim 23
Dependent Claim
186 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for automatically starting an extract process in response to the committing of update data to a repository by an update process in an active database management system in which at least one update process updates one or more entities in a data repository to form a post-image of said entities and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, said method steps comprising: (a) in response to the updating of a specified entity in said repository by said update process, evaluating a predetermined condition specified for said entity; and (b) in response to an evaluation of said predetermined condition as true, executing a specified trigger query on said post-image of said entity to generate a list of one or more triggers; and (c) executing the one or more triggers contained in said list.
Claim 24
Dependent Claim
186 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for automatically starting an extract process in response to the committing of update data to a repository by an update process in an active database management system in which at least one update process updates one or more entities in a data repository to form a post-image of said entities and at least one extract process extracts from said repository data added by said update process, said update process having an update view of data in said repository, said extract process having an extract view of data in said repository, said method steps comprising: (a) in response to the updating of a specified entity in said repository by said update process, evaluating a predetermined condition specified for said entity; and (b) in response to an evaluation of said predetermined condition as true, executing a specified trigger query on said post-image of said entity to generate a list of one or more triggers; and (c) executing the one or more triggers contained in said list.
Claim 25
Dependent Claim
30 words
The method of claim 18 in which first and second extract processes are defined, said list containing respective first and second triggers associated with said first and second extract processes.
References Cited (Backward Citations)
US5471629A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-10-08 | 2000-04-08 | 2000-10-08 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-10-08 | 2004-04-08 | 2004-10-08 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-10-08 | 2008-04-08 | 2008-10-08 | $7700.00 | Window Closed / Lapsed |