Offline Database Delta Updates for Memory-Constrained Devices
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data transfer methods to mobile devices for offline use are inefficient, particularly for devices with limited memory and processing resources, as they often require parsing and formatting of large datasets, consuming significant memory and processing resources.
Innovation Solution
A method where a server system generates an initial database for a client device and transmits it, followed by delta updates, which include instructions for inserting, deleting, or modifying database records, allowing the client device to efficiently update its local database without the need for extensive data parsing and formatting.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If large datasets are pre-loaded onto mobile devices for offline use, then data availability for offline work is improved, but memory consumption and processing resource usage increase significantly
Solution Approach 1:
The patent segments data transfer into two phases: an initial bulk transfer of the complete database, followed by selective delta transfers for updates. This segmentation allows the device to have comprehensive data available offline while minimizing the amount of data transmitted and processed during updates, thereby reducing memory consumption and processing resource usage.
Solution Approach 2:
The patent performs preliminary action by pre-loading the complete database onto the mobile device before offline use begins. This ensures data availability is established in advance, and subsequent updates only need to transfer delta changes rather than entire datasets, reducing ongoing memory and processing requirements.
2Reliability
If complete databases are transferred to client devices, then data completeness is improved, but data transfer time and processing resources increase
Solution Approach 1:
The patent segments data transfer into initial complete database transfer and subsequent delta updates. This allows the device to receive complete data initially for offline use, while future updates only transfer changed records, significantly reducing repeated transfer time and maintaining data completeness efficiently.
Solution Approach 2:
The patent discards the need to re-transmit entire databases by implementing delta updates that only transfer changed records. This recovering approach maintains data completeness by applying only necessary changes rather than re-downloading complete datasets, thereby reducing transfer time.
3Measurement precision
If extensive data parsing and formatting is performed during transfer, then data accuracy is improved, but processing resource consumption increases
Solution Approach 1:
The patent extracts only the necessary data changes (delta) from the complete database and transfers only those specific updates to the mobile device. This extraction approach maintains data accuracy by ensuring all changes are captured while minimizing the amount of data parsing and formatting required, thereby reducing processing resource consumption.
Solution Approach 2:
The patent applies partial action by transferring only the delta changes rather than complete datasets during updates. This partial approach maintains sufficient data accuracy for offline operations while significantly reducing processing resource consumption compared to parsing and formatting entire databases.
Data Source
AI summary
Disclosed are some implementations of systems, apparatus, methods and computer program products for transmitting data to a client device. A first database is generated for a client device and a client identifier of the client device is stored in association with the first database. The first database is transmitted to the client device responsive to receiving a first message from the client device. After transmitting the first database to the client device and responsive to receiving a second message from the client device, data relevant to the client device is ascertained. A delta between database records stored in the first database and the data is generated. A database message is generated and transmitted to the client device, where the database message indicates the delta and includes a client directive pertaining to updating the first database according to the delta.