International Business Machines Corporation

Stefanie Scherzinger

Torsten Steinbach

Markus Buehler

Thomas Schwarz

Rainer Dorsch

Guenther Hutzl

Andreas Trinks

Cagri Balkesen

Gregor Moehler

Daniel Pfefferkorn

David Rohr

Michael W Kaufmann

Michal Bodziony

Rafal Korczyk

Sergej Schuetz

Helmut Baumgartner

Christian Gaege

Steffen Kabisch

A method according to one embodiment includes receiving information from a performance monitoring facility of a database at a data protection manager implemented at least in part in hardware, wherein the performance monitoring facility is configured to measure performance of the database, wherein the data protection manager is configured to control a backup operation of the database on a storage subsystem. The backup operation is started, and the performance monitoring facility is informed about the starting of the backup operation. In response to receiving an indication that a predefined performance criterion has been violated, information from the performance monitoring facility is received at the data protection manager, the data protection manager causing compliance with the predefined performance criterion in response to the information.

Performing a background copy process during a backup operation

Reroutable data columns are identified in an ETL process by receiving an ETL process definition describing a set of processing stages and how each processing stage output data column is a result of a function that operates on a set of input data columns, representing the ETL process definition as a directed graph with nodes representing processing stages and links representing data flow between processing stages, traversing at least part of the directed graph and identifying a set of subsequent nodes of the directed graph where at least one data column is involved only as input data in identity functions, the at least one data column being reroutable between outmost nodes of the set of subsequent nodes, and in connection with traversing the at least part of the directed graph, maintaining information about reroutable data columns and the respective outmost nodes.

Identifying reroutable data columns in an ETL process

In one embodiment, a system includes a performance monitoring facility of a database adapted for measuring performance of the database regularly, a data protection manager for controlling a backup operation of the database on a storage subsystem, logic adapted for providing an interface between the performance monitoring facility of the database and the data protection manager, logic adapted for starting the backup operation while informing the performance monitoring facility about the starting of the backup operation, logic adapted for continuously evaluating performance of the database to determine when a predefined performance criterion is violated, and logic adapted for sending information from the performance monitoring facility to the data protection manager to cause compliance with the predefined performance criterion in response to the predefined performance criterion being violated.

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.

System and method for merging monitoring data streams from a server and a client of the server

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.

Performance monitoring of a computer resource

The present invention relates to a method and respective system for operating a DRAM main memory. One buffer line is provided for multiple pages. When writing data to the buffer it is decided which to which buffer-line the data is written to based on its destination main memory address. A tuple consisting of lower memory address and data is stored. Data entered into the buffer-line will be sorted by page in case the line is flushed to the main memory. Sorting the buffer entries results in less page openings and closings, since the data is re-arranged by memory address and therefore in logical order. By using one line for multiple pages only a fraction of memory of a common set-associative cache is needed, thus decreasing the amount of overhead significantly.

Write buffer for improved DRAM write access patterns

First and second sets of numbers are received in an input range, which is separated into sub ranges. A first sub range is processed by initializing bits of a memory to a first logical state and by changing the initial state of each of the bits corresponding to a received number of the first set that is within the first sub range. Each number received in the second set is compared to a bit in the memory to identify a set of received numbers that are in the first sub range and that are in both the first set and the second set. The comparing is responsive to detecting a change of initial state of any bit in the memory during the processing of the first sub range. The processing and comparing is repeated for remaining sub ranges to identify received numbers that are in both the sets.

Growing community of inventors

Boeblingen, Germany

Stefanie Scherzinger