Abstract: A method and system for performing an operation on protected sensitive data. A processor of a data processing system receives, from a computing system: (i) the protected sensitive data, (ii) an identification of an operation that accesses and utilizes the protected sensitive data during performance of the operation, and (iii) a request to perform the operation, wherein the computing system is external to the data processing system. The processor de-protects the received protected sensitive data, which generates unprotected sensitive data from the protected sensitive data. The processor performs the operation, which includes accessing and utilizing the unprotected sensitive data and generating a result. After the operation is performed, the processor re-protects the unprotected sensitive data, which restores the protected sensitive data. The processor sends the result to the computing system.

Abstract: A method and associated systems for a transparent tunneling architecture for a secured database. A tunneling driver captures a user's database-access request before it can be blocked by a security gateway. The driver translates the request into a Web-service request, where the requested Web service is implemented by means of classes or objects that correspond to database operations. The request is formatted into a standard database-independent form that the security gateway allows to pass to the database server intact. A Web-service runtime environment interprets the requested Web service, thereby instructing the server-side database-management application to respond to the user's access request. In a reverse procedure, the database's response is translated into a Web-service response to the requested Web service that may similarly tunnel through the security gateway, and that is then translated back into a form that may be properly interpreted by the requesting user's client application.

Abstract: A method and associated systems for a transparent tunneling architecture for a secured database. A tunneling driver captures a user's database-access request before it can be blocked by a security gateway. The driver translates the request into a Web-service request, where the requested Web service is implemented by means of classes or objects that correspond to database operations. The request is formatted into a standard database-independent form that the security gateway allows to pass to the database server intact. A Web-service runtime environment interprets the requested Web service, thereby instructing the server-side database-management application to respond to the user's access request. In a reverse procedure, the database's response is translated into a Web-service response to the requested Web service that may similarly tunnel through the security gateway, and that is then translated back into a form that may be properly interpreted by the requesting user's client application.

Abstract: Provided are techniques for extending functionality of an application. A request to create an application object is received. In response to receiving the request, the application object is created, and an extension proxy object is created. The extension proxy object is wrapped around the application object. An invocation of a function of the extension proxy object is received from the application object.

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: Techniques are provided for tuning work. In response to identifying a trigger for a work, automatic tuning is invoked. The trigger indicates that a performance goal for the work has been missed. The work is analyzed. A tuning operation is selected for the work based on a tuning history. The selected tuning operation is implemented for the work.

Abstract: Providing information of a monitored system through a graphical user interface (GUI) of a monitoring application to support simplified or automatic identification of events. The method includes initiating an event pattern script recording. The method also includes keeping track of user actions on said GUI and on activated GUI panels during said event pattern script recording by requesting a user to specify, once the user activates a further GUI panel, which panel information in a current GUI panel triggered activation of said further GUI panel and based on what criterion the triggering occurred. The user specified information results in triggering information. The method also includes, in response to receiving an indication that an event has been identified, stopping said event pattern script recording. The method also includes, storing said event pattern script recording, GUI panel information and said triggering information.

Abstract: A method, system, and computer program product for providing information of a monitored system through a graphical user interface (GUI) of a monitoring application to support simplified or automatic identification of events. The method includes, among other possible operations, initiating an event pattern script recording. The method also includes keeping track of user actions on said GUI and on activated GUI panels during said event pattern script recording by requesting a user to specify, once the user activates a further GUI panel, which panel information in a current GUI panel triggered activation of said further GUI panel and based on what criterion the triggering occurred. The user specified information results in triggering information. The method also includes, in response to receiving an indication that an event has been identified, stopping said event pattern script recording.

Abstract: Providing information of a monitored system through a graphical user interface (GUI) of a monitoring application to support simplified or automatic identification of events. The method includes initiating an event pattern script recording. The method also includes keeping track of user actions on said GUI and on activated GUI panels during said event pattern script recording by requesting a user to specify, once the user activates a further GUI panel, which panel information in a current GUI panel triggered activation of said further GUI panel and based on what criterion the triggering occurred. The user specified information results in triggering information. The method also includes, in response to receiving an indication that an event has been identified, stopping said event pattern script recording. The method also includes, storing said event pattern script recording, GUI panel information and said triggering information.

Abstract: A method for tuning a database system is disclosed. A tuning strategy is received comprising a first procedure to determine a suggested tuning action, and a second procedure to measure performance of the database system. The suggested tuning action is determined and pre-action performance measured according to the respective procedures. Undo information that indicates how to undo the database system state change of the suggested tuning action is recorded in a database system state history. After executing the suggested tuning action, post-action database system performance is measured according to the second procedure. When the post-action performance is lower than the pre-action performance, the database system state change is undone using the undo information. Embodiments enabling to create new tuning strategies, downloading existing tuning strategies, sharing own tuning strategies and changing existing tuning strategies are disclosed as well.

Abstract: Provided are techniques for extending functionality of an application. A request to create an application object is received. In response to receiving the request, the application object is created, and an extension proxy object is created. The extension proxy object is wrapped around the application object. An invocation of a function of the extension proxy object is received from the application object.

Abstract: A method, system, and computer program product for providing information of a monitored system through a graphical user interface (GUI) of a monitoring application to support simplified or automatic identification of events. The method includes, among other possible operations, initiating an event pattern script recording. The method also includes keeping track of user actions on said GUI and on activated GUI panels during said event pattern script recording by requesting a user to specify, once the user activates a further GUI panel, which panel information in a current GUI panel triggered activation of said further GUI panel and based on what criterion the triggering occurred. The user specified information results in triggering information. The method also includes, in response to receiving an indication that an event has been identified, stopping said event pattern script recording.

Abstract: A method, system, and computer program product are provided for operating a relational database management system (RDBMS). In order to operate a RDBMS, information is read from a first execution plan in response to an execution request for a second individual database statement of a second sequence of database statements. The information is processed and pool resource requirements for execution of further individual database statements of the second sequence of database statements are evaluated. A preparation request is sent for pool modification based on the evaluated pool resource requirements to an asynchronous pool preparation queue. Then the second individual database statement of the second sequence of database statements is executed. The information indicative of the progression of execution of the second individual database statement is stored in a position register.

Abstract: Embodiments of the invention provide techniques for troubleshooting of computer systems using a fault tree analysis. In one embodiment, data parameters describing a status of a system may be monitored to determine the existence of a fault. In the event of a fault, fault tree analysis metadata may be evaluated to attempt to determine a root cause of the fault. If a root cause can be automatically determined, it may be presented to a user in a troubleshooting console, or may be used to trigger an automated corrective action. Alternatively, if a root cause cannot be automatically determined, the user may be presented with additional fault tree analysis metadata and any relevant data parameters in the troubleshooting console, so that the user may determine the root cause of the fault event.

Abstract: A computer-implemented method is disclosed. The method includes collecting cache-efficiency-indicator values of an at least one cache fragment during operation of a database system over a period of time. Providing approximation-function-parameter values for the collected, cache-efficiency-indicator values, an approximation function representing a relation between a cache-efficiency-indicator and the size of a respective cache fragment. The method continues by providing a set of workload windows based on the approximation-function-parameter values. Next, providing a workload-window information for the set of workload windows, the workload-window information including at least one approximation-function-parameter value representing each determined workload window. The method further includes storing the workload-window information for a comparison based on current, cache-efficiency-indicator values and the workload-window information.

Abstract: Provided are techniques for monitoring information. In response to a database process starting, a monitoring agent is loaded under control of the database process, wherein the monitoring agent invokes a discovery service to discover a central server and monitoring service. Under control of the monitoring agent, monitor information about the database process is sent to the central server and monitoring service.

Abstract: Embodiments of the invention provide techniques for troubleshooting of computer systems using a fault tree analysis. In one embodiment, data parameters describing a status of a system may be monitored to determine the existence of a fault. In the event of a fault, fault tree analysis metadata may be evaluated to attempt to determine a root cause of the fault. If a root cause can be automatically determined, it may be presented to a user in a troubleshooting console, or may be used to trigger an automated corrective action. Alternatively, if a root cause cannot be automatically determined, the user may be presented with additional fault tree analysis metadata and any relevant data parameters in the troubleshooting console, so that the user may determine the root cause of the fault event.

Abstract: A system and method are disclosed to improve processing time of a database system by continuous automatic background optimization of a cache memory that is fragmented into a plurality of cache fragments. The system and method include collecting indicators about efficiency of individual cache fragments by at least one of measuring a cache hit ratio of each cache fragment, measuring a processing time that a CPU of the database system needs to prepare data in the individual cache fragments, and measuring execution time the CPU needs to process the data in accordance with a SQL query. The system and method include calculating and revising approximation curves for measured values of each cache fragment to find a combination of cache fragment sizes with a highest system throughput. The system and method include changing the sizes of the cache fragments to receive highest system throughput.

Abstract: A method, computer program product, and system for triggering an update of statistics data used by a query optimizer of a relational database management system for determining an optimal execution plan for executing a received query request on a relational database is provided. A system dependent nominal performance value for executing the query request on a database system is determined. Additionally, an average actual performance value is determined by processing the query request. If a comparison between the average actual performance value and the system dependent nominal performance value yields a result which is greater than a first threshold value, an update cost value and a cost saving value are determined. If a comparison between the cost saving value and the update cost value yields a result which is greater than a second threshold value, the statistics data is updated.

Abstract: A method, system, and computer program product are provided for operating a relational database management system (RDBMS). In order to operate a RDBMS, information is read from a first execution plan in response to an execution request for a second individual database statement of a second sequence of database statements. The information is processed and pool resource requirements for execution of further individual database statements of the second sequence of database statements are evaluated. A preparation request is sent for pool modification based on the evaluated pool resource requirements to an asynchronous pool preparation queue. Then the second individual database statement of the second sequence of database statements is executed. The information indicative of the progression of execution of the second individual database statement is stored in a position register.