Oracle International Corporation

Chandrasekharan Iyer

Atif Chaudhry

Kumar Rajamani

Jaebock Lee

Philip Yam

Charles Wetherell

Zhen Hua Liu

William H Waddington

Yunrui Li

Vikas Arora

Ying Hu

Douglas James McMahon

Beda Christoph Hammerschmidt

Shrikanth Shankar

Giridhar Ravipati

Sanket Jain

Andre Kruglikov

Lei Sheng

Ajay Sethi

David M Alpern

Minghui Yang

Kristopher Leland Rice

Robert Pang

Guhan Viswanathan

Barry McGillin

Beethoven Cheng

Dermot O'neill

Alan Choi

Bryn Llewellyn

Agrawal Shashaanka

Phillip Yam

Disclosed is an approach to define non-SQL functions as a SQL macro, which is then processed inline with SQL statements. By inlining the macro into SQL, this approach avoids cross-engine context switches as well as making it possible for a SQL query optimizer to generate better plans that execute more efficiently.

Method and system to implement SQL macros

Described is a system, method, and computer program product to perform bi-directional mapping of hierarchical data (e.g. JSON, XML) to database object types (e.g., user defined database object types).

Bidirectional mapping of hierarchical data to database object types

Techniques are provided for caching external data sources for SQL processing. According to an embodiment, a database system receives a query that requires foreign data from an external data source. In response to receiving the query, the database system determines whether the foreign data currently resides in a cache of the database system. In response to determining that the foreign does not currently reside in the cache, the database system retrieves the foreign data from the external data source, maps the foreign data to a column granule of a table, and stores the column granule in the cache. In another embodiment, the database system receives a second query that requires the foreign data. In response to determining that the foreign data is cached with the stored column granule, the database system retrieves the column granule from the cache.

Caching external data sources for SQL processing

A method, system, and computer program product for database application migration. The method commences upon executing a foreign application, the foreign application emits SQL statements of a foreign SQL dialect that is incompatible with the SQL dialect of a native database system. The system configures a communication session to intercept the foreign SQL statements before the foreign SQL statements are received by the SQL parser of the native database system; and, while the foreign application is waiting for query results, the system translates the foreign dialect query statements into native SQL compatible with the native database system. The method further performs translating a return code from the native database system into a return code compatible with the foreign application. Configuring the database session connection comprises establishing a translation profile to translate foreign dialect SQL into native SQL, and to translate native SQL query return codes into foreign dialect return codes.

Run-time SQL language translation

A container database may contain multiple database dictionaries, each database dictionary defining a pluggable database. When database sessions are established on a container DBMS, each database session is given access to a pluggable database by establishing the respective database dictionary of the pluggable database as the database dictionary for that database session. Database commands issued through database session can only access the database objects defined in the database dictionary established for the database session.

Container database

A database may facilitate zero-downtime upgrades by concurrently maintaining multiple editions of database objects for use by both pre-upgrade and post-upgrade clients of a database application. Operations performed within the database are associated with an edition based on, for example, an initiating client or transaction. When an operation references an object or data, the database automatically performs the operation using the object or data associated with the edition with which the operation is itself associated. The database may determine the associated edition without explicit identification of the associated edition in a query or in code. Thus, no client or stored procedure code changes are necessary to reflect a new edition added during an update. Data changes in one edition may be automatically and immediately propagated to the other edition through the use of cross-edition triggers, thereby allowing both pre-upgrade and post-upgrade clients to remain fully functional throughout an upgrade.

Low-downtime and zero-downtime upgrades of database-centric applications

A system and method for automated management of a multi-component software installation. The software product comprises multiple components that can operate independently, but which may operate better (e.g., with more or different functionality) if able to call another component (a 'supplying' component). A persistent data store records the installation status of the components (e.g., as static Boolean values). Each installed component that depends on another component (i.e., can benefit from calling an element of the other component) is coded to compile conditionally, based on whether the supplying component is installed. If installed, the supplying component can be linked at compile time; if the supplying component is not installed, the installed component compiles and runs without the benefit of the supplying component.

Component-based software installation

One embodiment of the present invention provides a system that facilitates performing conditional compilation. The system operates by analyzing programming language source code prior to compilation to locate a preprocessing directive that specifies a condition to be evaluated, and also identifies source code to be conditionally included during compilation of the source code. Next, the system generates evaluation source code that evaluates the condition. The system then evaluates the condition by evaluating ordinary programming language and environmental variables within the evaluation source code. Note that the run-time variables are also available at run-time during execution of a compiled version of the original source code. Next, the system conditionally includes source code associated with a result of the evaluation and compiles the revised source code. Finally, the system records the use of any variables during condition evaluation in a persistent manner and automatically restarts the entire processing if any of the recorded variables may have been changed subsequent to the original compilation.

Method and apparatus for performing conditional compilation

A method and system for optimizing the passing of a parameter to a routine is provided. It is determined if any parameters are aliased in a call to a called routine. In the absence of aliases, calling routines passing parameters to called routines using &ldquo;call by reference&rdquo;. Recovery mechanisms are provided, when appropriate, when unhandled exception occur during execution of the called routines. According to the method, a recovery mechanism includes encapsulating the called routine and call statement block with a &ldquo;catch-all&rdquo; exception handler. The response to an otherwise unhandled exception includes restoring the actual parameter using a stored copy of the actual parameter. The restoration is performed by making a handle point to the copy of the actual parameter that was made before execution of the called routine.

Optimizing parameter passing

Growing community of inventors

Foster City, CA, United States of America

Chandrasekharan Iyer