Simulated Control of Third-Party Database via Intermediary Proxy
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Companies using third-party databases often face limitations in modifying data, leading to inefficiencies and time-consuming data transfer processes, as third-party providers may not allow unfettered control or data extraction.
Innovation Solution
A system and method that provides simulated control of a third-party database by using a simulation control proxy to intercept queries, store modification data, and update result sets, allowing clients to manage updates without directly modifying the third-party database, thereby enabling efficient data management.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of energy
If a company uses a third-party database to store data, then cost is reduced (no need to invest in servers and IT equipment), but control over data modification is lost and data transfer becomes time-consuming
Solution Approach 1:
The patent introduces a simulation control proxy as an intermediary layer between the client and the third-party database. This proxy intercepts modification queries from the client, translates them into readable queries, and manages the synchronization process. The intermediary enables the client to exercise control over data modifications without directly accessing or modifying the third-party database, thus resolving the contradiction between cost savings from using third-party storage and the need for operational control.
2Ease of operation
If a company copies data from a third-party database to another database to enable modification, then control over data is improved, but efficiency deteriorates and time is lost due to the copying process
Solution Approach 1:
The patent uses a virtual copy mechanism where the simulation control proxy creates a virtual representation of the third-party database schema and data structures in memory. This virtual copy allows the client to perform modifications on the copied structure without physically transferring data, eliminating the time-consuming data copying process while maintaining full control over data modifications.
Solution Approach 2:
The system performs preliminary actions by pre-fetching data from the third-party database and storing it in a local cache or memory buffer before modification operations are needed. This preliminary data loading enables subsequent modification operations to be performed efficiently without repeated data transfer, thus improving productivity while maintaining control.
3Ease of operation
If a company transfers all data out of a third-party database domain, then full control is achieved, but the process becomes time-consuming and some providers do not allow it
Solution Approach 1:
The patent extracts only the essential data and schema information from the third-party database that is needed for modification operations, rather than transferring the entire database. The simulation control proxy extracts the necessary data structures, metadata, and current data states, allowing full control over modifications while minimizing data transfer time and avoiding restrictions imposed by third-party providers.
Data Source
AI summary
An example method of providing simulated control of a third-party database to a client includes receiving, at a simulation control proxy, a query that selects data from a database table stored in a third-party database. The method also includes submitting, over a network, the query to the third-party database. The method further includes loading a set of database records included in an initial result set of the query. The method also includes determining whether a data storage device includes modification data indicating that the initial result set is stale. The method further includes updating the initial result set in accordance with the modification data if the initial result set is stale. The method also includes sending the updated result set of the query to a client. The updated result set of the query is different from the initial result set of the query.