Patent · US Active

Offloading statistics collection

US11182386B2 · kind B2 · utility

0Cited by

3References

20Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Dennis Butterstein · Stuttgart, DE
Oliver Benke · Stuttgart, DE
Tobias U. Bergmann · Eppelheim, DE
Felix Beier · Haigerloch, DE
Terence P. Purcell · Springfield, US

Key dates

Filing date	Mar 24, 2020
Grant date	Nov 23, 2021
Priority date	—
Expiry date	Mar 24, 2040

Classification

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

Abstract

Methods and systems for generating database statistics. Table statistics in a metadata catalog of a source database system are observed, statistics generation costs utilizing a target database system are estimated, and source statistics generation costs utilizing a source database system are estimated. The statistics generation costs are compared and statistics generation queries by the target database system are triggered in response to the statistics generation costs utilizing the target database system having a predefined relationship with the source statistics generation costs utilizing the source database system. The statistics generation queries are performed by the target database system in response to the triggering by the source database system. The generated statistics are sent from the target database system to the source database system, the table statistics in a metadata catalog are updated based on the generated statistics, and the updated table statistics are used to optimize a query plan.

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