Abstract: A computer-implemented method, system and article of manufacture for managing workloads in a computer system, comprising monitoring system conditions and operating environment events that impact on the operation of the computer system, using an n-dimensional state matrix to identify at least one state resulting from the monitored system conditions and operating environment events, and initiating an action in response to the identified state.

Abstract: An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.

Abstract: Processing of a request is optimized. The request has one or more predicates. A list of the one or more predicates in the request is created and predicates for which an actual cost has not been stored or for which a cost cannot be estimated are pruned from the list. An access path for the each of the predicates is selected. The request is processed using the selected access paths producing one or more actual predicate costs. The one or more actual predicate costs are stored.

Abstract: A computer-implemented method, system and article of manufacture for managing workloads in a computer system, comprising monitoring system conditions and operating environment events that impact on the operation of the computer system, regulating execution of one or more queries based on the monitored system conditions and operating environment events using arrival rate throttles, and performing the queries to access data in a database for presentation and use to a user.

Abstract: A system, method, and computer-readable medium that provide virtual user access to a database system are provided. Middle-tier application end users issue requests to a middle-tier application that submits the requests to a database system on behalf of the middle-tier end users. The middle-tier application may authenticate end users and maintain a session pool for maintaining sessions with the database system for virtual users comprising valid middle-tier application end users. The middle-tier application is able to assert the identity of virtual users corresponding to the end users for use in access rights checking and auditing of queries without establishing a new logon session for the user. To facilitate middle-tier application assertion of virtual user identities, the middle-tier application is registered as a valid database user with the database system.

Abstract: A computer-implemented method, apparatus and article of manufacture for optimizing a database query. A query execution plan for the database query is generated using estimated cost information; one or more steps of the query execution plan are executed to retrieve data from a database stored on the computer system. Actual cost information is generated for each of the executed steps, and the estimated cost information is re-calculated using the actual cost information. One or more resource allocation rules defined on one or more steps of the query execution plan are executed, based on the estimated cost information, wherein the resource allocation rules include one or more defined actions. The estimated cost information may be re-calculated using the actual cost information when confidence in the estimated cost information is low, but the estimated cost information may not be re-calculated when confidence in the estimated cost information is high.

Abstract: A computer-implemented method, apparatus and article of manufacture for optimizing a database query. Resource usage of one or more resources of the computer system are monitored. A condition code representative of the monitored resource usage is stored. A cost model is modified using the stored condition code. A query execution plan is generated for the database query using the modified cost model. The query execution plan is then executed in order to retrieve data from a database stored on the computer system, wherein the retrieved data is presented to a user for subsequent use and analysis.

Abstract: A system and method for managing a domain comprised of a plurality of database systems, wherein each of the database systems performs database queries to retrieve data stored by the database systems. There are one or more virtual regulators for managing the domain and one or more closed-loop system management (CLSM) regulators for managing each of the database systems in the domain. Both the virtual regulators and CLSM regulators perform parallel virtual optimization of the database queries performed by the database systems.

Abstract: A method, system and computer program for mapping business concepts related to the processing of requests on a database system to database system feature settings is disclosed. Rules limit the requests that will be submitted to the database system for processing and establish workload definitions that can be used to map each request submitted to the database system for processing to database feature settings, based on business concepts associated with each request.

Abstract: An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.

Abstract: A method, computer program and system for regulating the workload of a database system as it processes one or more requests are disclosed. The requests are grouped into workload groups and are processed by one or more of a plurality of subsystems within the database system. Each subsystem has resources. The system has resources. The subsystem resources and the system resources are allocated across the workload groups. The method, computer program and system include monitoring, at a subsystem level, the processing of the requests and adjusting the allocation of subsystem resources to workload groups to achieve a subsystem goal and monitoring, at a system level, the processing of the requests and adjusting the allocation of system resources to workload groups to achieve a system goal. The subsystems are arranged in a hierarchical network.

Abstract: A system and method for managing database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein a database tuning agent function of the regulator uses statistics on physical and logical data access in order to perform automated block size management for database objects.

Abstract: Request processing is optimized. The request has elements. The method, computer program and database system includes selecting an access path for the request taking into consideration a stored actual request element cost, processing the request using the selected access path, producing one or more actual request element costs, and storing the one or more actual request element costs.

Abstract: A computer-implemented apparatus, method, and article of manufacture for optimizing a database query. System conditions and operating environment events that occur during operation of the computer system are monitored. An n-dimensional optimizer matrix is used to identify at least one rule resulting from the monitored system conditions and operating environment events. An optimal query execution plan is selected from among a plurality of query execution plans generated for the query in response to the identified rule.

Abstract: A computer-implemented method, apparatus and article of manufacture for optimizing a database query. A query execution plan is generated for the database query, which may be stored in an in-line query capture database. Execution of the query execution plan may be monitored in order to generate performance information, which also may be stored in the in-line query capture database. The data stored in in-line query capture database may be used during the initial generation of query execution plans, as well as for the re-optimization of a query execution plan, during the execution of the query execution plan.

Abstract: A method and apparatus of analyzing a target system comprises receiving information relating to an environment of the target system and storing cost data based on the environment information. The plan and its estimated performance for a query may be determined based on the cost data. The environment information may pertain to the environment of a parallel system (e.g., a multi-node parallel system, a single-node parallel system having plural central processing units or a system running plural virtual processors) that is running a parallel database. The cost data may identify a number of nodes in the target system, a number of central processing units in each node of the target system, and other types of system information. The cost data may be stored in a relational table having a plurality of rows. Each row of the relational table may correspond to a different target system.

Abstract: A computer-implemented apparatus, method, and article of manufacture manage a plurality of database systems. A domain includes a plurality of database systems. Each of the database systems is tuned for a particular type of workload. A virtual regulator (or multiple virtual regulators running in parallel) manages the domain and routes a set of one or more queries to a particular database system within the domain based on a cost function for each database system.

Abstract: An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.

Abstract: A computer-implemented system, method and article of manufacture for managing a plurality of database systems in a domain, wherein each of the database systems are managed by one or more closed-loop system management (CLSM) regulators. A virtual regulator manages the domain, wherein the virtual regulator communicates with the CLSM regulators to monitor the database systems' system conditions and operating environment events within the domain and to provide for dynamic query optimization between the database systems within in the domain based on the system conditions and operating environment events.

Abstract: A computer-implemented method, system and article of manufacture for managing workloads in a computer system, comprising monitoring system conditions and operating environment events that impact on the operation of the computer system, regulating execution of one or more queries based on the monitored system conditions and operating environment events using arrival rate throttles, and performing the queries to access data in a database for presentation and use to a user.