US5680602A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Trigger generation in an active database management system
Assignee: International Business Machines Corp
•
Filing: 1996-07-17
•
Granted: 1997-10-21
•
Expires: 2016-07-17
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 Angelina Gerardus Bruls
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-27 18:24
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: 19
Claim 1
Independent Claim
179 words
In an active database management system in which an update process updates data in a repository and an 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 that may differ from said update view, 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 committing of update data to said repository by said update process, determining whether any of said update data is within said extract view; (b) in response to a determination that least some of said update data is within said extract view, evaluating a predetermined condition specified for said extract process; and (c) in response to an evaluation of said predetermined condition as true, starting said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 2
Dependent Claim
179 words
In an active database management system in which an update process updates data in a repository and an 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 that may differ from said update view, 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 committing of update data to said repository by said update process, determining whether any of said update data is within said extract view; (b) in response to a determination that least some of said update data is within said extract view, evaluating a predetermined condition specified for said extract process; and (c) in response to an evaluation of said predetermined condition as true, starting said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 3
Dependent Claim
25 words
The method of claim 1 in which a plurality of extract processes are defined, said steps (a)-(c) being performed for each of said extract processes.
Claim 4
Dependent Claim
27 words
The method of claim 1 in which said step (c) comprises the additional step of translating the update data within said extract view into said extract view.
Claim 5
Dependent Claim
25 words
The method of claim 3 in which said step (c) comprises the additional step of making the translated update data available to said extract process.
Claim 6
Dependent Claim
17 words
The method of claim 1 in which said predetermined condition is a function of said update data.
Claim 7
Dependent Claim
28 words
The method of claim 1 in which said update process performs an update of a selected update type, said predetermined condition being a function of said update type.
Claim 8
Dependent Claim
20 words
The method of claim 1 in which said predetermined condition is a function of the preexisting data in said repository.
Claim 9
Dependent Claim
179 words
In an active database management system in which an update process updates data in a repository and an 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 that may differ from said update view, 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 committing of update data to said repository by said update process for determining whether any of said update data is within said extract view; (b) means responsive to a determination that at least some of said update data is within said extract view for evaluating a predetermined condition specified for said extract process; and (c) means responsive to an evaluation of said predetermined condition as true for starting said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 10
Dependent Claim
179 words
In an active database management system in which an update process updates data in a repository and an 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 that may differ from said update view, 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 committing of update data to said repository by said update process for determining whether any of said update data is within said extract view; (b) means responsive to a determination that at least some of said update data is within said extract view for evaluating a predetermined condition specified for said extract process; and (c) means responsive to an evaluation of said predetermined condition as true for starting said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 11
Dependent Claim
26 words
The apparatus of claim 8 in which a plurality of extract processes are defined, said apparatus containing said means (a)-(c) for each of said extract processes.
Claim 12
Dependent Claim
197 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 an update process updates data in a repository and an 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 that may differ from said update view, said method steps comprising: (a) in response to the committing of update data to said repository by said update process, determining whether any of said update data is within said extract view; (b) in response to a determination that least some of said update data is within said extract view, evaluating a predetermined condition specified for said extract process; and (c) in response to an evaluation of said predetermined condition as true, starting said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 13
Dependent Claim
197 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 an update process updates data in a repository and an 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 that may differ from said update view, said method steps comprising: (a) in response to the committing of update data to said repository by said update process, determining whether any of said update data is within said extract view; (b) in response to a determination that least some of said update data is within said extract view, evaluating a predetermined condition specified for said extract process; and (c) in response to an evaluation of said predetermined condition as true, starting said extract process to extract from said repository data added by said update process that is within said extract view.
Claim 14
Dependent Claim
27 words
The program storage device of claim 10 in which a plurality of extract processes are defined, said steps (a)-(c) being performed for each of said extract processes.
Claim 15
Dependent Claim
29 words
The program storage device of claim 10 in which said step (c) comprises the additional step of translating the update data within said extract view into said extract view.
Claim 16
Dependent Claim
27 words
The program storage device of claim 12 in which said step (c) comprises the additional step of making the translated update data available to said extract process.
Claim 17
Dependent Claim
19 words
The program storage device of claim 10 in which said predetermined condition is a function of said update data.
Claim 18
Dependent Claim
30 words
The program storage device of claim 10 in which said update process performs an update of a selected update type, said predetermined condition being a function of said update type.
Claim 19
Dependent Claim
22 words
The program storage device of claim 10 in which said predetermined condition is a function of the preexisting data in said repository.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2000-10-20 | 2001-04-21 | 2001-10-21 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2004-10-20 | 2005-04-21 | 2005-10-21 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2008-10-20 | 2009-04-21 | 2009-10-21 | $7700.00 | Window Closed / Lapsed |