Ncr Corporation

Jie-Bing Yu

Jignesh M Patel

Biswadeep Nag

Navin Kabra

Jian-Jun Chen

Karthikeyan Ramasamy

Curtis Ellmann

Zhe Wang

An instrumentation system for a database. A database management system contains instrumentation code which monitors behavior of the system, and stores parameters indicative of the behavior. Those stored parameters are copied into a second database, which is organized according to the same schema as the database itself. Both databases are searchable using the same query language, so that a system administrator can locate (1) data within the database and (2) diagnostic information about the system using a single search tool.

Method and apparatus for displaying instrumentation parameters in a database system

A method, apparatus, article of manufacture, and a memory structure for monitoring an executed query comprising at least one execution thread is disclosed. The method comprises the steps of executing the query; and while executing the query, storing an execution trace record for each execution thread in at least one execution log file. The execution trace record comprises execution trace information including a thread ID and a time stamp for the execution thread. The execution trace information can be recalled from the execution log file and presented to a user after execution of the query to allow post mortem analysis of the query. The article of manufacture comprises a program storage device tangibly embodying instructions for performing the method steps described above. The apparatus comprises a data server for executing the execution thread and for storing an execution trace record for the executed execution thread, the execution trace record having execution trace information including a thread identifier and a time stamp; a query coordinator for storing an execution plan having a time stamp and for retrieving and synchronizing the execution trace record and the execution plan; and a client process for displaying the retrieved execution trace information to a user after execution of the query.

Query monitor playback mechanism for post-mortem performance analysis

A method and apparatus for parallel execution of trigger actions. One or more embodiments of the invention comprise providing a C&plus;&plus; class (hereinafter referred to as &ldquo;dispatcher&rdquo;) that can take an SQL query or trigger action and start parallel execution of the trigger action. The trigger action is optimized and parallelized. The dispatcher executes the trigger action, sets up the communication links between the various operators in the trigger action, and ensures that all the results are sent back to the trigger.

Method and apparatus for parallel execution of trigger actions

A method, apparatus, article of manufacture, and a memory structure for providing access to an array-based data object to a client is disclosed. The method comprises the steps of receiving a database query from a client; generating a first execution plan from the database query; transmitting at least a portion of the first execution plan to a data server; compiling a query result from the execution of the first execution plan; and transmitting the query result to the client on a first communication path wherein the query result comprises an identification for a master data object responsive to the database query and the master data object comprises an identification for a plurality of array-based objects associated with the master data object. Further, the method comprises the establishment of a second communication path between the data server and the client and the transmission of the master data object to the client via this second communication path. This is followed by a third request by the client for the required array-based objects. This results in the generation of a third execution plan which is executed by the appropriate data server. The resultant array-based objects are then tagged with the corresponding object identification and sent in batched fashion directly to the client via the second communication path.

Method and apparatus for fetching array based objects by direct delivery and batching

A method, apparatus, and an article of manufacture for parallel execution of SQL operations from within user defined functions. One or more embodiments of the invention provide the user defined function (UDF) with a C&plus;&plus; class (hereinafter referred to as &ldquo;dispatcher&rdquo;) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling UDF. To provide the single stream to the calling UDF, one or more embodiments of the invention utilize a class that provides the UDF with a simple and easy-to-use interface to access the results of the nested SQL execution.

Method and apparatus for parallel execution of SQL-from within user defined functions

A method, apparatus, and an article of manufacture for parallel execution of SQL operations from stored procedures. One or more embodiments of the invention provide the stored procedure (stored procedure) with a C&plus;&plus; class (hereinafter referred to as &ldquo;dispatcher&rdquo;) that can take an SQL query and start parallel execution of the query. The query is optimized and parallelized. The dispatcher executes the query, sets up the communication links between the various operators in the query, and ensures that all the results are sent back to the data-server that originated the query request. Further, the dispatcher merges the results of the parallel execution and produces a single stream of tuples that is fed to the calling stored procedure. To provide the single stream to the calling stored procedure, one or more embodiments of the invention utilize a class that provides the stored procedure with a simple and easy-to-use interface to access the results of the nested SQL execution.

Growing community of inventors

Carlsbad, CA, United States of America

Jie-Bing Yu