US 11,893,015 B2
Optimizing query performance in virtual database
Hai Jun Shen, Tianjin (CN); Chang Sheng Liu, Haidian (CN); Ying Qi Pan, Beijing (CN); and Liam Loucks, Calgary (CA)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Nov. 18, 2021, as Appl. No. 17/455,532.
Prior Publication US 2023/0153302 A1, May 18, 2023
Int. Cl. G06F 16/2453 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/24542 (2019.01) [G06F 16/256 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer implemented method comprising:
collecting, by one or more processor, real time system statistics on a system environment in a remote platform running a remote data source amongst a plurality of remote data sources of a virtual database, wherein the remote data sources of the virtual database are heterogeneous database management systems run on respective remote platforms across disparate geographical locations;
gathering, by the one or more processor, real time data source statistics on one or more data source objects from the remote data source of the virtual database;
updating, by the one or more processor, a global catalog of the virtual database with the real time system statistics from the collecting and the real time data source statistics from the gathering;
optimizing, by the one or more processor, an access plan to process a query submitted to the virtual database from a client application based on the real time system statistics and the real time data source statistics in the global catalog; and
producing, by the one or more processor, a response corresponding to the query by executing the access plan to thereby improve both a response time of the query and a cost of processing.