Database Client API Call Restructuring for Hosted Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database access methods are inefficient due to the high number of calls required between application servers and hosted databases, leading to poor performance and increased latency, especially when database APIs are designed for local operations rather than remote access.
Innovation Solution
Implementing call batching and call eliding techniques at the database client system to restructure database dependent API calls into fewer, optimized database independent calls, which are then translated and sent over the network, reducing the number of roundtrips and improving performance.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If database dependent API calls are translated directly into database independent API calls without restructuring, then the application can access hosted databases, but the number of calls increases and performance deteriorates
Solution Approach 1:
The patent combines multiple database dependent API calls into a single restructured call before translation. The call restructure module aggregates multiple individual calls into batched operations, reducing the total number of roundtrips between the application server and hosted database system, thereby improving productivity and reducing latency.
Solution Approach 2:
The patent performs preliminary restructuring of API calls before they are translated and sent to the hosted database. By pre-batching and reorganizing calls at the client system, the system prepares optimized call sequences in advance, reducing the number of subsequent network roundtrips and improving overall access efficiency.
2Ease of operation
If multiple database dependent API calls are made sequentially, then complete database operations can be performed, but the number of network roundtrips increases and performance decreases
Solution Approach 1:
The patent merges multiple sequential database dependent API calls into a single restructured call that encompasses all the original operations. This batching approach maintains complete database access capability while significantly reducing the number of network roundtrips, thereby improving call processing efficiency and productivity.
Solution Approach 2:
The restructured call is designed to perform multiple database operations simultaneously through a single call interface. The call restructure module creates a universal call format that can handle multiple original calls within one unified request, enabling multi-functional operation efficiency.
3Adaptability or versatility
If database APIs are designed for local operations, then they provide standardized interfaces, but they are inefficient for remote hosted database access
Solution Approach 1:
The patent introduces a call restructure module as an intermediary between the application's database dependent API calls and the hosted database system. This intermediary component translates and restructures local API calls into optimized formats suitable for remote access, maintaining API compatibility while improving remote access performance through batching and reorganization.
Solution Approach 2:
The patent changes the parameters and structure of API calls to optimize them for remote transmission. The call restructure module modifies call parameters to aggregate multiple operations into single remote calls, changing the call format from individual local operations to batched remote operations, thereby improving productivity while maintaining adaptability.
Data Source
AI summary
A set of one or more database dependent API calls issued by an application are restructured at a database client system to generate a restructured set of database dependent API calls. The restructured set of database dependent API calls are translated at the database client system into one or more database independent API calls. Information representing the one or more database independent API calls is sent from the database client system to a hosted database system such that the hosted database system returns a response to the database independent API calls based on a database access.