Method of using a plurality of subscriber types in managing a message queue of a database management system

• US 20070276914A1
• Filed: 06/19/2006
• Published: 11/29/2007
• Est. Priority Date: 05/10/2006
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Surlaker, Kapil, Bhatt, Neerja
• Granted Patent: US 8,464,275 B2
• Time in Patent Office: Days
• US Class Current: 709/206
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27

Abstract

A method of using a plurality of subscriber types in managing a message queue of a database management system is described and provided. The method comprises creating a subscriber with a set of rules to the message queue. The subscriber is designated as one or more of the plurality of subscriber types. Moreover, an event notification registration representing a request to be notified if a message to the message queue satisfies the set of rules may be created. In response to a new message for enqueuing to the message queue, it is determined whether the new message satisfies the set of rules. If the new message satisfies the set of rules and if so determined by a triggered event notification registration, a notification is performed according to the triggered event notification registration. A requirement that a receiver of the notification dequeue the new message from the message queue depends on the subscriber type designation.

Claims

1. A method of using a plurality of subscriber types in managing a message queue of a database management system, said method comprising:

creating a subscriber with a set of rules to said message queue;

designating said subscriber as one or more of said plurality of subscriber types;

creating an event notification registration representing a request to be notified if a message to said message queue satisfies said set of rules;

in response to a new message for enqueuing to said message queue, determining whether said new message satisfies said set of rules; and

if said new message satisfies said set of rules and if any event notification registration is triggered, performing a notification according to said triggered event notification registration, wherein a requirement that a receiver of said notification dequeue said new message from said message queue depends on said subscriber type designation.

2. The method as recited in claim 1 wherein at least one of said subscriber types avoids need for creation of specific access privileges to said message queue in addition to said set of rules.

3. The method as recited in claim 1 further comprising:

automatically dequeuing said new message from said message queue at an appropriate time.

4. The method as recited in claim 1 wherein said subscriber types include a public subscriber.

5. The method as recited in claim 1 wherein said subscriber types include a notification only subscriber.

6. The method as recited in claim 1 wherein said subscriber types include an ordinary subscriber.

7. The method as recited in claim 6 wherein said performing said notification comprises:

requiring said receiver of said notification to dequeue said new message from said message queue if said subscriber is designated as said ordinary subscriber.

8. A computer-readable medium comprising computer-executable instructions stored therein for performing a method of using a plurality of subscriber types in managing a message queue of a database management system, said method comprising:

creating a subscriber with a set of rules to said message queue;

designating said subscriber as one or more of said plurality of subscriber types;

creating an event notification registration representing a request to be notified if a message to said message queue satisfies said set of rules;

in response to a new message for enqueuing to said message queue, determining whether said new message satisfies said set of rules; and

if said new message satisfies said set of rules and if any event notification registration is triggered, performing a notification according to said triggered event notification registration, wherein a requirement that a receiver of said notification dequeue said new message from said message queue depends on said subscriber type designation.

9. The computer-readable medium as recited in claim 8 wherein at least one of said subscriber types avoids need for creation of specific access privileges to said message queue in addition to said set of rules.

10. The computer-readable medium as recited in claim 8 further comprising:

automatically dequeuing said new message from said message queue at an appropriate time.

11. The computer-readable medium as recited in claim 8 wherein said subscriber types include a public subscriber.

12. The computer-readable medium as recited in claim 8 wherein said subscriber types include a notification only subscriber.

13. The computer-readable medium as recited in claim 8 wherein said subscriber types include an ordinary subscriber.

14. The computer-readable medium as recited in claim 13 wherein said performing said notification comprises:

requiring said receiver of said notification to dequeue said new message from said message queue if said subscriber is designated as said ordinary subscriber.

15. An apparatus comprising:

a memory comprising instructions stored therein; and

a processor for executing said instructions to perform a method of using a plurality of subscriber types in managing a message queue of a database management system, said method comprising;

creating a subscriber with a set of rules to said message queue;

designating said subscriber as one or more of said plurality of subscriber types;

creating an event notification registration representing a request to be notified if a message to said message queue satisfies said set of rules;

in response to a new message for enqueuing to said message queue, determining whether said new message satisfies said set of rules; and

if said new message satisfies said set of rules and if any event notification registration is triggered, performing a notification according to said triggered event notification registration, wherein a requirement that a receiver of said notification dequeue said new message from said message queue depends on said subscriber type designation.

16. The apparatus as recited in claim 15 wherein at least one of said subscriber types avoids need for creation of specific access privileges to said message queue in addition to said set of rules.

17. The apparatus as recited in claim 15 further comprising:

automatically dequeuing said new message from said message queue at an appropriate time.

18. The apparatus as recited in claim 15 wherein said subscriber types include a public subscriber.

19. The apparatus as recited in claim 15 wherein said subscriber types include a notification only subscriber.

20. The apparatus as recited in claim 15 wherein said subscriber types include an ordinary subscriber.

21. The apparatus as recited in claim 20 wherein said performing said notification comprises:

requiring said receiver of said notification to dequeue said new message from said message queue if said subscriber is designated as said ordinary subscriber.