Patent ID: 10860581

Abstract:
An apparatus is provided for facilitating a local database system to execute a query function at a foreign database system. The apparatus comprises a processor of the local database system and a storage device communicatively coupled with the processor. The processor is programmed to (i) receive a query request, (ii) retrieve query data associated with the query request, (iii) determine if the query request can be processed at the local database system, (iv) if the query request is unable to be processed at the local database system, connect to the foreign database system, (v) after the local database system is connected to the foreign database system, export the retrieved query data from the local database system to the foreign database system to allow the foreign database system to process the retrieved query data, (vi) after the retrieved query data has been exported from the local database system to the foreign database system, send the query request from the local database system to the foreign database system to allow the foreign database system to process the query request using the retrieved query data, and (vii) after the foreign database system has processed the query request using the query data, import a result dataset from the foreign database system.