US6502093B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Approach for publishing data in a relational database system
Assignee: Oracle International Corp
•
Filing: 2002-03-14
•
Granted: 2002-12-31
•
Expires: 2022-03-14
Abstract
Abstract A method and apparatus are provided for implementing a content-based publish-and-subscribe system in a relational database system. A subscriber may request for messages by using a query language supported by the database server. The queries are then used as subscription rules for determining whether an incoming message is to be sent to the subscriber. Evaluation of incoming messages against subscription rules involves a two-tier process. The first tier involves filtering out all the subscription rules that could not possibly apply to the incoming message. The second tier involves further evaluation of the incoming message, if needed, to determine which subscribers are to receive the incoming message. In another aspect of the embodiment, in cases where the publisher is the relational database system itself, queries that request for messages are not stored as subscription rules because publication of the messages is implicit. In this situation, a query is received from a client that is written in a query language supported by the database system. The query is a request for data stored in the database system that satisfies the query. A detection is made that the data stored in the database system has been changed and in response, the changed data is provided to the client.
Inventors
- 👤 Neerja Bhatt
- 👤 Dieter Gawlick
- 👤 Ekrem Soylemez
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 21:41
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2455; G06F16/24568; G06F16/24564; G06F16/24565; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99935
Claims Analysis
Total Claims: 30
Claim 1
Independent Claim
88 words
A method for processing queries in a database system, the method comprising the steps of: receiving, from a client, a query that is written in a query language supported by the database system; detecting that particular data stored in the database system has been changed, wherein the particular data satisfied the query prior to being changed and continues to satisfy the query after being changed; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 2
Independent Claim
88 words
A method for processing queries in a database system, the method comprising the steps of: receiving, from a client, a query that is written in a query language supported by the database system; detecting that particular data stored in the database system has been changed, wherein the particular data satisfied the query prior to being changed and continues to satisfy the query after being changed; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 3
Dependent Claim
21 words
The method as recited in claim 1 , further comprising providing to the client the particular data prior to being changed.
Claim 4
Dependent Claim
26 words
The method as recited in claim 1 , further comprising implementing a trigger in the database system to provide the changed particular data to the client.
Claim 5
Dependent Claim
30 words
The method as recited in claim 3 , wherein the trigger is activated in the database system in response to the particular data stored in the database system being changed.
Claim 6
Dependent Claim
40 words
The method as recited in claim 3 , wherein the trigger is implemented in the database system as one or more sequences of instructions that are executed in response to the particular data stored in the database system being changed.
Claim 7
Dependent Claim
14 words
The method as recited in claim 1 , wherein the client is a subscriber.
Claim 8
Dependent Claim
27 words
The method as recited in claim 1 , wherein the step of sending a notification to the client includes sending the changed particular data to the client.
Claim 9
Independent Claim
104 words
A method for processing queries in a database system, the method comprising the steps of: receiving, from a client, a query that is written in a query language supported by the database system; storing the query in the database system as a subscription rule; detecting that particular data stored in the database system has been changed from a first state to a second state, wherein the particular data in at least one of the first and second states satisfies the query; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 10
Independent Claim
104 words
A method for processing queries in a database system, the method comprising the steps of: receiving, from a client, a query that is written in a query language supported by the database system; storing the query in the database system as a subscription rule; detecting that particular data stored in the database system has been changed from a first state to a second state, wherein the particular data in at least one of the first and second states satisfies the query; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 11
Dependent Claim
112 words
A computer-readable medium for processing queries in a database system, the computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: receiving, from a client, a query that is written in a query language supported by the database system; detecting that particular data stored in the database system has been changed, wherein the particular data satisfied the query prior to being changed and continues to satisfy the query after being changed; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 12
Dependent Claim
112 words
A computer-readable medium for processing queries in a database system, the computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: receiving, from a client, a query that is written in a query language supported by the database system; detecting that particular data stored in the database system has been changed, wherein the particular data satisfied the query prior to being changed and continues to satisfy the query after being changed; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 13
Dependent Claim
47 words
The computer-readable medium as recited in claim 9 , further comprising one or more additional instructions which, when executed by the one or more processors, cause the one or more processors to perform the step of providing to the client the particular data prior to being changed.
Claim 14
Dependent Claim
52 words
The computer-readable medium as recited in claim 9 , further comprising one or more additional instructions which, when executed by the one or more processors, cause the one or more processors to perform the step of implementing a trigger in the database system to provide the changed particular data to the client.
Claim 15
Dependent Claim
31 words
The computer-readable medium as recited in claim 11 , wherein the trigger is activated in the database system in response to the particular data stored in the database system being changed.
Claim 16
Dependent Claim
41 words
The computer-readable medium as recited in claim 11 , wherein the trigger is implemented in the database system as one or more sequences of instructions that are executed in response to the particular data stored in the database system being changed.
Claim 17
Dependent Claim
15 words
The computer-readable medium as recited in claim 9 , wherein the client is a subscriber.
Claim 18
Dependent Claim
28 words
The computer-readable medium as recited in claim 9 , wherein the step of sending a notification to the client includes sending the changed particular data to the client.
Claim 19
Dependent Claim
128 words
A computer-readable medium for processing queries in a database system, the computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: receiving, from a client, a query that is written in a query language supported by the database system; storing the query in the database system as a subscription rule; detecting that particular data stored in the database system has been changed from a first state to a second state, wherein the particular data in at least one of the first and second states satisfies the query; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 20
Dependent Claim
128 words
A computer-readable medium for processing queries in a database system, the computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: receiving, from a client, a query that is written in a query language supported by the database system; storing the query in the database system as a subscription rule; detecting that particular data stored in the database system has been changed from a first state to a second state, wherein the particular data in at least one of the first and second states satisfies the query; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 21
Dependent Claim
116 words
A computer system for processing queries in a database system, the computer system comprising a memory that includes one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: receiving, from a client, a query that is written in a query language supported by the database system; detecting that particular data stored in the database system has been changed, wherein the particular data satisfied the query prior to being changed and continues to satisfy the query after being changed; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 22
Dependent Claim
116 words
A computer system for processing queries in a database system, the computer system comprising a memory that includes one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: receiving, from a client, a query that is written in a query language supported by the database system; detecting that particular data stored in the database system has been changed, wherein the particular data satisfied the query prior to being changed and continues to satisfy the query after being changed; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 23
Dependent Claim
50 words
The computer-readable medium as recited in claim 17 , wherein the memory further comprises one or more additional instructions which, when executed by the one or more processors, cause the one or more processors to perform the step of providing to the client the particular data prior to being changed.
Claim 24
Dependent Claim
55 words
The computer-readable medium as recited in claim 17 , wherein the memory further comprises one or more additional instructions which, when executed by the one or more processors, cause the one or more processors to perform the step of implementing a trigger in the database system to provide the changed particular data to the client.
Claim 25
Dependent Claim
31 words
The computer-readable medium as recited in claim 19 , wherein the trigger is activated in the database system in response to the particular data stored in the database system being changed.
Claim 26
Dependent Claim
41 words
The computer-readable medium as recited in claim 19 , wherein the trigger is implemented in the database system as one or more sequences of instructions that are executed in response to the particular data stored in the database system being changed.
Claim 27
Dependent Claim
15 words
The computer-readable medium as recited in claim 17 , wherein the client is a subscriber.
Claim 28
Dependent Claim
28 words
The computer system as recited in claim 17 , wherein the step of sending a notification to the client includes sending the changed particular data to the client.
Claim 29
Dependent Claim
132 words
A computer system for processing queries in a database system, the computer system comprising a memory that includes one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: receiving, from a client, a query that is written in a query language supported by the database system; storing the query in the database system as a subscription rule; detecting that particular data stored in the database system has been changed from a first state to a second state, wherein the particular data in at least one of the first and second states satisfies the query; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
Claim 30
Dependent Claim
132 words
A computer system for processing queries in a database system, the computer system comprising a memory that includes one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: receiving, from a client, a query that is written in a query language supported by the database system; storing the query in the database system as a subscription rule; detecting that particular data stored in the database system has been changed from a first state to a second state, wherein the particular data in at least one of the first and second states satisfies the query; and in response to detecting that the particular data stored in the database system has been changed, sending a notification to the client.
References Cited (Backward Citations)
US5870552A
Cited
US5680602A
Cited
US6401090B1
Cited
US5873075A
Cited
US6122639A
Cited
US6285997B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-12-30 | 2006-07-01 | 2006-12-31 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-12-30 | 2010-07-01 | 2010-12-31 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-12-30 | 2014-07-01 | 2014-12-31 | $7700.00 | Window Closed / Lapsed |