International Business Machines Corporation

Tanya Couch

Virginia Walbridge Hughes, Jr

Joseph Davis Lea, Iii

Theresa Hsing Lai

Catherine Elizabeth Wuebker Drummond

David Harold Oberstadt

Terry Michael Bleizeffer

Frederick Thomas Sharp

Constance Jane Nelin

Abdul Al-Azzawe

Robert William Lyle

Julie Ann Watts

Karelle Lynne Cornwell

Tom Robert Christopher

Guy Maring Lohman

James Z Teng

Berthold Reinwald

James Zu-Chia Teng

Stefan Bengt Edlund

George Lapis

Daina Edvina Pupons Wickham

Thomas Friedrich

Alexander Daniel Robinson

Catherine E Drummond

Debbani Kundu

Farnaz Erfan

A persistent filter refining system places a search result comprising objects in a dynamic non-persistent bucket and displays the search result in a dynamic non-persistent bucket display for selection of the objects by a user. The system transfers a selected object from the dynamic non-persistent bucket to a persistent bucket and displays the transferred selected object in a persistent bucket display. The system iteratively provides additional search results to the user for selection and transfer of additional selected objects to the persistent bucket to provide access by a user to take action on the transferred selected object and additional selected objects. In one embodiment, the present system displays one or more additional search results for comparison and selection of objects by the user.

Providing persistent refined intermediate results selected from dynamic iterative filtering

A system for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The system eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

Testing environment for database server side logic

A system for controlling concurrency of access to data in a database system is provided. The system includes receiving a lock request for access to data in the database system, in which the lock request is a request for a page lock or a row lock for a corresponding row or page in the database system containing the data. The method further includes identifying a partition in the database system that contains the row or the page in the database system containing the data; associating the lock request with a partition lock on the partition that contains the row or the page in the database system containing the data; and accessing the data using the partition lock.

System for controlling concurrent access to data in a database system

A method and system for controlling concurrency of access to data in a database system, includes: partitioning a table in the database system into a plurality of partitions; receiving a request for access to data; determining a partition of the plurality of partitions that contains the data; determining if the data has been committed; and if so, avoiding locking the partition in response to the request. By avoiding locking the partition when the data has been committed, the number of partition locks that need to be requested from a local resource lock manager is reduced, improving performance.

System and method for selective partition locking

A method for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The method eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

A method and system for tracking a plurality of actions against at least one object by a computer system is disclosed. The method and system comprises providing an output view, wherein the output view includes a first output area and a second output area. An action list containing each of the plurality of actions is displayed in one of the first and second output areas. A user is allowed to select one action from the action list, and information associated with the selected action is displayed in the other of the first and second output areas.

Method and system for displaying actions and historical content in an output view

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

A method and system for graphically representing a plan for a query in a relational database management system is disclosed. The method includes receiving and processing an input query to form a plurality of plans, selecting at least one plan of the plurality of plans, and transforming the selected plan into a self-describing formatted file which is platform independent. The method further includes generating a graph representing the selected plan from the self-describing formatted file.

Platform-independent method and system for graphically presenting the evaluation of a query in a database management system

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 modules of operational data and executable code for execution by a computer 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 request generation of query explain data by the database system. A query identification module is configured to communicate with the query explain program to receive a selected query for which a user wishes the database system to generate the query explain data. A system settings module is configured to communicate with the query explain program to receive a user designation of a database system setting with which the user wishes the database system to temporarily comply when generating the query explain data.

Apparatus and method for dynamically generating query explain data

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.

Growing community of inventors

San Jose, CA, United States of America

Tanya Couch