Abstract: A method, system and article of manufacture for query execution management in a data processing system and, more particularly, for managing execution of queries including user-defined functions. One embodiment provides a method for managing execution of a query against data of a database. The method includes receiving a query against the data of the database, the query having at least one query condition including a user-defined function. It is determined whether the user-defined function satisfies a predefined index applicability criterion. If the user-defined function satisfies the predefined index applicability criterion, an index over relevant data of the database is created for the user-defined function. The index is suitable for use in execution of the query against the data of the database to determine a corresponding query result.

Abstract: A database monitor tracks performance statistics and information about the execution of different SQL statements. In particular, the monitor tracks information about the individual instructions that comprise a complex query. The performance statistics and information from these individual elements provide insight into a query's performance and may show why a query's performance is below expectations.

Abstract: A database monitor tracks performance statistics and information about the execution of different SQL statements. A query optimizer benefits from these statistics when generating an access plan. In particular, the query optimizer, upon receiving an SQL statement, searches the records of the database monitor for similar SQL statements that have previously been executed. As part of determining the best access plan for the current SQL statement, the query optimizer considers the information retrieved from the database monitor. In this way, the access plan that is generated can automatically be tuned based on empirical performance evidence.

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: A computer system, program product and method debug an object-oriented computer program by tracking the creation of objects by a plurality of creators (e.g., constructor methods) of a selected class. A user need not separately track each creator. Instead, a debugger identifies each creator and associates breakpoints with all or a user-specified subset of creators to facilitate tracking. Any of the breakpoints may then trigger a halting of execution during debugging. Moreover, in some instances it may be desirable to track the number of creations by all or the subset of the creators for the selected class during program execution until a user-specified condition is satisfied, whereupon program execution is terminated and debugging information is provided to the user.

Abstract: A method, apparatus and system for notifying a user of a portable communication device. In one embodiment, a location of a first portable communication device is determined for a first user and the location of a second portable communication device is determined for a second user. A determination is made as to whether the location of the second portable communication device is within a same region containing the first portable communication device. If the second portable communication device is within the same region as the first portable communication device, then the first user is notified of the presence of the second user.

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 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 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 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 portable phone is equipped with a position detector that detects the geographical position of the portable phone, and a telephone system may ring one or more land-based phones or portable phones according to the geographical position of the portable phone. One or more geographical regions are defined, with corresponding telephone parameters defined for each region. When a portable phone enters a defined region, exits a defined region, or changes between two defined regions, the function of one or more land-based phones or portable phones may change. The preferred embodiments thus allow changing the function of one or more other phones based on the self-detected geographical position of a portable phone. In this manner the convenience of using portable phones is greatly enhanced.

Abstract: A portable phone is equipped with a position detector that detects the geographical position of the portable phone, and a telephone system may ring one or more land-based phones or portable phones according to the geographical position of the portable phone. One or more geographical regions are defined, with corresponding telephone parameters defined for each region. When a portable phone enters a defined region, exits a defined region, or changes between two defined regions, the function of one or more land-based phones or portable phones may change. The preferred embodiments thus allow changing the function of one or more other phones based on the self-detected geographical position of a portable phone. In this manner the convenience of using portable phones is greatly enhanced.

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.

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

Abstract: A method, system and article of manufacture for processing aggregation queries that are executed against a database and, more particularly, for managing aggregation data structures associated with tables of a database. One embodiment provides a method for managing creation of aggregation data structures for tables of a database.