Local Database Foreign Query Execution via Intermediary Interface
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Local database systems often lack the capability to process certain query functions, limiting their ability to execute queries that require specialized processing capabilities not originally designed into the system.
Innovation Solution
A processor-based apparatus in the local database system connects to a foreign database system, exports query data, sends query requests, and imports result datasets, enabling the foreign system to process queries that the local system cannot handle, using a parsing engine and interconnect to facilitate parallel data transfer and execution.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If the local database system only processes queries it was originally designed for, then system simplicity and reliability are maintained, but the system cannot execute query functions beyond its original capabilities
Solution Approach 1:
The patent introduces a foreign function interface as an intermediary layer between the local database system and foreign database systems. This interface enables the local system to execute queries on foreign systems without requiring the local system itself to have the specialized processing capabilities, thus maintaining system simplicity while achieving extended functionality.
Solution Approach 2:
The local database system is enhanced with universal query execution capability by integrating foreign function interface support. This allows the system to handle both native queries and foreign database queries through a unified interface, achieving multi-functionality without fundamentally changing the core system architecture.
2Adaptability or versatility
If the local database system exports data to and imports data from foreign database systems, then query processing versatility is improved, but data transfer time and system complexity increase
Solution Approach 1:
The system performs preliminary actions by establishing connection pools and pre-configuring foreign function interfaces before query execution. Data export and import operations are optimized by preparing transfer buffers and connection pathways in advance, reducing the actual data transfer time when queries need to be executed on foreign systems.
Data Source
AI summary
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.