CPC G06F 16/24542 (2019.01) [G06F 16/256 (2019.01)] | 20 Claims |
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.
|