Sap Se

Antje Heinle

Hans-Joerg Leu

Daniel Biliniewicz

Methods, systems, and articles of manufacture, including computer program products, are provided for clustering tables. In some implementations the system can include at least one processor and at least one memory. The memory can include program code that provides operations when executed by the processor. The operations can include: retrieving from a first table information source a first set of table pairing association, retrieving from a second table information source a second set of table pairing associations, creating a set of table connections from the first set of table pairing associations and the second set of table pairing associations, creating a table grouping from the set of table connections, and distributing one or more tables to one or more nodes in a distributed database system, wherein the one or more tables are distributed to the one or more nodes in using the table grouping.

Distributing tables in a distributed database using consolidated grouping sources

A method, a system, and a computer program product for performing analysis of object dependencies. A first base object is selected from a plurality of base objects. At least one first dependent object in a plurality of dependent objects depends on the selected first base object. A group of base objects that includes the selected first base object is generated. A second base object in the plurality of base objects is determined. The first dependent object is dependent on the second base object. The determined second base object is grouped with the generated group of base objects. At least one second dependent object in the plurality of dependent objects and its corresponding base object are determined. The corresponding base object is grouped with the generated group of base objects. The generated group of base objects is stored.

Dependent object analysis

An allocation of tables across a distributed database provides for taking into account existing table groups while also obtaining newly calculated table groups by complementing the existing table groups with regards to the results of the new allocation. Maintaining and protecting one or more types of existing table groups allows for the existing table groups to not be overwritten during allocation of the tables. An identification of tables is used, as well as a determination related to connections between the existing table groups and the newly calculated table groups.

Complementing existing tables while grouping tables in a distributed database

An allocation of tables across a distributed database provides for taking into account existing table groups while also obtaining newly calculated table groups that are formed according to a new table group allocation. Such a new table group allocation may be desired to optimize workload balancing and/or data transfers for new workload patterns. Maintaining one or more types of existing table groups allows for the existing table groups to not be overwritten during allocation of the tables. An identification of tables is used, as well as a selected user-defined grouping option to indicate a mode for maintaining or replacing the existing table groups. An iterative process includes assigning, for each table, a group name and a group type.

Grouping tables with existing tables in a distributed database

In one respect, there is provided a method. The method can include identifying, based on a plurality of queries executed at a distributed database, a disjoint table set. The identifying of the disjoint table set can include: identifying a first table used in executing a first query; identifying a second query also using the first table used in executing the first query; identifying a second table used in executing the second query but not in executing the first query; and including, in the disjoint table set, the first table and the second table. The method can further include allocating, based at least on the first disjoint table set, a storage and/or management of the first disjoint table set such that the first disjoint table set is stored at and/or managed by at least one node in the distributed database. Related systems and articles of manufacture are also disclosed.

Grouping tables in a distributed database

In one respect, there is provided a method. The method can include identifying, based on a plurality of queries executed at a distributed database, a disjoint table set. The identifying of the disjoint table set can include: identifying a first table that is used in executing a first query; identifying a second query that also uses the first table used in executing the first query; identifying a second table that is used in executing the second query but not in executing the first query; and including, in the disjoint table set, the first table and the second table. The method can further include allocating, based on the disjoint table set, a storage and/or management of the disjoint table set such that subsets of the disjoint table set are stored at and/or managed by different nodes in the distributed database system. Related methods and articles of manufacture are also disclosed.

Growing community of inventors

Muehlhausen, Germany

Antje Heinle