Optimizing query performance in virtual database
US11893015B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 18, 2021 |
| Grant date | Feb 6, 2024 |
| Priority date | — |
| Expiry date | Dec 2, 2041 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/256
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods, computer program products, and systems are presented. The methods include, for instance: collecting 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. Real time data source statistics on one or more data source objects from the remote data source of the virtual database is also gathered. A global catalog of the virtual database is updated with the real time system statistics and the real time data source statistics. An access plan to process a query to the virtual database is optimized based on the real time system statistics and the real time data source statistics and a response is produced based on the access plan, with improved performance and reduced cost.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.