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:
Jun. 24, 2025
Filed:
Nov. 28, 2023
International Business Machines Corporation, Armonk, NY (US);
Sheng Yan Sun, Beijing, CN;
Xu Qin Zhao, Beijing, CN;
Jian Xu, Beijing, CN;
Peng Hui Jiang, Beijing, CN;
International Business Machines Corporation, Armonk, NY (US);
Abstract
Computer implemented methods, systems, and computer program products include program code executing on a processor(s) to: obtain queries (each query including workload(s)); obtain execution statistics for the one or more workloads; normalize one or more queries. Normalizing includes generating cost analytics, identifying similar cost analytics for query blocks across the queries, and applying a cost model to identify at least one query block for result reuse across. The program code distributes the queries to system resources by assigning the at least one query block (in more than one query/workload) to a first resource to execute (as part of a first workload) against database tables and assigning the at least one query block to a second resource to execute (as part of a first workload) against a shared cache of a heterogenous database system.