Abstract: A web server comprising multiple computer systems includes at least one system which maintains a database of redundant session-persistent data on behalf of other systems which process HTTP session workloads for clients. A session analyzer extracts information from this redundancy database to characterize HTTP session workloads. Preferably, session workloads are processed by middleware comprising an application server and one or more applications. The application server maintains session-persistent data as data objects, and automatically updates the database of redundant data which responses are transmitted to a clients. The session analyzer independently extracts data from the redundant database to characterize the session workloads. Optionally, the analyzer includes an intelligent inferencing function which can make tuning recommendations from the extracted data.

Abstract: Validating a URL in a document, including identifying the URL in the document, where the URL identifies a computer resource containing text, the document contains other text in addition to the URL, and the document is under edit by a user in an editing program on a computing device. Embodiments also include analyzing the validity of the URL, including analyzing the proximity of the other text to the URL in the document and comparing the other text in the document to the text in the resource identified by the URL in dependence upon the proximity of the other text to the URL in the document. Embodiments also include advising the user of the validity of the URL.

Abstract: A method, system and article of manufacture for migration of databases and, more particularly, for optimizing migration of a database from a source system to a target system. One embodiment provides a computer-implemented method for optimizing migration of a database from a source system to a target system. The method comprises collecting source parameters related to performance characteristics for the database on the source system. On the basis of the collected source parameters and target parameters of the target system database configuration information is generated. The target parameters will affect the operation of the database on the target system as compared to the operation of the database on the source system. The database configuration information is applicable to tune the database to operate on the target system. The method further comprises configuring the database to run on the target system according to the database configuration information.

Abstract: A debugger display groups threads according to user-specified criteria. The threads may be grouped by type, by current or historic breakpoints, according to historical debug patterns, based on what thread spawned the thread, based on execution pattern, based on object class in a Java environment, based on Java thread group in a Java environment, or base on other suitable criteria. The grouping of threads is displayed graphically to a user of the debugger, thereby allowing more efficient debugging of multi-threaded computer programs.

Abstract: A program product, an apparatus, and method of autonomically adjusting when performance data from a call stack is collected during a trace. In particular, the sampling interval between call stack collections may be autonomically adjusted while a trace is executing based upon the call stack, various performance metrics, and/or previous call stack collections.

Abstract: In a partitioned database system that includes multiple logical partitions, query performance is estimated with a current allocation of resources. A determination is made whether additional resources are available or whether resources could be reallocated from one logical partition to a different logical partition. Query performance is then estimated again with a proposed reallocation of resources. This process continues iteratively until an allocation of resources is determined that will enhance the performance of the query. A resource allocation mechanism then initiates the reallocation of resources. In this manner, resources in logical partitions may be dynamically and autonomically reallocated to improve the performance of a query to a partitioned database.

Abstract: An apparatus and method utilize MQTs in a more efficient manner in a high availability computer database to improve database performance and utility. In preferred embodiments, an MQT control file indicates whether journal entries for specific tables are to be propagated to replicated databases residing on other computer servers. In other embodiments, the MQT control file includes metrics that are used to control when the propagation is turned on and off.

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: A performance monitor reports SAN performance so that issues within the SAN are not masked from the client. Accesses to the SAN may be grouped into the categories of SAN logical or SAN physical. In one specific embodiment, the ranges of service times for accesses to the SAN are determined by monitoring service times of accesses to the SAN from the client perspective. In another specific embodiment, the ranges of service times for the SAN are determined by the SAN returning data with each request that indicates the service time from the SAN perspective. This allows reporting not only SAN logical and SAN physical accesses, but also allows reporting SAN service time. By specifying SAN service time, the client is able to better determine network delays. In yet another embodiment, information is returned by the SAN to indicate whether the access is SAN logical or SAN physical.

Abstract: A database journal mechanism stores both row operations and database queries in a database journal. The database queries in the journal provide significant additional information that may be used in a number of different ways. For example, a database replication send mechanism in accordance with the preferred embodiments could read a database query in the journal and determine that the query affects several rows. The database replication send mechanism could then transmit the database query to the computer system that hosts the replicated database. A database replication receive mechanism in accordance with the preferred embodiments receives the database query, and executes the database query on the replicated database. As a result, the transmission of a single database query can replace the transmission of many row operations.

Abstract: Scheduling garbage collection by gathering garbage collection information about two or more garbage collection processes, and determining when at least one of the two or more garbage collection processes should execute in dependence upon the garbage collection information is disclosed. Garbage collection information may be gathered through inter-process communication between two or more garbage collection processes, or by gathering garbage collection information from a computer on which at least one garbage collection processes is running. Determining when at least one of garbage collection processes should execute in dependence upon the garbage collection information may include determining a time to execute at least one garbage collection process so as to reduce the likelihood that execution of two or more of the garbage collection processes will overlap. A master garbage collection scheduler may be provided to schedule garbage collection.

Abstract: The activity of a database is monitored, and index split options are dynamically determined from the monitored database activity. Appropriate action may then be taken based on the dynamically determined index split options. For example, the index may be automatically split using the dynamically determined index split options. A user command that specifies index split options may be compared to the dynamically determined index split options, and if the user command is not compatible with the dynamically determined index split options, the command may be inhibited, or the user may receive a warning message in response to the command. In addition, existing index use may be monitored, and if the monitored index use indicates the index is split poorly, the index may be re-generated using the dynamically determined index split options.

Abstract: Methods, systems, and products are disclosed for synchronizing email content with IM content that include identifying email content having at least a threshold correlation with IM content, merging the email content and IM content, and sending the merged email content and IM content to a recipient.

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 load balancer detects a server failure, and sends a failure notification message to the remaining servers. In response, one or more of the remaining servers may autonomically adjust their configuration parameters, thereby allowing the remaining servers to better handle the increased load caused by the server failure. One or more of the servers may also include a performance measurement mechanism that measures performance before and after an autonomic adjustment of the configuration parameters to determine whether and how much the autonomic adjustments improved the system performance. In this manner server computer systems may autonomically compensate for the failure of another server computer system that was sharing the workload.

Abstract: A handheld electronic book reader, program product, and method incorporate enhanced annotation and/or usage tracking capabilities. Support is provided for user creation of “contexts” for defined terms in an electronic document. Moreover, annotation data such as contexts, comments and highlighting may be associated with various users, and displayed in connection with the display of an electronic document so as to indicate that different annotation data has been originated by different users. In addition, from the standpoint of usage tracking, usage statistics for an electronic document displayed in a handheld electronic reader may be generated on a page-by-page basis, and/or in association with term definitions. Moreover, usage statistics for multiple users may be combined and analyzed.

Abstract: A handheld electronic book reader, program product, and method incorporate enhanced annotation and/or usage tracking capabilities. Support is provided for user creation of “contexts” for defined terms in an electronic document. Moreover, annotation data such as contexts, comments and highlighting may be associated with various users, and displayed in connection with the display of an electronic document so as to indicate that different annotation data has been originated by different users. In addition, from the standpoint of usage tracking, usage statistics for an electronic document displayed in a handheld electronic reader may be generated on a page-by-page basis, and/or in association with term definitions. Moreover, usage statistics for multiple users may be combined and analyzed.

Abstract: An apparatus and method use ontological relationships in a query language and a computer database to improve database performance and utility. A set of ontological relationships are stored in the database and new query clauses are used to query the data in advantageous ways. Ontological relationships are preferably stored in a tree structure. This tree structure then can be used to reflect the ontological relationships of data stored in the columns of a database.

Abstract: An apparatus and method for monitoring the performance of a computer system via an result size including a result set size of accesses to a database and a page size. Preferred embodiments are directed to a performance monitor that correlates data from existing tools that report data concerning access to the database and the use of system resources. Other embodiments are directed to a performance monitor that is included in an application server associated with the database.

Abstract: Database indexes include multiple fields that are used to track how the components of the index are used. An index component monitoring mechanism tracks how the components of the index are used, and updates fields in the index accordingly. Such component-level statistics allow a query optimizer to make more intelligent decisions regarding when to build a new index and when to discard an index, and also provide information regarding which queries are using the index, the maintenance cost of the index, and the selectivity of the index when used to process a query.