Mobile Dashboard Data Caching via Selective Query Parameters
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Mobile devices face challenges in accessing large database data due to limited storage capacity and unreliable communication links, leading to incomplete local data storage and hindered access to remote database information.
Innovation Solution
Implementing a data caching mechanism that allows users to specify cache parameters for selectively storing relevant data from a remote database locally on a mobile device, enabling access even when communication with the remote database is degraded or lost.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If the mobile device stores only a small fragment of database data locally, then the device's limited storage capacity is respected, but access to complete database information is hindered when network connection is lost
Solution Approach 1:
The patent extracts only the necessary and relevant data from the remote database and stores it locally in a cache memory. This selective extraction allows the mobile device to have access to critical information offline while respecting the storage capacity constraints of the mobile device.
Solution Approach 2:
The patent performs preliminary caching of database data before the network connection is lost. By proactively storing relevant data in the cache memory while the network is available, the system ensures that information is accessible even when the connection deteriorates or is lost, thus improving access reliability.
2Loss of information
If the mobile device constantly accesses the remote database, then complete database information is available, but energy consumption increases and access is hindered when network connection is lost
Solution Approach 1:
The system performs preliminary data retrieval and caching while the network connection is available, storing relevant database information in the mobile device's cache memory. This preliminary action reduces the need for frequent network accesses, thereby lowering energy consumption while maintaining information availability.
Solution Approach 2:
The patent creates a local copy of the necessary database data in the cache memory. This copy allows the mobile device to access information without constantly communicating with the remote database, thus reducing energy consumption associated with network transmissions while ensuring information is available offline.
3Reliability
If the mobile device stores more data locally, then access reliability improves when network is lost, but the device's limited storage capacity is exceeded
Solution Approach 1:
The patent extracts only the necessary and relevant data from the remote database for local caching. By selectively identifying and storing only the data that is essential for offline functionality, the system improves access reliability without exceeding the mobile device's limited storage capacity.
Solution Approach 2:
The system implements partial caching by storing a subset of the total database data locally - specifically, only the data that is most relevant and frequently accessed. This partial action approach balances storage constraints with the need for reliable offline access, avoiding the excess of storing complete database data.
4Quantity of substance
If the mobile device uses selective caching with user-defined parameters, then storage efficiency is improved, but system complexity increases
Solution Approach 1:
The caching mechanism is designed to automatically manage data storage and retrieval based on user-defined parameters. The system self-adjusts by monitoring data access patterns and automatically caching relevant information without requiring complex manual intervention, thus improving storage efficiency while keeping the user interface simple.
Solution Approach 2:
The patent allows users to define caching parameters such as data selection criteria and cache size limits. By changing these parameters, the system adapts the caching behavior to different user needs and storage constraints, improving storage efficiency while maintaining a relatively simple underlying caching mechanism that can be configured through parameter adjustments.
Data Source
AI summary
Embodiments provide a data caching mechanism based on a user's request (query) to a remote database, and the corresponding response (query result) received therefrom. As part of a database query, the user can define cache parameter(s). When a viable communications link becomes available to access the remote database, volumes of relevant data are returned as a query result and cached locally according to those predefined cache parameter(s). Embodiments are particularly suited to allow a mobile device to interact with data of a remote database in an efficient and reliable manner. The mobile device's small form factor, may preclude local storage of large volumes of remotely stored data. However, this can be compensated for by selectively storing data in the cache memory according to user-specified parameters, allowing the mobile device to continue to have access to relevant information in the event that communication with the remote database is degraded or lost.