Invention Grant
- Patent Title: Automatic determination of table distribution for multinode, distributed database systems
-
Application No.: US17037484Application Date: 2020-09-29
-
Publication No.: US11429584B2Publication Date: 2022-08-30
- Inventor: Juchang Lee , KiYong Lee , Nosub Sung
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Klarquist Sparkman, LLP
- Main IPC: G06F16/20
- IPC: G06F16/20 ; G06F16/22 ; G06F16/27 ; G06F16/23 ; G06F16/2455

Abstract:
Technologies are described for improving the performance of distributed database systems. The technologies provide suggested table distributions that can reduce the performance overhead associated with database operations that involve multiple nodes, and can provide more even distribution of computing resource use. In a particular example, a method includes minimizing a scoring function that includes a plurality of performance metrics, at least a portion of the metrics being associated with a weight. Candidate table distributions can be analyzed in an iterative manner to determine a lowest-score distribution. A final table distribution can be output, such as to a user.
Public/Granted literature
- US20210011898A1 AUTOMATIC DETERMINATION OF TABLE DISTRIBUTION FOR MULTINODE, DISTRIBUTED DATABASE SYSTEMS Public/Granted day:2021-01-14
Information query