Abstract: An apparatus and method optimize a query in a computer database system having a DISTINCT specifier. An SQL SELECT statement with a DISTINCT specifier is analyzed to determine if the expression can be optimized, and if so, the SELECT statement is reformulated to improve system performance. In preferred embodiments, the query optimizer eliminates the DISTINCT specifier in the outer select statement to reformulate the query. In other preferred embodiments, a query optimizer reformulates the query before being sent to the database manager to optimize the query to improve system performance.

Abstract: A method, system, and computer program product that provide for more uniform pricing of utility computing resources, such as a computing grid. One aspect of the present invention is a method of calculating costs in a utility computing environment comprising receiving a request to process a work unit from a requester, generating at least one performance metric associated with the work unit, and debiting the requestor for processing the work unit based at least in part on the performance metric. The performance metric in this embodiment is related to an amount of resources required to process the work unit under predetermined conditions.

Abstract: A database optimizer collects statistics regarding applications accessing a database, and makes one or more changes to the database schema to optimize performance according to the collected statistics. In a first embodiment, the optimizer detects when a certain type of application accesses the database a percentage of time that exceeds a predefined threshold level, and if the data in the database is stored in a less-than-optimal format for the application, the data type of one or more columns in the database is changed to a more optimal format for the application. In a second embodiment, the optimizer detects when one type of application accesses a column a percentage of time that exceeds a first predefined threshold level and is less than a second predefined threshold level, and creates a new column in the database so the data is present in both formats.

Abstract: An apparatus and method automatically generate an event profile in an integrated development environment. In one specific implementation, an event profile is automatically created that identifies portions of the computer program that have changed since the last time the computer program was run. The automatically-generated event profile may be used by a profiler to generate a trace of the computer program. By automatically creating the event profile based on the code that changed, the code developer is relieved of the burden of manually creating many event profiles.

Abstract: A method and apparatus autonomically analyze computer software performance to identify performance problems and isolate particular pieces of software that contribute to those performance problems to improve overall computer system performance. In preferred embodiments, performance problems are identified based on information learned from running an application, and instrumentation hooks are dynamically inserted at instrumentation points to isolate the performance problems.

Abstract: In a first aspect, a method is provided that includes the steps of (1) pre-computing a query result for each of a plurality of whole segments of data included in a database; (2) receiving a query specifying a defined range of data in the database; (3) determining if any of the whole segments are within the defined range; (4) performing the query on any partial segments of data within the defined range; and (5) determining the result of the query based on the pre-computed query results for any whole segments determined to be within the defined range and the result of the query on any partial segments within the defined range. Numerous other aspects are provided.

Abstract: Methods, articles of manufacture and systems for managing Web services. One embodiment provides a method comprising providing one or more rules configured to determine whether a Web service is deterministic. A deterministic Web service produces in subsequent executions identical output in response to identical input. The one or more rules are associated with the Web service.

Abstract: A database system has a contention monitor which determines when the level of contention for accessing or inserting records in the database rises above a threshold, and inhibits non-critical access to the database to reduce the level of contention. In a preferred embodiment, the level of contention is determined by periodically measuring the time for an INSERT operation on the database, and comparing the time to a threshold derived from a baseline time measurement for the operation during a time of normal database activity. Thus the contention level is inferred from the time to do the operation, in this case the INSERT query. In one embodiment, the contention monitor notifies a system administrator to take action to reduce the contention. In another embodiment, the contention monitor informs the system to take action automatically according to predetermined selections by the system administrator.

Abstract: A run-time monitor allows defining sets of run-time error criteria and corresponding diagnostic action to take when the run-time error criteria is satisfied. One way to define the run-time error criteria is to take a baseline measurement of run-time errors that occur during normal processing conditions. A run-time error criteria may then be defined that is based on the baseline measurement. In this manner, a rate of run-time errors that normally occur may be ignored, while a rate of run-time errors in excess of the run-time error criteria could automatically initiate diagnostic action. In this manner, the ability of a programmer to debug run-time errors is significantly enhanced.

Abstract: There are disclosed improved methods, systems, and computer program products for enhancing query optimization. More particularly, it relates to dynamically selecting alternative query access plans.

Abstract: An apparatus, program product and method utilize one or more usage statistics, which are reflective of what data is actually and/or likely to be used by a client when processing a database query, to reduce or eliminate the transfer of unnecessary data between a client and server in a client-server database management system. Information such as the columns that are or have been used and/or the number of rows that have been accessed, may be utilized to identify certain data that is likely to not be used during processing of the database query. Based upon the data that has been identified, a subset of the data that would otherwise be returned as a result of the database query may be identified and returned to a client, often substantially reducing the amount of data required to be retrieved by a client in connection with a database query.

Abstract: A system, method and article of manufacture for identifying mergeable data in a data processing system and, more particularly, for identifying correlated columns from one or more database tables. One embodiment comprises determining correlation attributes for a first column and a second column from one or more database tables. The correlation attributes describe for each column at least one of the column and content of the column. The correlation attributes from the first and second column are compared and similarities between the first and second column are identified on the basis of the comparison. Then, on the basis of the identified similarities, it is determined whether the first and second columns are correlated. Only if the columns are determined to be correlated, the first and second columns are merged.

Abstract: A method, apparatus, system, and signal-bearing medium that in an embodiment determine whether a task is allowed to use a service-enabled resource, wherein the service-enabled resource is disabled until a fee is paid. If the task is allowed to use the service-enabled resource, then the service-enabled resource is allocated to the task. If the task is not allowed to use the service-enabled resource, then a non-service enabled resource is allocated to the task.

Abstract: A system, method and article of manufacture for identification of mergeable data in a data processing system and, more particularly, for providing mechanisms for facilitating identification of correlated columns from one or more database tables. One embodiment provides a computer-implemented method for managing storage of data having an associated measurement unit in a database table. The method includes storing the data in a column of the database table and generating units metadata describing the measurement unit. The units metadata is associated with the column of the database table.

Abstract: A method, apparatus, system, and signal-bearing medium that in an embodiment collect a performance metric of a first partition in a logically-partitioned computer. If the difference between the performance metric and an expected performance metric exceeds a threshold, then a job or another partition is shut down or suspended. The expected performance metric is calculated based on the performance that is expected if the first partition is the only partition.

Abstract: A computer-implemented method, system and computer product including a scheduling manager residing in memory; whereby the scheduling manager dynamically manages access of additional computer resources to be applied to work items of a program based on their valuations relative to the processing costs thereof.

Abstract: An apparatus, program product and method for determining a cost for using a standby resource that accounts for the cause for the resource's usage. A standby resource, such as a processor, is activated in response to a resource requirement. The cause of the resource requirement is automatically determined. The result of that automatic determination is used to determine a charge indicator for using the standby resource. For instance, performance code associated with a failure may be associated with a charge indicator. A user may later be billed according to the determined charge indicator, i.e., according to their actual use of the standby resource and/or their usage status.

Abstract: A system, method and article of manufacture for presentation of data on a display device and, more particularly, for managing presentation of data in a tabular form on a display device. One embodiment provides a method of managing display of requested data on a display device. The method comprises, in response to a request for data, receiving the requested data in a tabular form having a plurality of columns and rows ordered according to an initial order; re-ordering at least one of the columns and rows, wherein the re-ordering is done on the basis of rules configured to intelligently arrange presentation of the requested data to a user; and outputting the re-ordered requested data for display on the display device.

Abstract: Methods, systems, and computer program products for dynamically adjusting computer resources, as appropriate, in response to predictions of batch runtimes as well as for rendering costs of the computer resources actually utilized, which costs are consistent with customer demands.

Abstract: According to the preferred embodiments, a database relationship constraint is defined for a first column that specifies a set of allowable values for the first column that depend on a set of data values in a second column that may be of a different type than data in the first column. In a first embodiment, a database relationship constraint specifies allowable values for one column in a database table based on one or more data values in a different column in the same database table. In a second embodiment, a database relationship constraint specifies a set of allowable values in a first column based on one or more data values in a second column in a different database table. In both cases, the data in the second column may be of a different type than data in the second column.