Automatic determination of table distribution for multinode, distributed database systems
US10824611B2 · kind B2 · utility
1Cited by
0References
19Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jul 5, 2018 |
| Grant date | Nov 3, 2020 |
| Priority date | — |
| Expiry date | Feb 4, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/27
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Improvements to the performance of distributed database systems are described. Suggested table distributions are provided that can reduce the performance overhead associated with database operations that involve multiple nodes, and can provide more even distribution of computing resource use. A method includes minimizing a cost 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-cost distribution. A final table distribution can be output, such as to a user.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.