Patent · US Active

Query optimization in hybrid DBMS

US11061899B2 · kind B2 · utility

1Cited by

4References

10Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Andreas Brodt · Gerlingen, DE
Oliver Draese · Los Gatos, US
Ruiping Li · Shanghai, CN
Daniel Martin · Stuttgart, DE

Key dates

Filing date	Dec 12, 2017
Grant date	Jul 13, 2021
Priority date	—
Expiry date	Dec 12, 2037

Classification

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

Abstract

A mechanism is provided for generating statistical information for query optimization in a data processing system. The mechanism comprises a first database engine maintaining a current first dataset currently being stored, a second database engine maintaining a second dataset. The second dataset is generated from previous first datasets or from the previous first datasets and current first dataset, the previous first datasets being datasets that were previously maintained by the first database engine. The first database engine receives a database query for accessing the first dataset, the database query involving one or more attributes of the first data set. The first database engine generates a query execution plan for the database query on the first dataset using collected statistical information on at least the second dataset. The first database engine processes the database query according to the query execution plan.

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