Approach for publishing data in a relational database system

• US 6,502,093 B1
• Filed: 03/14/2002
• Issued: 12/31/2002
• Est. Priority Date: 07/21/1999
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Gawlick, Dieter, Bhatt, Neerja, Soylemez, Ekrem
• Primary Examiner(s): Shah, Sanjiv
• Application Number:
  US10/099,478
• Time in Patent Office: 292 Days
• Field of Search: 707/3, 707/4, 707/5, 707/10, 707/1, 707/103, 707/2, 707/501.1
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24565 Triggers; Constraints
• CPC Class Codes: G06F 16/24568 Data stream processing; Continuous queries
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

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.

Claims

1. 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.

2. The method as recited in claim 1, further comprising providing to the client the particular data prior to being changed.

3. 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.

4. 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.

5. 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.

6. The method as recited in claim 1, wherein the client is a subscriber.

7. 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.

8. 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.

9. 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.

10. 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.

11. 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.

12. 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.

13. 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.

14. The computer-readable medium as recited in claim 9, wherein the client is a subscriber.

15. 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.

16. 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.

17. 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.

18. 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.

19. 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.

20. 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.

21. 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.

22. The computer-readable medium as recited in claim 17, wherein the client is a subscriber.

23. 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.

24. 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.