Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1999-07-21
2002-06-11
Shah, Sanjiv (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
06405191
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
The foregoing needs are addressed by the present invention, which comprises, in one aspect, a method and system for implementing a content based publish-and-subscribe system.
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 the embodiment, 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.
Still other objects and advantages of the present invention will become readily apparent from the following detailed description, simply by way of illustration of the best mode contemplated of carrying out the invention. As will be realized, the invention is capable of other and different embodiments and its several details are capable of modifications in various obvious respects, all without departing from the invention. Accordingly, the drawing and description are to be regarded as illustrative in nature, and not as restrictive.
REFERENCES:
patent: 5870522 (1999-02-01), Dozier et al.
patent: 5873084 (1999-02-01), Bracho et al.
patent: 6021443 (2000-02-01), Bracho et al.
patent: 6038601 (2000-03-01), Lambert et al.
Clara Nippl, et al., “Accelerating Profiling Services by Parallel Database Technology,” 9 pages, Department of Computer Science, Technische Universitat München, Arcisstr. 21, 80290 Munich, Germany.
Norman W. Paton, et al., “Active Database Systems,” pp. 63-103, Mar. 1999, ACM Computing Surveys, vol. 31, No. 1.
PCT International Search Report dated Jun. 29, 2000, PCT/US 00/18043.
WO 98 33131 A (Multex Systems Inc.) Jul. 30, 1998 abstract; Figure 1 p. 11, line 3-p. 14, line 13, p. 29, line 9, p. 30, line 26.
Wyle M F: “A Wide Area Network Information Filter” Proceedings International Conference Artificial Intelligence on Wall Street, Oct. 9, 1991, New York, US, Los Alamitos, CA Oct. 9, 1991, pp. 10-15 XP000534152, p. 10, left-hand column, line 1 p. 12, right hand column, p. 24.
GB 2 274 182 A (Digital Equipment Int) Jul. 13, 1994 p. 1, line 3 p. 3, line 21 abstract; claim 1.
Binkley J et al: “Rama: An Architecture for Internet Information Filtering” Journal of Intelligent Information Systems: Artificial Intelligence and Database Technologies, NL, Kluwer Academic Publishers, Amsterdam vol. 5, No. 2, Sep. 1, 1995, pp. 81-99; XP000617268 ISSN: 0925-9902 abstract; figure 1 p. 83, line 20 p. 87, line 25.
Anonymous: “Method of Maintaining Continuity of Messages Over Publish/Subscribe System Failures” Research Disclosure, vol. 41, No. 414, Oct. 1, 1998, XP000041486 Havant, UK, article No. 41486 the whole document.
Patent Abtracts of Japan vol. 1995, No. 2, Mar. 31, 1995 & JP 06 319024 A (Nippon Rojisuteikusu KK), Nov. 15, 1994 abstract.
Bhatt Neerja
Gawlick Dieter
Soylemez Ekrem
Yaseem Rahim
Becker Edward A.
Hickman Palermo & Truong & Becker LLP
Oracle Corporation
Shah Sanjiv
Tan Carina M.
LandOfFree
Content based publish-and-subscribe system integrated in a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Content based publish-and-subscribe system integrated in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Content based publish-and-subscribe system integrated in a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2974305