Broker-based messaging through SQL

A system comprising:

• memory storing user preferences, user contexts and optimized queues;
• and
• one or more servers performing operations comprising:
• defining a message-sending procedure, the message-sending procedure being a built-in procedure in a database and configured to invoke a messaging client at a database server to publish messages to one or more message brokers using at least message broker configurations;
• receiving, at the database server and from a database client:
• a message in the form of a structured query language (SQL) statement to be published to the one or more message brokers;
• and
• a definition of a message broker destination;
• processing, at the database server, the received message;
• determining the message broker configurations associated with the received message;
• before publishing the message, retrieving information associated with the message broker for use in publishing the message, wherein the definition of the message broker destination includes a schema name, an identifier for a particular message broker, a distribution type, and a connection string identifying a host, a port, and connection parameters for connecting to a particular message broker;
• and
• publishing, by calling a message-sending procedure built into the database and the message-sending procedure invoking the messaging client at the database server, the message to the one or more message brokers using at least the message broker configurations.

A non-transitory computer-readable media encoded with a computer program, the program comprising instructions that when executed by one or more computers cause the one or more computers to perform operations comprising:

• defining a message-sending procedure, the message-sending procedure being a built-in procedure in a database and configured to invoke a messaging client at a database server to publish messages to one or more message brokers using at least message broker configurations;
• receiving, at the database server and from a database client:
• a message in the form of a structured query language (SQL) statement to be published to the one or more message brokers;
• and
• a definition of a message broker destination;
• processing, at the database server, the received message;
• determining the message broker configurations associated with the received message;
• before publishing the message, retrieving information associated with the message broker for use in publishing the message, wherein the definition of the message broker destination includes a schema name, an identifier for a particular message broker, a distribution type, and a connection string identifying a host, a port, and connection parameters for connecting to a particular message broker;
• and
• publishing, by calling a message-sending procedure built into the database and the message-sending procedure invoking the messaging client at the database server, the message to the one or more message brokers using at least the message broker configurations.