Abstract: A method, apparatus, and computer program product are disclosed for managing query execution plans for a workload. In one embodiment, the method includes gathering an initial set of performance characteristics generated from a database management system (DBMS) executing a database workload according to one or more query execution plans (QEPs). The database workload includes one or more database statements. The method determines a QEP change for one or more QEPs of the database workload. In addition, the method gathers a subsequent set of performance characteristics generated from the DBMS executing the one or more QEPs of the database workload influenced by the QEP change. Furthermore, the method determines a performance difference created by the QEP change based on the initial set of performance characteristics and the subsequent set of performance characteristics and responds to the performance difference in accordance with a monitoring policy.

Abstract: A method, computer program product, and infrastructure for accessing a remote application running on a system A by a system B, each being connected to an open network and located behind a firewall, are provided. The method, computer program product, and infrastructure provide for system A sending a first HTTP request to system B via the open network, blocking the first HTTP request from system A till an application request is available at system B, system B sending an HTTP response to system A via the open network, the HTTP response comprising the application request, system A processing the application request from system B to generate an application response, system A sending a second HTTP request to system B via the open network, the second HTTP request comprising the application response, and blocking the second HTTP request from system A till another application request is available at system B.

Abstract: A method, system, and computer program product for merging monitoring data streams includes: receiving a first monitoring data stream relating to a server containing first records, each first record has a first transaction identifier relating to a first transaction and first monitoring data, relating to a performance of executing the first transaction; receiving a second monitoring data stream relating to a client containing second records, each second record has a list of second transaction identifiers relating to one or more second transactions and second monitoring data, relating to a performance of executing the second transactions; buffering at least parts of the first and the second monitoring data streams; and merging the buffered first and second monitoring data streams by computing an outer-join with a join-condition that the first records have the first transaction identifier that occurs in the list of second transaction identifiers to provide a merged data stream.

Abstract: A method, computer program product, and system for performance monitoring of a computer resource utilized by a user community. The computer resource is monitored, and sets of performance metrics characterizing a state of the computer resource are collected and analyzed to detect performance incidents. External information such as contextual information and user annotations are also collected and analyzed. If a performance incident is detected, its set of performance metrics and associated external information are used to search a data repository of past performance incidents for related incidents, in order to identify critical performance incidents, determine recommended solutions for the performance incidents, and determine performance forecasts for the computer resource.

Abstract: A method, computer program product, and system for performance monitoring of a computer resource utilized by a user community. The computer resource is monitored, and sets of performance metrics characterizing a state of the computer resource are collected and analyzed to detect performance incidents. External information such as contextual information and user annotations are also collected and analyzed. If a performance incident is detected, its set of performance metrics and associated external information are used to search a data repository of past performance incidents for related incidents, in order to identify critical performance incidents, determine recommended solutions for the performance incidents, and determine performance forecasts for the computer resource.

Abstract: A method, computer program product, and system for performance monitoring of a computer resource utilized by a user community. The computer resource is monitored, and sets of performance metrics characterizing a state of the computer resource are collected and analyzed to detect performance incidents. External information such as contextual information and user annotations are also collected and analyzed. If a performance incident is detected, its set of performance metrics and associated external information are used to search a data repository of past performance incidents for related incidents, in order to identify critical performance incidents, determine recommended solutions for the performance incidents, and determine performance forecasts for the computer resource.

Abstract: The present invention provides database systems configured for creating and utilizing a transactions predictive model using a computer, the database system including: a database management system (DBMS) for handling transactions in the database system, the DBMS including a prediction component for generating the transactions predictive model; a database workload table for capturing commands associated with the transactions, the commands utilized for generating the transactions predictive model; database data for providing data in response to the transactions; and a prediction model database for storing the transactions predictive model, where the prediction component is configured for generating a generalized statement for each statement corresponding with the transactions, identifying a sequence of transactions of the transactions, creating a transaction class based on the sequence of transactions, identifying a current transaction, and then calculating probabilities between transactions, where each statemen

Abstract: Methods of generating a transactions prediction model using a computer for optimizing a number of transactions associated with a database system include capturing a database workload, where the database workload includes a number of statements corresponding with the transactions over a specified period of time, where each of the statements includes a variable parameter; then generating a generalized statements from the statements by replacing the variable parameter with a constant value; then generating other generalized statements, where if two or more of the number of the generalized statements are the same grouping the generalized statements to correspond with the other generalized statements; and then creating transaction classes, where each of the transaction classes includes at least one generalized statements.

Abstract: A method, computer program product, and system for performance monitoring of a computer resource utilized by a user community. The computer resource is monitored, and sets of performance metrics characterizing a state of the computer resource are collected and analyzed to detect performance incidents. External information such as contextual information and user annotations are also collected and analyzed. If a performance incident is detected, its set of performance metrics and associated external information are used to search a data repository of past performance incidents for related incidents, in order to identify critical performance incidents, determine recommended solutions for the performance incidents, and determine performance forecasts for the computer resource.

Abstract: A method, system, and computer program product for a multi-resolution storage scheme for historical data are provided. The method includes dividing the historical data into a plurality of time frames and determining an amount of compression for each of the time frames, where at least two of the time frames have a different amount of compression. The method further includes applying the amount of compression to each of the time frames, resulting in multi-resolution historical data, and storing the multi-resolution historical data.

Abstract: A method, system, and computer program product for merging monitoring data streams includes: receiving a first monitoring data stream relating to a server containing first records, each first record has a first transaction identifier relating to a first transaction and first monitoring data, relating to a performance of executing the first transaction; receiving a second monitoring data stream relating to a client containing second records, each second record has a list of second transaction identifiers relating to one or more second transactions and second monitoring data, relating to a performance of executing the second transactions; buffering at least parts of the first and the second monitoring data streams; and merging the buffered first and second monitoring data streams by computing an outer-join with a join-condition that the first records have the first transaction identifier that occurs in the list of second transaction identifiers to provide a merged data stream.

Abstract: The present solution addresses the need to carry out reorganization of a database storage. A statistics-based reorganization check procedure is performed on at least first database tables and indexes, resulting in a preliminary reorganization recommendation. Information on workload on tables and indexes of said database storage is received. Based on the information on workload and the preliminary reorganization recommendation, it is decided whether to carry out reorganization of the database storage in accordance with the preliminary reorganization recommendation.

Abstract: A method, apparatus, and computer program product are disclosed for managing query execution plans for a workload. In one embodiment, the method includes gathering an initial set of performance characteristics generated from a database management system (DBMS) executing a database workload according to one or more query execution plans (QEPs). The database workload includes one or more database statements. The method determines a QEP change for one or more QEPs of the database workload. In addition, the method gathers a subsequent set of performance characteristics generated from the DBMS executing the one or more QEPs of the database workload influenced by the QEP change. Furthermore, the method determines a performance difference created by the QEP change based on the initial set of performance characteristics and the subsequent set of performance characteristics and responds to the performance difference in accordance with a monitoring policy.

Abstract: Providing tracking information about events in a virtual world using a computer is presented including: causing the computer to provide a re-usable code portion, the re-usable code portion configured with a unique identifier and an address of an external data storage; causing the computer to configure at least a set of events to be tracked for sending information about tracked events to the external data storage; causing the computer to associate the re-usable code portion with a virtual object to be tracked in the virtual world. In some embodiments, methods are presented wherein the causing the computer to associate the re-usable code portion with the virtual object comprises causing the computer to integrate the re-usable code portion on a source code level into the virtual object.

Abstract: A database access controlling system controls the access to a database from a database access layer in an application, especially a relational database, with data sets that are being accessed concurrently by reading and writing transactions. The present system performs changes on the data by a writing transaction that place the changed data in a marked state. The changed data in the marked state enables concurrent transactions to recognize that the data has just been changed.

Abstract: A method for scheduling a workload comprising a plurality of transactions relating to a database management system is disclosed. The method comprises the steps of determining a log space amount required by each transaction in the workload, estimating the total log space required for executing the workload based on the log space amounts required by each transaction, and scheduling execution of the workload based on the estimated total log space.

Abstract: Methods for optimizing data access in a row-oriented relational database containing data sets having attributes using a computer are presented the method including: causing a computer to analyze a database workload to determine an access frequency for each of the attributes; causing the computer to assign each of the attributes to a priority classes corresponding with the access frequency, where the priority classes include a higher priority class and a lower priority class, and where a higher priority class corresponds with a higher access frequency and a lower priority class corresponds with a lower access frequency; causing the computer to store the attributes in accordance with the classes, where the attributes assigned to the higher priority class are stored in a high priority storage medium, and where the attributes assigned to a lower priority class are stored in a low priority storage medium.

Abstract: Methods of generating a transactions prediction model using a computer for optimizing a number of transactions associated with a database system are presented, the methods including: capturing a database workload, where the database workload includes a number of statements corresponding with the transactions over a specified period of time, where each of the number of statements includes a variable parameter; generating a number of first generalized statements from the number of statements by replacing the variable parameter with a constant value; generating a number of second generalized statements, where if two or more of the number of first generalized statements are the same grouping the two or more of the number of first generalized statements to correspond with the number of second generalized statements; creating a number of transactions classes, where each of the number of transaction classes includes at least one of the number of first generalized statements.

Abstract: A method, system, and computer program product for a multi-resolution storage scheme for historical data are provided. The method includes dividing the historical data into a plurality of time frames and determining an amount of compression for each of the time frames, where at least two of the time frames have a different amount of compression. The method further includes applying the amount of compression to each of the time frames, resulting in multi-resolution historical data, and storing the multi-resolution historical data.

Abstract: A method, system, and computer program product for a multi-resolution storage scheme for historical data are provided. The method includes dividing the historical data into a plurality of time frames and determining an amount of compression for each of the time frames, where at least two of the time frames have a different amount of compression. The method further includes applying the amount of compression to each of the time frames, resulting in multi-resolution historical data, and storing the multi-resolution historical data.