Patent · US Active

Self-optimizing table distribution with transparent replica cache

US10289726B2 · kind B2 · utility

0Cited by

2References

20Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Oliver Benke · Stuttgart, DE
Jan Kunigk · Eppelheim, DE
Stefan Letz · Eppelheim, DE

Key dates

Filing date	Nov 19, 2015
Grant date	May 14, 2019
Priority date	—
Expiry date	Nov 11, 2037

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/278
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Storing data in a distributed database management system. The distributed database management system includes a first set of database tables, wherein data of a logical database table is distributed among the first set of database tables according to a first distribution key. A second set of database tables is maintained using a second distribution key that is different from the first distribution key. Furthermore, at least one performance metric value for the stored query when executing a query is maintained, and the second distribution key is determined based on the at least one performance metric value.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.