Olwen S Tam

US Patent:

20070162421, Jul 12, 2007

Filed:

Jan 12, 2006

Appl. No.:

11/306852

Inventors:

Francis Pang - Oakland CA, US
Olwen Tam - Daly City CA, US
Kannan Ananthanarayanan - Fremont CA, US
Elena Lora-Gallardo - Montrouge, FR

Assignee:

SYBASE, INC. - Dublin CA

International Classification:

G06F 17/30

US Classification:

707002000

Abstract:

A SQL language interface for a messaging system, such as IBM MQ, is described. In one embodiment, for example, in a database system, a method is described for providing real-time message support for improved database connectivity, the method comprises steps of: defining Structured Query Language (SQL) extensions having commands that provide message-based connectivity for databases; receiving an SQL statement including a command specifying that a message be sent for communicating particular database data; upon execution of the SQL statement by the database system, creating an outbound message for communicating the particular database data to a destination; and posting the outbound database to a message bus, whereupon the particular database data is communicated asynchronously to the destination.