Virtual Parameterized Data Object for Federated Database Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database federation techniques struggle to provide remote access to parameterized data objects due to schema inaccessibility, making it difficult to retrieve and process data from remote systems effectively.
Innovation Solution
Creating a virtual parameterized data object at a local system that stores parameter information from a remote system, allowing for the formulation and execution of database operations using data federation, ensuring correct request formatting and execution.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If database federation techniques are used to access remote data objects, then data access capability is improved, but the ability to access parameterized data objects with schema information remains insufficient
Solution Approach 1:
A virtual parameterized data object is created as an intermediary between the local database system and the remote parameterized data object. This virtual object contains schema information and parameter definitions that enable the local system to properly format and send requests to the remote system, effectively mediating the access between systems with different schema accessibility capabilities
Solution Approach 2:
The schema information and parameter definitions from the remote parameterized data object are copied and stored in the virtual parameterized data object at the local system. This copying enables the local system to have access to the necessary schema information without needing to directly access the remote system's schema, resolving the accessibility issue
2Productivity
If remote parameterized data objects are accessed directly, then data retrieval is possible, but request formatting correctness cannot be ensured due to schema inaccessibility
Solution Approach 1:
The virtual parameterized data object is prepared in advance with complete schema information and parameter definitions before actual data retrieval operations. This preliminary setup ensures that when data retrieval requests are formed, the correct formatting can be automatically generated based on the pre-stored schema information, guaranteeing request accuracy
3Adaptability or versatility
If data replication is used to enable access, then data availability is improved, but resource usage increases
Solution Approach 1:
Instead of replicating entire data sets, only the essential schema information and parameter definitions are extracted from the remote parameterized data object and stored in the virtual object at the local system. This selective extraction provides data availability for request formatting while minimizing resource consumption compared to full data replication
Data Source
AI summary
Techniques and solutions are provided for providing federated data access to parameterized data objects. At a local system, a virtual parameterized data object is created. A remote computing system is contacted to obtain parameters used by a parameterized data object of the remote computing system to which the virtual parameterized data object corresponds. Parameter information received from the remote system is stored in a definition of the virtual parameterized data object at the local system. When a request for a database operation involving the virtual parameterized data object is received, the parameter information can be used to determine whether the request is correctly formed, or can be used in preparing a request to be sent to the remote system to be performed using the parameterized data object to obtain information specified in the request for a database operation.