Abstract: A system, method, and computer-usable medium for implementing flash forward queries. According to a preferred embodiment of the present invention, a database predictive manager receives a specification of at least one database structure as a candidate for a flash forward query, which predicts a condition of the at least one database structure at a predetermined future time. Database predictive manager tracks changes made to the at least one database structure utilizing a history database. In response to receiving a flash forward query, database predictive manager presents results of the flash forward query, wherein the results are calculated based on extrapolating data obtained from the change tracking of the at least one database structure.

Abstract: A link structure and method for linking therein. The link structure includes a first page of a website and may include a global page of the website. The first page includes a link that has a default pointer and may have a local pointer, a global pointer, or both. The local pointer points to a local page and the global pointer points to the global page. A local link structure includes the local pointer but not the global pointer. A global link structure includes the global pointer but not the local pointer. A hybrid link structure includes the local pointer and the global pointer. Linking within the link structure may include linking from the link to the local page through the local pointer or linking from the link to the global page through the global pointer.

Abstract: A method, apparatus and computer program product are provided for implementing performance impact reduction of watched variables. Source code is parsed and a variable in the source code to be watched is identified. The identified variable is allocated to a predefined page of storage. The predefined page of storage is separated from frequently accessed variables, such as, a page containing least frequently modified variables, a last page associated with a static storage, and a separate page added for receiving the identified variables to be watched.

Abstract: In an embodiment, a query tree is created that represents a query expression, where the query tree includes a union of nodes. Each of the nodes represents a respective partition of a table, and the query expression specifies a key value and the table. A determination is made whether a result set exists that includes the key value, where the result set was previously retrieved from the table. If the determination is true, a decision is made based on the result set whether the key value is stored in the respective partition represented by each of the nodes. The nodes for which the key value is not stored in the respective partition are removed from the query tree to create an optimization tree, and the optimization tree is used to retrieve data from the table. In this way, nodes that are not necessary to be searched may be removed from query trees, in order to increase the performance of the query.

Abstract: A system, method, and computer-usable medium for interfacing an application with a database; implementing a collection of indexes, wherein the collection of indexes facilitate faster access by the application to data stored in the database; detecting a query by the application to the database for particular data; and in response to detecting the query, utilizing a collection of factors to determine whether a new index should be created within the collection of indexes to facilitate access to the particular data.

Abstract: Embodiments of the invention provide a method, article of manufacture, and an apparatus used to optimize a database query. Query tools often generate database queries that include unnecessary function calls. Embodiments of the invention provide a mechanism to analyze and remove function calls included in a database query. If removing an embedded function call will not alter a set of query results returned in response to the database query, then the query may be rewritten to remove the embedded function calls.

Abstract: Methods, apparatus, and computer program products are disclosed for autonomic performance management by selecting a performance management function, identifying a set of instructions capable of being analyzed using the performance management function, and determining whether to execute the performance management function on the identified set of instructions in dependence upon historical performance data of the identified set of instructions.

Abstract: Methods, apparatus, and products for evaluating a current partitioning of a database are disclosed that include querying each database partition of the database with an identical query statement, measuring performance of each database partition query, and identifying database partition characteristics of the current partitioning of the database in dependence upon the measured performance.

Abstract: A code optimizer is used to optimize a computer program that references a database by reading database metadata and making suitable optimizations based on the metadata. By taking into account the metadata of a database referenced in the computer program, the optimizer may make suitable optimizations to the computer program. Such optimizations include, without limitation, removing unnecessary calls to the database, removing unnecessary loops, removing unnecessary database operations, providing compile-time errors, and replacing dynamic calls with static data.

Abstract: A debugger inserts instrumentation hooks in a multi-threaded computer program that allow collecting a program trace and that provide timestamps that correspond to the program trace. When a breakpoint in a first thread is encountered, a timestamp corresponding to the breakpoint is retrieved. Execution of the other threads may continue until the debugger is able to halt their execution. Once the execution of all threads has been halted, the program trace for each thread is traced backwards to a point where the timestamp is less than the breakpoint timestamp. Instructions are then executed, one by one, until the execution time of the instructions plus the timestamp is approximately the same as the breakpoint timestamp. The instruction in the program trace display is then highlighted to indicate the instruction that was likely being executed when the breakpoint in the first thread is encountered.

Abstract: Methods, apparatus, and computer program products are disclosed for debugging a computer program in a distributed debugger that include defining a conditional breakpoint conditioned upon one or more attributes of a remote execution environment, debugging the computer program in a debug session in the remote execution environment, and retrieving debug information at the breakpoint conditioned upon one or more attributes of the remote execution environment.

Abstract: A profiler collects profile data according to a defined trigger specification, a defined level specification, and an optional defined skip specification. The profiler begins collecting profile data when the trigger specification is satisfied. The profiler monitors stack frames on a call stack, and collects profile data for the defined level from the current stack frame. A skip specification may also be defined that allows skipping the collecting of profile data for specified jar files, packages, classes, or methods. In this manner, a profiler may collect profile data up to a specified level from the current stack frame while specifically skipping the collection of profile data according to the defined skip specification.

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: An apparatus, program product and method improve reporting of performance data in computing systems having uncapped partitions, or partitions that can borrow computer resources. A system measures or otherwise determines time of processor use or another metric that relates to the actual use of a computer resource by the uncapped logical partition. The metric is determined during a computer operation that may include a thread or job, and that may span an interval or period of intervals. The system uses the metric to estimate what the response time would have been if a capped logical partition was alternatively used. Information derived from this estimated response time is reported to the user.

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 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: 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: A method and system for controlling an automatic transmission is disclosed. The method and system include obtaining positioning data using a global positioning satellite (GPS) and monitoring the automatic transmission to obtain transmission data. The method and system also include learning whether performance of the automatic transmission can be improved utilizing the positioning data and the transmission data. Moreover, the method and system include adjusting a shift threshold for the positioning data for the automatic transmission if it is determined that the performance of the automatic transmission can be improved.

Abstract: Method, article of manufacture and apparatus for playing back recorded database activity in a graphical user interface. Chronologically ordered database event information is dynamically displayed in a user interface having user-selectable graphical elements associated with predefined playback controls.