Offline Data Access via Key-Value Pair Cross-Referencing

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current information handling systems lack a generic approach to replicate database schemas and content for offline access on mobile devices when network connectivity is unavailable, especially for online data sources based on relational databases.

Innovation Solution

A system and method that utilize key-value pairs to cross-reference online and offline data, allowing offline data to be stored and synchronized on user devices for access and synchronization, using a data management agent to handle interactions between user device applications, online, and offline data managers.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If data is stored online in relational databases, then data structure organization is efficient, but offline access on mobile devices is not possible without network connectivity

Engineering Contradiction:

Improvedata availabilityVSAvoidoffline access capability

Core Design Contradiction:

ReliabilityVSAdaptability or versatility

Solution Approach 1:

The patent creates a copy of online data and stores it locally on mobile devices. The offline data manager replicates data from online sources, enabling access without network connectivity. This copying approach resolves the contradiction by making data available offline while maintaining the original online data structure.

Inventive Principle:

Principle #26Copying

Solution Approach 2:

The patent introduces an offline data manager as an intermediary layer between online data sources and mobile applications. This mediator handles data synchronization, conversion, and storage, allowing applications to access data offline without directly interacting with online relational databases.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Adaptability or versatility

If data structures are replicated for offline access, then offline data availability is improved, but porting to different data sources becomes difficult

Engineering Contradiction:

Improveoffline data accessVSAvoiddata structure porting

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent creates a universal offline data manager that can handle multiple data sources and types. The system uses a standardized key-value pair interface that works across different online data sources, eliminating the need to port data structures for each specific source while maintaining offline access capability.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The patent transforms complex relational data structures into simplified key-value pairs. This parameter change in data representation makes the data portable and adaptable to different sources while maintaining offline access functionality, reducing the complexity of porting operations.

Inventive Principle:

Principle #35Parameter changes

3Speed

If offline data is stored locally, then access speed is improved, but data synchronization with online sources becomes complex

Engineering Contradiction:

Improvedata access speedVSAvoidsynchronization operations

Core Design Contradiction:

SpeedVSDevice complexity

Solution Approach 1:

The patent implements a feedback-based synchronization mechanism where the offline data manager continuously monitors changes in online data and automatically updates local copies. The system uses version tracking and change detection to determine when synchronization is needed, simplifying the synchronization process while maintaining fast offline access.

Inventive Principle:

Principle #23Feedback

Solution Approach 2:

The patent performs data synchronization in advance when network connectivity is available, preparing offline data before it is needed. This preliminary action ensures that data is already synchronized and ready for fast offline access, reducing the complexity of real-time synchronization operations.

Inventive Principle:

Principle #10Preliminary action

4Adaptability or versatility

If a generic approach is used to replicate database schemas, then adaptability to different data sources is improved, but implementation complexity increases

Engineering Contradiction:

Improvedata source compatibilityVSAvoidreplication implementation

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent transforms diverse database schemas into a unified key-value pair representation. This parameter change abstracts away the complexities of different data source schemas while maintaining a generic, adaptable interface. The offline data manager handles the complexity of schema replication internally, presenting a simple unified interface to applications.

Inventive Principle:

Principle #35Parameter changes

Data Source

PatentUS10831731B2Method for storing and accessing data into an indexed key/value pair for offline access

Publication Date: 2020.11.10 DELL PROD LP

AI summary

A system, method, and computer-readable medium are disclosed for managing the storage, access and synchronization of offline data. A set of online data, which is available for online access, is persisted as a set of offline data in a local storage associated with a user device and a key-value pair is used to cross-reference the first set of online data and the first set of offline data. An access request for a set of data, corresponding to the first set of online data, is received from a user device application. The access request is then processed to determine whether the first set of online data is available for online access. If it is, then the first set of online data is provided to the user device application for processing. Otherwise, the first set of offline data is provided to the user device application for processing.