International Business Machines Corporation

Alibaba Group Holding Limited

Scott Patrick Hanson

Rafal Przemyslaw Konik

Roger Alan Mittelstadt

Craig Stephen Aldrich

Jane Ann Vold

Stephanie A Burrichter

Robert Ralph Roediger

Craig Arthur Orcutt

William Jon Schmidt

Curtis P Meier

Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.

Transforming a user-defined table function to a derived table in a database management system

A method, apparatus and article of manufacture for performing automatic intermodule call linkage optimization. In one embodiment, the run time is optimized for an object code generated from a source code. Initially, information is extracted for each procedure call in the source code. The extracted information is used to select a call linkage for each procedure call. The call linkages are selected to minimize the run time of the object code generated from the source code. Once the object code is generated form the source code, the object code is run using the selected call linkages for each procedure call.

Method, article of manufacture and apparatus for performing automatic intermodule call linkage optimization

Automatic template instantiation for cross compilation is provided. More particularly, a routine () on a development computer system () extracts template information from source code (). The routine () uses the template information to generate template source files (A,B), which may then be compiled with a cross compiler () to provide object code (A,B). Owing to one or more templates being dependent on one or more other templates, the routine is repeated until all templates, and their associated dependencies, are compiled into object code (B) with the cross compiler (). This object code is then portable from the development computer system () to a target computer system () for automatic template instantiation. Moreover, a template repository () is used to hold in part the template information. By centrally locating template information, duplicate templates may be avoided to conserve data resources.

Apparatus and method for template instantiation with a cross compiler

An apparatus and method provide more complete profile data by instrumenting indirect procedure calls in a computer program. Indirect procedure calls have a number of counters allocated in a table at each indirect call site. The counters are divided into counters in a low volatility area and counters in a high volatility area. The counters in the high volatility area have a pointer that identifies the next procedure to be replaced. As the instrumented code executes, a call to a procedure that is in the table increments the count of the counter in the table. A call to a procedure not in the table is placed in the high volatility area, displacing the procedure at the pointer, and moves the pointer to a new location. The displaced procedure is either promoted to the low volatility area, or is discarded. If promoted, the procedure that it displaces in the low volatility area is demoted to the high volatility area, displacing a procedure there at the pointer (and moving the pointer to a new location). This process continues until a displaced high volatility procedure is discarded.

Method and apparatus for profiling indirect procedure calls in a

A method and system in a data processing system for associating source code instructions with an optimized listing of object code instructions are disclosed. Source code instructions are compiled utilizing an optimizing compiler to generate a listing of object code instructions. The object code instructions are included within the listing in an optimized sequence. One of the object code instructions is compared with a second plurality of object code instructions. The second plurality of object code instructions are all located after the one object code instruction in the listing. In response to the comparison, a determination is made whether a selection of the one object code instruction will prohibit selection of a third plurality of object code instructions. If a determination is made a selection of the one object code instruction will not prohibit selection of a third plurality of object code instructions, the one object code instruction is associated with one of the source code instructions.

Growing community of inventors

Rochester, MN, United States of America

Scott Patrick Hanson