International Business Machines Corporation

Theresa Hsing Lai

Tanya Couch

Virginia Walbridge Hughes, Jr

Joseph Davis Lea, Iii

Catherine Elizabeth Wuebker Drummond

David Harold Oberstadt

Terry Michael Bleizeffer

Steve T Kuo

Judith Eleanor Hill

Mark Alan Bach

In Ha Chung

Kevin Michael McBride

John Kevin Flanigan

H Moncrief Rowe-Anderson

Allen G Lee

Candace Antonina Garcia

Richard S Uyehara

An apparatus for filtering a plurality of groups of query statements according to identification data associated therewith includes a processor for executing instructions and a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include at least one filtering module configured to receive one or more user-specified filtering criteria directed to a subset of the identification data and apply the filtering criteria to selectively exclude those of the plurality of groups not satisfying the filtering criteria. The modules also include a group listing module configured to display to a user those of the plurality of groups not excluded by the at least one filtering module.

System and method for filtering query statements from multiple plans and packages according to user-defined filters of query explain data

An apparatus for filtering an explain table according to at least one user-defined filter includes a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include a filter generation module configured to receive user-specified filtering criteria directed to data within a selected column of the explain table and generate in response a user-defined filter. The modules also include a table filtering module configured to apply the user-defined filter to the explain table to selectively exclude rows of the explain table not satisfying the filtering criteria of the user-defined filter.

System and method for filtering explain tables

An apparatus for integrally referencing a user-generated copy of a catalog in a database system includes a memory device having thereon modules of code for execution by a processor. The modules include a database system component module configured to refer to a catalog generated by the database system; and a catalog qualifier designation module communicating with the database system component module and configured to receive a user designation of a user-specified name for a user-generated copy of the catalog generated by the database system to be referenced in place of the catalog generated by the database system.

System and method for referencing a user-generated copy of a catalog

An apparatus for dynamically generating query explain data includes a processor for executing instructions and a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include a query explain program operating on a workstation. The query explain program communicates over a network with a server hosting a database system and is configured to temporarily store the query explain data received across the network from the database system in a data cache. The query explain program may be configured to automatically clear a selected portion of the data cache when the data cache reaches a user-selectable size. The user is thus allowed to determine when to clear the data cache and how much of the data cache to clear.

Apparatus and method for locally caching query explain data

An apparatus for filtering a set of query statements according to query explain data associated therewith includes a processor for executing instructions and a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include a filter generation module configured to receive user-specified filtering criteria directed to a subset of the query explain data for at least one query statement and generate in response at least one user-defined filter. The modules also include a statement filtering module configured to apply the user-defined filter to the set of query statements to selectively exclude query statements not satisfying the filtering criteria of the at least one filter.

System and method for filtering query statements according to user-defined filters of query explain data

A system and method for specifying custom qualifiers for explain tables allows a user to designate selected explain tables for which the user wishes to view statements. A query explain program is provided and configured with an explain table qualifier designation module for receiving a user designation of a query explain table to reference. The user selects a function of the query explain program to perform and then designates the qualifier of the query explain table to be referenced. The function is then performed in conjunction with the contents of the selected query explain table.

System and method for specifying custom qualifiers for explain tables

A method for selectively preparing customized reports of query explain data comprises selectively retrieving from the database subsets of the query explain data for the at least one query statement; formatting the subsets for display to a user; displaying within a report customization window one or more controls for selectively designating subsets of the query explain data for the at least one query statement to be included in the report; and in response to selection of the one or more controls, generating a report that includes the designated subsets of the query explain data for the at least one query statement.

System and method for selectively preparing customized reports of query explain data

A method, apparatus, and article of manufacture for generating program specifications for a computer program that accesses datastore persistent objects materialized from a datastore. A 'wizard' or 'task guide' is displayed on a monitor attached to a computer, wherein the wizard comprises a step-by-step procedure for creating the program specifications. Operator input is accepted into the computer in response to the step-by-step procedure and the program specifications are created using the operator input.

IMS web studio taskguide

IMS Web provides for a method and apparatus which enables a user to communicate with IMS-based applications using a Web Browser. An input HTML form is used to associate IMS transaction data which is then supplied to a CGI-BIN program which uses IMS Web generated C++ class definitions to determine classes for each logical page. The CGI-BIN program interacts with the IMS database through an TCP/IP OTMA adapter and an output HTML communicates with the Web client.

Growing community of inventors

Saratoga, CA, United States of America

Theresa Hsing Lai