Sap Se

Sap Ag

Torsten Strahl

Henrik Hempelmann

Robin Wissbrock

Andre Schefe

Martin Brunzema

Bernd Vorsprach

Uwe H O Hahn

Martin Kittel

Hans-Georg Bumes

Christian Bensberg

Stefan A Baeuerle

Alexander Boehm

Frank Renkes

Uwe Hahn

Henrik Hampelmann

Uwe HO Hahn

A system includes reception, at a target database system, of a request to recover a backup created by a source database system into the target database system, where the request comprises a system identifier of the source database system, determination of a backup tool configuration file associated with the source database system based on the system identifier of the source database system, request of a recovery of the backup into the target database system using the backup tool configuration file, copying of a backup catalog of the source database system into a storage location associated with the target database system, and appending of a system change marker to the copied backup catalog, wherein the system change marker comprises the system identifier of the source database system.

Database recovery after system copy

A system includes reception of a first query at a first host, determination, at the first host, that the first query is associated with a first table, the first table including geographically-restricted data and a partitioning column storing identifiers of geographic restrictions, determination, at the first host and based on the partitioning column of the first table and on the first query, a first partition of the first table and a storage location of the first partition, and execution of the first query at the first host in conjunction with the storage location of the first partition.

Platform-based data segregation

A system includes reception, at a target database system, of a request to recover a backup created by a source database system into the target database system, determination of a backup tool configuration file associated with the source database system, determination of a filepath of the backup, determination of a backup filepath associated with the target database system, and request of a recovery of the backup using the backup tool configuration file, wherein the request using the backup tool configuration file includes the filepath of the backup and the backup filepath associated with the target database system.

Database recovery using foreign backups

A system includes reception of a command to recover a database to a point in time, determining a log backup which covers the point in time, determination of a sequence identifier associated with the log backup, collection of log backups which are older than the determined log backup and associated with the sequence identifier, and a data backup associated with the sequence identifier, and execution of a recovery of the database based on the determined log backup and the collected log backups and data backup.

Recovery strategy with dynamic number of volumes

A method, medium, and system to receive a request to remove a service of an instance of a distributed database system; redistribute data of the service to be removed to at least one remaining service of the distributed database system; save unsaved log segments of the service to be removed in a log backup; register removal of the service to be removed with the distributed database system; delete an entry of the service to be removed from a startup configuration of the distributed database system; halt operation of the service to be removed; and remove the halted service from internal topology information of the distributed database system.

Method and system to remove a service from a distributed database system

A system includes obtaining of a backup of the source database system comprising N hosts and a first plurality of servers, where N is an integer greater than one, access of a target database system comprising M hosts, where M is an integer less than N, configuration of the target database system to include the first plurality of servers, and performance of a database recovery of the target database system using the backup of the source database system.

N to M host system copy

A method, medium, and system to receive a request to perform a log recovery to restore multiple database services; determine log backup entries corresponding to a target log position for a first database service of the multiple database services; read from a sequential stream device, by the first database service, the log backup entries corresponding to the target log position for the first database service; inform a second database service of the multiple database services that the first database service has concluded executing the log backup entries corresponding to the target log position for the first database service from the sequential stream device; assuring that no resources of the streaming device are blocked by the first database service; and read log backup entries of the second database service corresponding to a target log position for the second database service from the sequential stream device.

Method and system to avoid deadlocks during a log recovery

An executing database instance includes a first plurality of database pages associated with a previous state of the database instance, a cache storing a current converter of the executing database instance, the current converter not representing the first plurality of database pages, and a database management system. The database management system is to receive a request for access to the first plurality of database pages, and perform a database task using one or more of the first plurality of database pages while the database instance is executing.

Online access to database snapshots

A system includes a database instance having a data storage system with a data store area storing first and second data partitions, where the respective data partitions each include a plurality of database pages storing respective tenant-independent/-specific data and respective first/second converters associated with the respective partitions. A database management system (DBMS) to receive a request for a database object and determine whether the database object is associated with tenant-independent data or with tenant-specific data. If the database object is associated with tenant-independent data, the DBMS determines a location of first database pages associated with the database object within the first plurality of database pages based on the first converter. Or if associated with tenant-specific data, the DBMS determines a location of second database pages associated with the database object within the second plurality of database pages based on the second converter. A method is also disclosed.

Method and system for determining database object associated with tenant-independent or tenant-specific data, configured to store data partition, current version of the respective convertor

A system may include reading a provider database mapping of file identifiers to page numbers of the provider database, determining one or more shared database objects of the provider database based on the provider database mapping, and registering the one or more shared database objects in a local namespace of a reader database.

Sharing of database objects

A system may include a provider database, a reader database, and a database management system. The provider database may include a provider data area having a plurality of provider block addresses, and the reader database may include a reader data area having a plurality of reader block addresses, and a mapping of provider-specific identifiers to block addresses of the plurality of provider data pages and of reader-specific identifiers to block addresses of the plurality of reader data pages. The database management system may modify a database object of the reader database, the object being is associated with a provider-specific identifier; and modify the mapping to map the provider-specific identifier to a first block address of one of the plurality of reader data pages.

Writable shared database objects

A system to delete a data volume may include storage of a plurality of data pages of the data volume of a data area into a cache, prevention of writing of data pages to the data volume, and designation of each of the plurality of data pages in the cache as modified. The system may also include writing of all data pages in the cache that are designated as modified to a respective location in one or more other data volumes of the data area, and updating, for each of the written data pages, a converter page of the cache to associate the written data page with its respective location in the one or more other data volumes.

Online data volume deletion

A system, method, apparatus, means and computer program code for writing data includes identifying a plurality of pages to be written to a data volume, each page including a file identifier and a key, creating a first page group from the plurality of pages, the first page group including pages associated with a first file as identified by the file identifier and sorted by the key; and writing the first page group to the data volume.

Growing community of inventors

Kleinmachnow, Germany

Torsten Strahl