Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2002-03-14
2002-12-31
Shah, Sanjiv (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
06502093
ABSTRACT:
FIELD OF THE INVENTION
This invention relates to the publish-and-subscribe system and, more specifically, to methods and apparatus for integrating a content-based publish-and-subscribe system with a relational database system.
BACKGROUND OF THE INVENTION
Communication models are used to handle the complexity of receiving messages from and distributing messages to multiple nodes in a distributed computing environment. An example of a communication model that is widely used is the publish-and-subscribe interaction system among applications. Entities that produce the messages or information are “publishers” and entities that are interested in the messages are “subscribers”. The publish-and-subscribe model involves an asynchronous messaging capability, i.e., publishers need not wait for subscribers. For example, a producer of information simply “publishes” information on multiple communication channels and the consumer of information “subscribes” to the channels of interest. The publish-and-subscribe paradigm is said to be event-driven because communication between the producer of information and the consumer of information is triggered by business events. Also, the asynchronous nature of the messages dictates that any incoming message is an event.
In general, a messaging system uses a set of rules to ensure that a particular message gets to the right subscriber(s). A rule is a condition that describes the message or messages that are desired by a subscriber. A rules engine is used to apply the rules to the messages. There are a variety of standards governing the expression of the rules and the structure of the messages. However, there is no single standard that is widely used. The lack of a widely used standard has resulted in disparate tool sets for working with historical information (existing messages) versus future information (incoming messages). It is inefficient to maintain disparate tool sets in a messaging system.
Based on the foregoing, there is a need for a method or mechanism to implement the content-based publish-and-subscribe system in an environment with widely used standards and to use a common tool set for working with historical information and future information.
SUMMARY OF THE INVENTION
According to one aspect of the invention, an expression used in queries that is written in a query language supported by a relational database system is received from a subscriber and stored as a rule to determine whether an incoming message is to be sent to the subscriber. If the incoming message satisfies the rule, then the message is delivered to the subscriber. In one embodiment, the evaluation of the rules for determining whether an incoming message is to be sent to a subscriber is performed using a two-tier evaluation method. In another aspect of the invention, messages are implicitly published to the subscriber when the publisher is the relational database system itself.
According to another aspect of the invention, the use of well established standards of a query language such as Structured Query Language (“SQL”) in a content-based publish-and-subscribe system enables the publish-and-subscribe system to take advantage of the existing knowledge base and toolsets of the query language.
According to another aspect of the invention, a method is provided for processing queries in a database system. The method includes receiving, from a client, a query that is written in a query language supported by the database system, wherein the query is a request for data stored in the database system that satisfies the query. The method also includes detecting that the data stored in the database system has been changed and in response to detecting that the data stored in the database system has been changed, providing the changed data to the client.
REFERENCES:
patent: 5680602 (1997-10-01), Bloem et al.
patent: 5870552 (1999-02-01), Dozier et al.
patent: 5873075 (1999-02-01), Cochrane et al.
patent: 6122639 (2000-09-01), Babu et al.
patent: 6285997 (2001-09-01), Carey et al.
patent: 6401090 (2002-06-01), Bailis et al.
Bhatt Neerja
Gawlick Dieter
Soylemez Ekrem
Becker Edward A.
Hickman Palermo & Truong & Becker LLP
Oracle Corporation
Shah Sanjiv
LandOfFree
Approach for publishing data in a relational database system does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Approach for publishing data in a relational database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Approach for publishing data in a relational database system will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2980805