International Business Machines Corporation

Karl Fleckenstein

Jens Peter Seifert

Oliver Augenstein

Stefan Bender

Andreas Uhl

Thomas Rech

Dirk Nakott

Hans-Jürgen Zeltwanger

Holger Hellmuth

Alexander Zietlow

Martin Jungfer

Gunter Dueck

Andreas Rudolph

Hans-Martin Wallmeier

Tobias Scheuer

Peter Korevaar

Heinrich Stuettgen

Martin M&auml;hler

Thomas Holey

Sven Viergutz

A system and method for a database management system. The method comprises: receiving a database transaction for inserting a set of records in a database table of the database management system or for creating indexes. The database transaction may be executed using the database management system. The database management system may rollback the database transaction by truncating the database table or the created indexes.

Rolling back a database transaction

A method for generating a copy of a database using a data streaming protocol is disclosed. The method comprises setting up a structure of a secondary database, prioritizing data objects to be copied from a primary database to the secondary database, copying data objects from the primary database to the secondary database using a data streaming protocol, restoring data corresponding to the data object in the secondary database in parallel to copying data objects from the primary database to the secondary database, applying changes made to the data corresponding to the data object in the primary database during the time of copying, after the data object has been copied, and making available the secondary database for usage once all data objects have been copied from the primary database to the secondary database so that a usable copy of the primary database is created.

Efficient creation of a secondary database system

A tool for replacing a first database node of a database management system by a second database node. The tool receives an indication that the first database node received a data access request for accessing a database shared between the first database node and the second database node. The tool duplicates the data access request at the first database node. Responsive to a determination that the duplicated data access request includes a data changing statement and a previously executed statement, the tool modifies the duplicated data access request to prevent execution of the data changing statement and the previously executed statement at the second database node. The tool executes the modified duplicated data access request at the second database node. The tool replaces, based on a replacement condition being met, the first database node with the second database node in the database management system.

Managing nodes of a DBMS

Embodiments for managing data in a hierarchical storage server storing data blocks of a database system comprising primary storage devices being in an active mode and secondary storage devices being in one of an active and passive mode are provided. In response to read and write requests for data blocks at logical storage locations, a block mapping device determines physical storage locations on the storage devices. Read requests switch over secondary storage devices to the active mode when they are in the passive mode. Write requests write data blocks only to the primary storage devices. Secondary storage devices that have not been accessed for a minimum activation time may be switched over from the active to the passive mode to save power consumption and cooling. Data migration and data recall policies control moving of data blocks between the primary and secondary storage devices and are primarily based on threshold values.

Hierarchical storage management for database systems

In response to read and write requests for data blocks at logical storage locations, a block mapping device determines physical storage locations on the storage devices. Read requests switch over secondary storage devices to the active mode when they are in the passive mode. Write requests write data blocks only to the primary storage devices. Secondary storage devices that have not been accessed for a minimum activation time may be switched over from the active to the passive mode to save power consumption and cooling. Data migration and data recall policies control moving of data blocks between the primary and secondary storage devices and are primarily based on threshold values.

Disclosed is a mechanism to control telecommunication connections via digital switching networks like the ISDN. Frequently observed scenarios are a caller who is connected to an answering machine, although he intended to talk to a human individual, or where a node is shared by more than one individual and the caller wants to talk to a definite person likewise. Subscriber information is interchanged between a calling device and a called device before setting up the connection which is utilized to inform the caller about the device type at the called side or to inform the called side about the desired person. In the ISDN, a called device sends an ALERTING message to a switching center before accepting the connection. The switching center forwards a part of that message to the calling device which includes the so-called USER&mdash;USER Information Element (UUIE). In that USER&mdash;USER IE, an information like &ldquo;UNDER THE CALLED NUMBER AN ANSWERING MACHINE IS BECOMING ACTIVE&rdquo; can be coded. The USER&mdash;USER IE is transmitted by the ISDN network transparently to the calling device and thus can be presented to the calling participant via a display device. Alternatively, a different dial tone can be generated by the calling device to inform the participant about the answering machine.

Mechanism to control telecommunication connections in a digital switching network

Growing community of inventors

Malsch, Germany

Karl Fleckenstein