The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Feb. 18, 2025
Filed:
Apr. 27, 2023
International Business Machines Corporation, Armonk, NY (US);
Venkatesh S. Gopal, Overland Park, KS (US);
Brajesh Pandey, Shrewsbury, MA (US);
Nadiya Kochura, Bolton, MA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
Method and apparatus for optimized data partition selection for related queries. A query to be executed over a plurality of data records is received. The plurality of data records comprises a first set of data records stored in a first database distributed across a plurality of partitions and a second set of data records stored in a second database. An input vector is generated based on the query, the first and second databases. The input vector is processed using a machine learning (ML) model to predict a cost for executing the query if one or more data records in the second set of data records are loaded to a first partition of the first database. A plan is selected for loading the one or more data records from the second set of data records to the first partition based on the predicted cost for executing the query.