Oracle International Corporation

Raghu Mani

Jacco Draaijer

Eric P Voss

Roger Bodamer

Ravi Ramkissoon

A job scheduling technique that allows jobs to be launched as a result of messages which are not targeted specifically at the job, and for jobs to be interrelated in complex ways.

Leveraging advanced queues to implement event based job scheduling

A system, method, computer program and article of manufacture for improved process flow of job processing is accomplished via a combination of complex dependencies, task and chain reuse, and use of one or more events as a task.

Modular SQL rule-based management of job process flow

An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having heterogeneous services to selectively send requests to the foreign processes based on their respective capabilities. A client application sending a statement to the local database server is checked by the local server process to determine if the statement includes a reference to a foreign database system. The local server process selectively outputs a request to an agent process in communication with a foreign database via a generic Application Programming Interface (API). The request output to the foreign database is based on accessing a capabilities table specifying the operations that can be executed by the foreign database. Hence, the heterogeneous services within the local server process manages client statements involving foreign database systems having limited capabilities, and uses the agent process to manage interactions with the foreign database systems, including converting data, to preserve the integrity of the local server process and provide the appearance to the client application of a homogeneous distributed database system.

Apparatus and method for transparent access of foreign databases in a heterogeneous database system

An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having heterogeneous services to selectively send foreign operations to the appropriate foreign processes in a controllable manner. A client application sending a statement to the local database server is checked by the local server to determine if the statement includes a reference to a foreign database system. The heterogeneous services selectively outputs a the foreign request to an agent process in communication with the foreign database system via an Application Programming Interface (API), where a foreign database driver corresponding to the foreign database maps the request from the API to the format of the foreign database. The local database server selectively allocates memory space for expected results from the foreign database, and completes execution of the statement upon receiving the expected results from the agent process. Hence, the agent process efficiently manages client statements having expressions to be processed by a foreign database system.

Growing community of inventors

Sunnyvale, CA, United States of America

Raghu Mani