Oracle International Corporation

Eric P Voss

Jacco Draaijer

Roger Bodamer

Raghu Mani

Ravi Ramkissoon

Mark Charles Ramacher

Alex Tsukerman

Sanjay Kaluskar

Anindo Roy

David M Alpern

Jane Xin Chen

James Feenan

Christopher P Racicot

Ronald M Decker

Jacco Draaller

Mineharu Takahara

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 cache with a database system that contains a subset of the objects stored in another database system. The cache database system responds to a request that contains a reference to an object that is not in the cache by redirecting the request to the other database system when the request is executed in the cache's database system. Redirection is done by rewriting requests that refer to objects that are not in the cache. In one kind of rewriting, a cursor is marked to indicate redirection, and when the cursor is executed in the cache database system, it is redirected to the other database system for execution. In the other kind, calls to stored procedures that are not present in the cache database system are rewritten as remote procedure calls to the stored procedures in the other database system.

Redirection of misses in queryable caches

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

Various embodiments of the invention provide solutions to facilitate the management and/or automation of various database tasks, in particular system tasks. Merely by way of example, some embodiments provide methods systems and/or software products that can facilitate automation of such tasks. In accordance with certain embodiments, a maintenance window may be defined. The maintenance window can provide an opportunity for system tasks (and/or other tasks, especially those that consume significant database resources) to execute without significantly impacting the usability of the database. In particular embodiments, a maintenance window may be defined to coincide with a period of relatively low user activity. In some cases, a maintenance window may be implemented in conjunction with a job scheduler and/or a resource manager. Merely by way of example, a resource manager might allocate relatively more system and/or database resources to system tasks during the maintenance window, and/or a job scheduler may schedule system tasks to execute during the maintenance window.

Systems, methods and software for automating database tasks

An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having a heterogeneous services module 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, or whether the statement is registered as an external routine. The heterogeneous services module selectively outputs a request to an agent process executing in an address space separate from the local server process and in communication with the foreign database. The agent process performs all necessary interaction with the foreign database, including data type translation. The agent includes a conversion module that includes data type conversion routines, and which may obtain additional conversion routines via an Application Programming Interface (API) from a foreign database driver corresponding to the foreign database. The converted request is output from the agent process to the foreign database. Hence, the heterogeneous services module manages client statements involving foreign database systems having limited capabilities, as well as client statements having expressions unrecognizable by the local database server. Use of the agent process ensures that the integrity of the local server process is protected.

Apparatus and method for accessing 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 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.

Apparatus and method for passing statements to foreign databases by

An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having a heterogeneous services module 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 for a registered external routine executable by an agent process in an address space separate from the local server process. The heterogeneous services module selectively initiates a network connection with an external agent process, and the external agent process executes the external routine by accessing a dynamically linked library. If necessary, the local database server and the agent process exchange callback queries and callback results via the heterogeneous services module to complete intermediate queries within the same user instance. The local database server then completes the client statement based on the results received from the agent process. Use of a link to an external agent process executing in a separate address space enables the local server process to use enhanced external routines written in third generation languages, without risking the local server process to failures in the external routines.

Growing community of inventors

Redwood City, CA, United States of America

Eric P Voss