Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: The present invention is directed to a system and computer readable medium for converting messaging data into a relational table format in a database system, wherein the messaging data is within a messaging system. Through aspects of the system and computer readable medium of the present invention, the table function invokes at least one user defined function within the database system. Preferably, the table function is also a user-defined function. The table function can be used within a single SQL statement to access and convert the message data, and to populate directly a relational table. The user is no longer required to perform conversion steps because the conversion is automatically performed by the table function. Moreover, a table view can be created and utilized by a user to select a message and then have the selected message string returned in relational table format.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: A method and system for controlling concurrency of access to data in a database system is provided. The method 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: A system and a method are described for selectively locking the partitions of a partitioned table in a relational database. The database system locks only those partitions of the table that are accessed by an application. Other partitions are available for concurrent access by other applications, regardless of the strength of the lock needed.

Abstract: 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.

Abstract: A method and 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 method and 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.