Sap Se

Carsten Mueller

Christian Bensberg

Hans-Joerg Leu

Jochen Becker

Johannes Beigel

Alexander Schroeder

Andreas Thumfart

Srinivas Gajjalakonda

Fei Qiu

Dan Ding

The present disclosure provides more efficient techniques for removing a host from a multi-host database system. An instruction to remove a host system may be received. In response, a determination of whether the first host system does or does not store any source tables is made based on a host-type identifier for the host system. This determination may not require obtaining landscape information for each of the hosts in the database system. If the host system stores replica tables and does not store source tables, those replica tables may be dropped based on the determination that the first host system does not store any source tables. As such, in cases where table redistribution is not needed the landscape information is not obtained, thereby making the host removal process more efficient.

Multihost database host removal shortcut

A node type of a plurality of distributed nodes to which a table to be added to a distributed database should be assigned can be identified by applying a set of placement rules defined for the table. The set of placement rules can also be applied to determine whether the table should be partitioned into more than one partition. A table group name associated with the table can be obtained and used in conjunction with the node type and determination of whether to partition the table to store the table in the distributed database on at least one node of the plurality of nodes as one or more partitions.

Table placement in distributed databases

A system includes generation of a definition of a table including a partitioning column of the table and a threshold size, allocation of a first memory partition for the table, determination that a size of the records of the table in the first memory partition is greater than the threshold size, and, in response to the determination that the size of the records of the table in the first memory partition is greater than the threshold size, determination that a maximum value of the partitioning column in the records of the table in the first memory partition, determination of a minimum value of the partitioning column in the records of the table in the first memory partition, generation of metadata indicating that records of the table in which the value of the partitioning column is in a range between and including the minimum value and the maximum value are stored in the first memory partition, and allocation of a second memory partition for the table.

Dynamic range partitioning

Growing community of inventors

Bruchsal, Germany

Carsten Mueller