Oracle International Corporation

Ramkumar Venkatesan

Anand Lakshminath

Alan Robert Downing

Krishnan Meiyyappan

Lik Wong

James William Stamos

Nimar Singh Arora

Lei Gao

Byron Wang

Jun Yuan

Patricia H McElroy

Shailendra Mishra

Lakshminarayanan Luxi Chidambaran

A High-Performance, Scalable, Adaptive and Multi-dimensional Event Repository is described and utilized in a method for publishing an event in a database. The present method includes transparently intercepting a request to a database to publish an event. A messaging system operable with the database intercepts the request. The present method further includes examining an event repository for a template of the event. The event repository is operable with the database and the messaging system. The present method additionally includes retrieving the event template from the event repository. The present method also includes marshaling the event template to create the event. The present method also includes publishing the event in an event queue.

High-performance, scalable, adaptive and multi-dimensional event repository

A High-Performance, Scalable, Adaptive and Multi-dimensional Event Repository is described and utilized in a method for publishing an event in a database. The present method includes transparently intercepting a request to a database to publish an event. A messaging system operable with the database intercepts the request. The present method further includes examining an event repository for a template of the event. The event repository is operable with the database and the messaging system. The present method additionally includes retrieving the event template from the event repository. The present method also includes marshalling the event template to create the event. The present method also includes publishing the event in an event queue.

An approach for reducing transport of messages between nodes of a multi-node system is presented wherein a message queue is associated with a queue service, and based on which node the message queue resides, one of the nodes is registered as hosting the associated queue service. In response to a client attempting to connect and requesting a particular queue service, the client is caused to connect to the node on which the queue service resides.

Event locality using queue services

Splitting and merging database object information sharing streams. Streams are also referred to herein as 'propagations'. Splitting and merging information sharing streams can be used to improve performance in a information sharing environment when a failed or slow DBS impacts the performance. In one embodiment, an auto split process monitors the progress of applying changes at each node and detects the presence of a failed or a slow node. Once the failed or slow node is identified, the auto split process splits the propagation such that the offending node is sent through a separate propagation. Furthermore, an auto merge process can be started to monitor the newly created separate propagation. At a later point, the new propagation can be merged back into the original stream. For example, if the offending node catches up with other nodes, the auto merge process merges the newly created propagation back to the original propagation.

Reconfiguring propagation streams in distributed information sharing

Techniques are provided for maintaining high propagation availability for non-persistent messages. Destination-to-instance mapping information is provided to a listener process for a cluster database. The destination-to-instance mapping indicates the current owner instance of each single-instance destination within the cluster database. To establish a connection to a single-instance destination, a sending process sends a connection request to the global listener. The connection request identifies the desired destination queue, but not the owner instance of the queue. The global listener for the cluster database uses the destination-to-instance mapping to determine which instance is the current owner of the specified queue, and establishes a connection between the sending process and the appropriate owner instance.

High availability for distributed non-persistent event propagation

A method and apparatus for propagating and managing data, transactions and events either within a database, or from one database to another is provided. In one embodiment, messages are propagated from a source to a first queue and a second queue with the queues associated with the same database. The connection from the source to each queue maintains its own propagation job. This method could also be employed with cluster databases.

Finer grained point-to-point event propagation

Configuring an n-way multi-master information sharing topology. Adding a new node (e.g., database server) to the information sharing topology can be implemented as follows. Initially, the new node is added as a slave of a particular co-master in the information sharing topology. The objects to replicate are instantiated on the new node by propagating data from the particular co-master to the new node. Furthermore, a capture process is created on the particular co-master to send changes to the objects to the slave. Meanwhile, the co-masters continue to propagate changes to each other. To promote the slave to a master, changes to objects stored at the slave are propagated to each of the co-masters. Furthermore, changes at each of the masters are propagated to the promoted node.

Configuring or reconfiguring a multi-master information sharing environment

Techniques are provided for creating dynamic connections to objects on remote database clusters. Service-to-instance mapping information is provided to a listener process for a cluster database. The service-to-instance mapping indicates the current provider instance(s) of each object within the cluster database. To establish a connection to a remote object, a sending process uses an object link. The object link identifies the desired destination object, but not the provider instance of the object. The object link also contains a authentication information and other connection information that exists in regular database links. The global listener for the cluster database uses the service-to-instance mapping to determine which instance is the current provider of the specified object, and dynamically distinguishes the appropriate database instance as the endpoint of the connection.

Growing community of inventors

Mountain View, CA, United States of America

Ramkumar Venkatesan