US6826560B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Subscription and notification with database technology
Assignee: Toronto Dominion Bank
•
Filing: 2000-06-30
•
Granted: 2004-11-30
•
Expires: 2020-06-30
Abstract
Abstract The present invention teaches in general how to efficiently exploit active database technology and extensible database technology, i.e. triggers and user-defined functions for processing subscriptions. According to a first aspect of the present invention it is proposed to aggregate all subscriptions on a certain table, or more generally of a plurality of tables, into a single trigger on this table or tables, respectively. This will dramatically improve the trigger-based efficiency. According to a second aspect of the present invention it is proposed to deliver the information a subscriber has registered for directly out of the database systems address space via appropriate user defined functions which is another source of efficiency improvement.
Inventors
- 👤 Frank Leymann
- 👤 Dieter Roller
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-31 20:52
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933
Claims Analysis
Total Claims: 27
Claim 1
Independent Claim
127 words
A notification system for notifying one or more subscribers of changes to at least one database table T in a database system, the notification system comprising: at least one metadata table associated with the database table T, the at least one metadata table for storing one or more representations of subscription requests on specified changes of database table T; and at least one subscription trigger implemented as at least one database trigger associated with the database table T and responsive to changes of the database table T, the at least one subscription trigger determining records of the database table T qualifying under the representation of subscription requests stored in the metadata table by criteria referring to the database table T and the at least one metadata table.
Claim 2
Dependent Claim
127 words
A notification system for notifying one or more subscribers of changes to at least one database table T in a database system, the notification system comprising: at least one metadata table associated with the database table T, the at least one metadata table for storing one or more representations of subscription requests on specified changes of database table T; and at least one subscription trigger implemented as at least one database trigger associated with the database table T and responsive to changes of the database table T, the at least one subscription trigger determining records of the database table T qualifying under the representation of subscription requests stored in the metadata table by criteria referring to the database table T and the at least one metadata table.
Claim 3
Dependent Claim
15 words
The notification system according to claim 1 wherein the criteria comprises a database query statement.
Claim 4
Dependent Claim
41 words
The notification system according to claim 2 , in which the database query statement is independent from specific values of subscription requests and referring to specific values of the subscription requests only indirectly through the at least one metadata table content.
Claim 5
Dependent Claim
25 words
The notification system according to claim 1 , further comprising notification means for delivery of the records determined by the at least one subscription trigger.
Claim 6
Dependent Claim
20 words
The notification system according to claim 4 in which the notification means being a user-defined function in the database system.
Claim 7
Dependent Claim
21 words
The notification system according to the claim 5 in which the subscriptions are stored in the metadata-table in disjunct normal form.
Claim 8
Dependent Claim
23 words
The notification system according to the claim 6 in which all subscriptions on a predetermined database table are aggregated into a single trigger.
Claim 9
Dependent Claim
18 words
The notification system according to the claim 7 in which the notifications are stored into a subscriber database.
Claim 10
Independent Claim
133 words
A method for notifying one or more subscribers of changes to at least one database table T in a database system, the notifying method comprising the steps of: (a) providing at least one metadata table associated with the database table T, the at least one metadata table for storing one or more representations of subscription requests on specified changes of database table T; and (b) providing at least one subscription trigger implemented as at least one database trigger associated with the database table T and responsive to changes of the database table T, the at least one subscription trigger determining records of the database table T qualifying under the representation of subscription requests stored in the metadata table by criteria referring to the database table T and the at least one metadata table.
Claim 11
Independent Claim
133 words
A method for notifying one or more subscribers of changes to at least one database table T in a database system, the notifying method comprising the steps of: (a) providing at least one metadata table associated with the database table T, the at least one metadata table for storing one or more representations of subscription requests on specified changes of database table T; and (b) providing at least one subscription trigger implemented as at least one database trigger associated with the database table T and responsive to changes of the database table T, the at least one subscription trigger determining records of the database table T qualifying under the representation of subscription requests stored in the metadata table by criteria referring to the database table T and the at least one metadata table.
Claim 12
Dependent Claim
14 words
The method according to claim 9 wherein the criteria comprises a database query statement.
Claim 13
Dependent Claim
40 words
The method according to claim 10 , in which the database query statement is independent from specific values of subscription requests and referring to specific values of the subscription requests only indirectly through the at least one metadata table content.
Claim 14
Dependent Claim
24 words
The method according to claim 10 , further comprising the step of (c) delivering the records determined by the at least one subscription trigger.
Claim 15
Dependent Claim
22 words
The method according to claim 12 in which the delivering step (c) notification means being a user-defined function in the database system.
Claim 16
Dependent Claim
20 words
The method according to the claim 13 in which the subscriptions are stored in the metadata-table in disjunct normal form.
Claim 17
Dependent Claim
22 words
The method according to the claim 14 in which all subscriptions on a predetermined database table are aggregated into a single trigger.
Claim 18
Dependent Claim
17 words
The method according to the claim 15 in which the notifications are stored into a subscriber database.
Claim 19
Dependent Claim
138 words
A computer readable medium program containing instructions for notifying one or more subscribers of changes to at least one database table T in a database system, the program instructions comprising the steps of: (a) providing at least one metadata table associated with the database table T, the at least one metadata table for storing one or more representations of subscription requests on specified changes of database table T; and (b) providing at least one subscription trigger implemented as at least one database trigger associated with the database table T and responsive to changes of the database table T, the at least one subscription trigger determining records of the database table T qualifying under the representation of subscription requests stored in the metadata table by criteria referring to the database table T and the at least one metadata table.
Claim 20
Dependent Claim
138 words
A computer readable medium program containing instructions for notifying one or more subscribers of changes to at least one database table T in a database system, the program instructions comprising the steps of: (a) providing at least one metadata table associated with the database table T, the at least one metadata table for storing one or more representations of subscription requests on specified changes of database table T; and (b) providing at least one subscription trigger implemented as at least one database trigger associated with the database table T and responsive to changes of the database table T, the at least one subscription trigger determining records of the database table T qualifying under the representation of subscription requests stored in the metadata table by criteria referring to the database table T and the at least one metadata table.
Claim 21
Dependent Claim
17 words
The computer readable medium program according to claim 17 wherein the criteria comprises a database query statement.
Claim 22
Dependent Claim
43 words
The computer readable medium program according to claim 17 , in which the database query statement is independent from specific values of subscription requests and referring to specific values of the subscription requests only indirectly through the at least one metadata table content.
Claim 23
Dependent Claim
27 words
The computer readable medium program according to claim 17 , further comprising notification means for delivery of the records determined by the at least one subscription trigger.
Claim 24
Dependent Claim
22 words
The computer readable medium program according to claim 20 in which the notification means being a user-defined function in the database system.
Claim 25
Dependent Claim
23 words
The computer readable medium program according to the claim 21 in which the subscriptions are stored in the metadata-table in disjunct normal form.
Claim 26
Dependent Claim
25 words
The computer readable medium program according to the claim 22 in which all subscriptions on a predetermined database table are aggregated into a single trigger.
Claim 27
Dependent Claim
20 words
The computer readable medium program according to the claim 23 in which the notifications are stored into a subscriber database.
References Cited (Backward Citations)
US5497317A
Cited
US5809483A
Cited
US5797002A
Cited
JPH1011373A
Cited
US5903882A
Cited
US6256676B1
Cited
US6338055B1
Cited
US6347307B1
Cited
US6405191B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2007-11-30 | 2008-05-31 | 2008-11-30 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2011-11-30 | 2012-05-31 | 2012-11-30 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2015-11-30 | 2016-05-31 | 2016-11-30 | $7700.00 | Window Closed / Lapsed |