Method and apparatus to facilitate access and propagation of messages in communication queues using a public network

• US 7,206,842 B2
• Filed: 08/25/2005
• Issued: 04/17/2007
• Est. Priority Date: 12/19/2001
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Meiyyappan, Krishnan, Jain, Namit, Bhatt, Neerja, Mishra, Shailendra K., Wang, Wei, Nainani, Bhagat V.
• Primary Examiner(s): Lim; Krisna
• Application Number:
  US11/213,191
• Publication Number:
  US 20060015565A1
• Time in Patent Office: 600 Days
• Field of Search: 709/225, 709/206, 707/10
• US Class Current: 709/225
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 67/63 Routing a service request depending on the request content or context

Abstract

One embodiment of the present invention provides a system that facilitates accessing communication queues using a public network. The system operates by first generating a message or messages at a client. The system then formats these messages in a publicly available format. Next, the system communicates the messages across the public network to a web server. The web server receives the messages and transforms the messages to a database specific format. The web server then passes the messages to a queue within a database server across a proprietary network. In one embodiment of the present invention, the system includes queue-to-queue propagation with exactly once guarantees and recovery from failures. In one embodiment of the present invention, the system includes transactional guarantees when a client accesses a queue.

Claims

1. A method to facilitate accessing communication queues using a public network, comprising:

generating a message at a client;

formatting the message at the client in a publicly available format;

communicating the message across the public network to a web server;

receiving the message at the web server;

transforming the message into a database specific format, wherein the database specific format is understood by a database server coupled to the web server;

passing the message to a queue within the database server across a proprietary network; and

propagating the message from the queue within the database server to a recipient, and in doing so, guaranteeing exactly once delivery of the message to the recipient.

2. The method of claim 1, wherein the publicly available format includes extensible markup language (XML).

3. The method of claim 1, wherein communicating the message across the public network includes communicating with one of, hypertext transfer protocol (HTTP), simple mail transfer protocol (SMTP), and file transfer protocol (FTP), whereby the message can be communicated across a firewall.

4. The method of claim 1, further comprising receiving a request from the recipient to receive a stored message from the queue.

5. The method of claim 1, further comprising receiving a request from the recipient to receive notification of new messages from the queue.

6. The method of claim 1, wherein the recipient is a second queue in a second database.

7. The method of claim 1, wherein exactly once delivery is guaranteed by using a two-phase commit protocol.

8. The method of claim 1, wherein exactly once delivery is guaranteed by using a sequence number and not by a two phase commit.

9. A computer-readable storage medium storing instructions that when executed by a computer cause the computer to perform a method to facilitate accessing communication queues using a public network, comprising:

generating a message at a client;

formatting the message at the client in a publicly available format;

communicating the message across the public network to a web server;

receiving the message at the web server;

transforming the message into a database specific format, wherein the database specific format is understood by a database server coupled to the web server;

passing the message to a queue within the database server across a proprietary network; and

propagating the message from the queue within the database server to a recipient, and in doing so, guaranteeing exactly once delivery of the message to the recipient.

10. The computer-readable storage medium of claim 9, wherein the publicly available format includes extensible markup language (XML).

11. The computer-readable storage medium of claim 9, wherein communicating the message across the public network includes communicating with one of, hypertext transfer protocol (HTTP), simple mail transfer protocol (SMTP), and file transfer protocol (FTP), whereby the message can be communicated across a firewall.

12. The computer-readable storage medium of claim 9, the method further comprising receiving a request from the recipient to receive a stored message from the queue.

13. The computer-readable storage medium of claim 9, the method further comprising receiving a request from the recipient to receive notification of new messages from the queue.

14. The computer-readable storage medium of claim 9, wherein the recipient is a second queue in a second database.

15. The computer-readable storage medium of claim 9, wherein exactly once delivery is guaranteed by using a two-phase commit protocol.

16. The computer-readable storage medium of claim 9, wherein exactly once delivery is guaranteed by using a sequence number and not by a two phase commit.

17. An apparatus to facilitate accessing communication queues using a public network, comprising:

a generating mechanism that is configured to generate a message at a client;

a formatting mechanism at the client that is configured to format the message in a publicly available format;

a communicating mechanism that is configured to communicate the message across the public network to a web server;

a receiving mechanism that is configured to receive the message at the web server;

a transforming mechanism that is configured to transform the message into a database specific format, wherein the database specific format is understood by a database server coupled to the web server;

a passing mechanism that is configured to pass the message to a queue within the database server across a proprietary network; and

a propagating mechanism that is configured to propagate the message from the queue within the database server to a recipient, and in doing so, guarantees exactly once delivery of the message to the recipient.

18. The apparatus of claim 17, wherein the publicly available format includes extensible markup language (XML).

19. The apparatus of claim 17, wherein communicating the message across the public network includes communicating with one of, hypertext transfer protocol (HTTP), simple mail transfer protocol (SMTP), and file transfer protocol (FTP), whereby the message can be communicated across a firewall.

20. The apparatus of claim 17, wherein the communication mechanism is configured to receive a request from the recipient to receive a stored message from the queue.