Selective Data Extraction for Client-Server Communication Load Reduction
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional client-server database systems face significant communication load and resource wastage by downloading all master data to the client, which is unnecessary for processing, limiting user operations and causing inefficient data management.
Innovation Solution
The system downloads only the target data required for processing from the server to the client, along with related data items, and displays them in a selectable mode via a user interface, allowing users to operate beyond the limited data space without downloading all data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If all data in the master DB is downloaded to the local DB to ensure data integrity, then data consistency between server and client is improved, but communication load increases enormously
Solution Approach 1:
The patent extracts and downloads only the specific target data required for client processing from the master DB, rather than downloading all data. This selective extraction approach maintains data consistency for necessary operations while significantly reducing communication load and network resource consumption.
Solution Approach 2:
The system implements partial action by downloading only a subset of data (target data) rather than the complete dataset. This allows the client to perform necessary processing with minimal data transfer, avoiding the excessive communication overhead of synchronizing entire databases while maintaining sufficient data consistency for the intended operations.
2Adaptability or versatility
If all data is downloaded to the client, then complete data processing capability is improved, but resource consumption and storage requirements increase
Solution Approach 1:
The patent extracts only the target data necessary for specific processing tasks from the master DB and transfers it to the client. This selective data extraction enables the client to perform required processing operations without storing or managing the entire dataset, thereby reducing resource consumption and storage requirements while maintaining adequate processing capability.
3Loss of energy
If difference information is downloaded to update the local DB, then communication load is reduced, but data integrity cannot be guaranteed for specific processing requirements
Solution Approach 1:
The system performs preliminary action by pre-downloading the specific target data required for client processing from the master DB before offline operations begin. This ensures that the necessary data is available locally with guaranteed integrity for the intended processing tasks, while still minimizing communication load by avoiding unnecessary data transfers.
Data Source
AI summary
In a server (10), all column data items are extracted from a master data storage unit (11) and sent to a client (20) in addition to target data corresponding to a data acquisition request that has been sent from the client (20), and in the client (20), the target data and data items received from the server (10) are displayed on a screen in a user-interface selectable mode, thereby making it possible to download from the server (10) to the client (20) the minimum target data required when attempting to perform a desired process on the client (20), and doing away with the waste associated with downloading all the data. In addition, by also downloading and displaying in a selectable manner on a screen data items pertaining to data other than the target data, a user can be shown, in an operable-like manner, data items pertaining to actual data without downloading the actual data.