Patent · US Active

Query and data adaptive synopsis table

US12332887B2 · kind B2 · utility

0Cited by

0References

14Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Oliver Schiller · Seligenstadt, DE
Tobias Kevin Fränzel · Rötteln, DE
James L. Finnie · Eppelheim, DE
Thomas Friedhelm Böhme · Hessenhöfe, DE
Toni Bollinger · Weil der Stadt, DE
Wieland Hoffmann · Hannover, DE

Key dates

Filing date	Sep 18, 2023
Grant date	Jun 17, 2025
Priority date	—
Expiry date	Sep 18, 2043

Classification

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

Abstract

Aspects of the invention include techniques for providing a query and data adaptive synopsis table. A non-limiting example method includes building a first synopsis table containing metadata for a database table. Information from queries executed against the database table is collected. The collected information is analyzed, responsive to a number of queries executed against the database table exceeding a query collection threshold, to identify one or more queries for which the first synopsis table was suboptimal. The method includes building, for each of the one or more queries for which the first synopsis table was suboptimal, a second synopsis table.

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