IP Library › Granted Patent US 10,831,731
Granted Patent B2
US 10,831,731 · App. 14/205,595 · Granted Nov 10, 2020

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

Inventor: Luis J. Botero (Austin, TX)
Assignee: Dell Products L.P.
G06F16/22G06F16/2372G06F16/27
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,831,731
App. No.
14/205,595
Granted
Nov 10, 2020
Kind
B2
Abstract

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.

Claims (66)

1. A computer-implementable method for managing offline data via an offline data management system, the offline data management system executing on a hardware processor of an information handling system, the offline data management system comprising a user device application, user device local data storage, a data management agent, an offline data manager, an online data manager, the online data manager accessing data from an online data source via a network, comprising:

persisting a copy of a first set of online data received from the online data source via the online data manager as a first set of offline data in a local storage associated with a user device, the first set of online data available for online access, the first set of offline data being stored within the user device local data storage using the offline data manager; and

using, via the data management agent, a key-value pair to cross-reference the first set of online data and the first set of offline data, the data management agent detecting data access requests from the user device application and managing interactions between the user device application, the offline data manager and the online data manager, each key-value pair comprising a key portion and a value portion,

the key portion comprising a data type representing an origin or data category and a unique identifier, the key portion corresponding to associated data, the associated data comprising an authentication token corresponding to the data type and a data container corresponding to the unique identifier; and,

the value portion comprising a header associated with the data container and a body, the header comprising metadata, the metadata comprising keep offline metadata indicating whether the offline data needs to be kept offline once connectivity is achieved, and the body comprising a serialized version of the offline data, the serialized version of the offline data being defined in a source database schema; and wherein

a provider of the online data source determines when to use the data management agent to store or retrieve data when access to the network is not available.

2. The method of claim 1 , further comprising:

receiving an access request for a set of data corresponding to the first set of online data;

processing the access request to determine if the first set of online data is available for online access; and

providing the first set of online data if it is available for online access.

3. The method of claim 2 , further comprising:

providing the first set of offline data if the first set of online data is not available for online access.

4. The method of claim 3 , further comprising:

retrieving the first set of offline data from the local storage; and

processing the first set of offline data and the first set of online data to determine if the first set of offline data is different than the first set of online data.

5. The method of claim 4 , further comprising:

performing synchronization operations to synchronize the first set of online data with the first set of offline data.

6. The method of claim 3 , further comprising:

retrieving a second set of offline data from the local storage;

processing the second set of offline data and the first set of online data to determine if the second set of offline data is new; and

persisting a copy of the second set of offline data as a second set of online data if it is.

7. A system comprising:

a hardware processor;

a data bus coupled to the processor; and

a non-transitory, computer-readable storage medium embodying computer program code, the non-transitory, computer-readable storage medium being coupled to the data bus, the computer program code interacting with a plurality of computer operations for managing offline data via an offline data management system, the offline data management system executing on the hardware processor of an information handling system, the offline data management system comprising a user device application, user device local data storage, an offline data manager, an online data manager, the online data manager accessing data from an online data source via a network and comprising instructions executable by the processor and configured for:

persisting a copy of a first set of online data received from the online data source via the online data manager as a first set of offline data in a local storage associated with a user device, the first set of online data available for online access, the first set of offline data being stored within the user device local data storage using the offline data manager; and

using, via the data management agent, a key-value pair to cross-reference the first set of online data and the first set of offline data, the data management agent detecting data access requests from the user device application and managing interactions between the user device application, the offline data manager and the online data manager, each key-value pair comprising a key portion and a value portion,

the key portion comprising a data type representing an origin or data category and a unique identifier, the key portion corresponding to associated data, the associated data comprising an authentication token corresponding to the data type and a data container corresponding to the unique identifier; and,

the value portion comprising a header associated with the data container and a body, the header comprising metadata, the metadata comprising keep offline metadata indicating whether the offline data needs to be kept offline once connectivity is achieved, and the body comprising a serialized version of the offline data, the serialized version of the offline data being defined in a source database schema; and wherein

a provider of the online date data source determines when to use the data management agent to store or retrieve data when access to the network is not available.

8. The system of claim 7 , further comprising:

receiving an access request for a set of data corresponding to the first set of online data;

processing the access request to determine if the first set of online data is available for online access; and

providing the first set of online data if it is available for online access.

9. The system of claim 8 , further comprising:

providing the first set of offline data if the first set of online data is not available for online access.

10. The system of claim 9 , further comprising:

retrieving the first set of offline data from the local storage; and

processing the first set of offline data and the first set of online data to determine if the first set of offline data is different than the first set of online data.

11. The system of claim 10 , further comprising:

performing synchronization operations to synchronize the first set of online data with the first set of offline data.

12. The system of claim 9 , further comprising:

retrieving a second set of offline data from the local storage;

processing the second set of offline data and the first set of online data to determine if the second set of offline data is new; and

persisting a copy of the second set of offline data as a second set of online data if it is.

13. A non-transitory, computer-readable storage medium embodying computer program code for managing offline data via an offline data management system, the offline data management system executing on a hardware processor of an information handling system, the offline data management system comprising a user device application, user device local data storage, an offline data manager, an online data manager, the online data manager accessing data from an online data source via a network, the computer program code comprising computer executable instructions configured for:

persisting a copy of a first set of online data received from the online data source via the online data manager as a first set of offline data in a local storage associated with a user device, the first set of online data available for online access, the first set of offline data being stored within the user device local data storage using the offline data manager; and

using, via the data management agent, a key-value pair to cross-reference the first set of online data and the first set of offline data, the data management agent detecting data access requests from the user device application and managing interactions between the user device application, the offline data manager and the online data manager, each key-value pair comprising a key portion and a value portion,

the key portion comprising a data type representing an origin or data category and a unique identifier, the key portion corresponding to associated data, the associated data comprising an authentication token corresponding to the data type and a data container corresponding to the unique identifier; and,

the value portion comprising a header associated with the data container and a body, the header comprising metadata, the metadata comprising keep offline metadata indicating whether the offline data needs to be kept offline once connectivity is achieved, and the body comprising a serialized version of the offline data, the serialized version of the offline data being defined in a source database schema; and wherein

a provider of the online data source determines when to use the data management agent to store or retrieve data when access to the network is not available.

14. The non-transitory, computer-readable storage medium of claim 13 , further comprising:

receiving an access request for a set of data corresponding to the first set of online data;

processing the access request to determine if the first set of online data is available for online access; and

providing the first set of online data if it is available for online access.

15. The non-transitory, computer-readable storage medium of claim 14 , further comprising:

providing the first set of offline data if the first set of online data is not available for online access.

16. The non-transitory, computer-readable storage medium of claim 15 , further comprising:

retrieving the first set of offline data from the local storage; and

processing the first set of offline data and the first set of online data to determine if the first set of offline data is different than the first set of online data.

17. The non-transitory, computer-readable storage medium of claim 16 , further comprising:

performing synchronization operations to synchronize the first set of online data with the first set of offline data.

18. The non-transitory, computer-readable storage medium of claim 15 , further comprising:

retrieving a second set of offline data from the local storage;

processing the second set of offline data and the first set of online data to determine if the second set of offline data is new; and

persisting a copy of the second set of offline data as a second set of online data if it is.

Assignments (15)
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (053546/0001) Recorded Jun 23, 2022
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
To: DELL MARKETING L.P. (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO CREDANT TECHNOLOGIES, INC.); DELL INTERNATIONAL L.L.C.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO FORCE10 NETWORKS, INC. AND WYSE TECHNOLOGY L.L.C.); EMC IP HOLDING COMPANY LLC
Reel/Frame 071642/0001 →
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (045455/0001) Recorded May 20, 2022
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
To: DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO ASAP SOFTWARE EXPRESS, INC.); DELL MARKETING L.P. (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO CREDANT TECHNOLOGIES, INC.); DELL USA L.P.; DELL INTERNATIONAL L.L.C.; DELL PRODUCTS L.P.; DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO FORCE10 NETWORKS, INC. AND WYSE TECHNOLOGY L.L.C.); EMC CORPORATION (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO MAGINATICS LLC); EMC IP HOLDING COMPANY LLC (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO MOZY, INC.); SCALEIO LLC
Reel/Frame 061753/0001 →
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (040136/0001) Recorded Apr 26, 2022
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
To: DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO ASAP SOFTWARE EXPRESS, INC.); DELL MARKETING L.P. (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO CREDANT TECHNOLOGIES, INC.); DELL USA L.P.; DELL INTERNATIONAL L.L.C.; DELL PRODUCTS L.P.; DELL MARKETING CORPORATION (SUCCESSOR-IN-INTEREST TO FORCE10 NETWORKS, INC. AND WYSE TECHNOLOGY L.L.C.); EMC CORPORATION (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO MAGINATICS LLC); EMC IP HOLDING COMPANY LLC (ON BEHALF OF ITSELF AND AS SUCCESSOR-IN-INTEREST TO MOZY, INC.); SCALEIO LLC
Reel/Frame 061324/0001 →
RELEASE OF SECURITY INTEREST Recorded Nov 3, 2021
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH
To: ASAP SOFTWARE EXPRESS, INC.; AVENTAIL LLC; CREDANT TECHNOLOGIES, INC.; DELL USA L.P.; DELL INTERNATIONAL, L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL SYSTEMS CORPORATION; EMC CORPORATION; EMC IP HOLDING COMPANY LLC; FORCE10 NETWORKS, INC.; MAGINATICS LLC; MOZY, INC.; SCALEIO LLC; WYSE TECHNOLOGY L.L.C.
Reel/Frame 058216/0001 →
SECURITY AGREEMENT Recorded Apr 22, 2020
From: CREDANT TECHNOLOGIES INC.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; FORCE10 NETWORKS, INC.; WYSE TECHNOLOGY L.L.C.; EMC IP HOLDING COMPANY LLC
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A.
Reel/Frame 053546/0001 →
SECURITY AGREEMENT Recorded Mar 21, 2019
From: CREDANT TECHNOLOGIES, INC.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL USA L.P.; EMC CORPORATION; FORCE10 NETWORKS, INC.; WYSE TECHNOLOGY L.L.C.; EMC IP HOLDING COMPANY LLC
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A.
Reel/Frame 049452/0223 →
SECURITY AGREEMENT Recorded Sep 21, 2016
From: ASAP SOFTWARE EXPRESS, INC.; AVENTAIL LLC; CREDANT TECHNOLOGIES, INC.; DELL USA L.P.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL SYSTEMS CORPORATION; EMC CORPORATION; EMC IP HOLDING COMPANY LLC; FORCE10 NETWORKS, INC.; MAGINATICS LLC; MOZY, INC.; SCALEIO LLC; SPANNING CLOUD APPS LLC; WYSE TECHNOLOGY L.L.C.
To: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS NOTES COLLATERAL AGENT
Reel/Frame 040136/0001 →
SECURITY AGREEMENT Recorded Sep 21, 2016
From: ASAP SOFTWARE EXPRESS, INC.; AVENTAIL LLC; CREDANT TECHNOLOGIES, INC.; DELL USA L.P.; DELL INTERNATIONAL L.L.C.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL SYSTEMS CORPORATION; EMC CORPORATION; EMC IP HOLDING COMPANY LLC; FORCE10 NETWORKS, INC.; MAGINATICS LLC; MOZY, INC.; SCALEIO LLC; SPANNING CLOUD APPS LLC; WYSE TECHNOLOGY L.L.C.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 040134/0001 →
RELEASE OF REEL 032809 FRAME 0987 (NOTE) Recorded Sep 14, 2016
From: BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS COLLATERAL AGENT
To: DELL SOFTWARE INC.; DELL PRODUCTS L.P.; SECUREWORKS, INC.
Reel/Frame 040026/0953 →
RELEASE OF REEL 032810 FRAME 0038 (TL) Recorded Sep 14, 2016
From: BANK OF AMERICA, N.A., AS COLLATERAL AGENT
To: DELL SOFTWARE INC.; DELL PRODUCTS L.P.; SECUREWORKS, INC.
Reel/Frame 040027/0686 →
RELEASE OF REEL 032810 FRAME 0023 (ABL) Recorded Sep 13, 2016
From: BANK OF AMERICA, N.A., AS ADMINISTRATIVE AGENT
To: DELL SOFTWARE INC.; DELL PRODUCTS L.P.; SECUREWORKS, INC.
Reel/Frame 040014/0320 →
SUPPLEMENT TO PATENT SECURITY AGREEMENT (TERM LOAN) Recorded May 1, 2014
From: DELL PRODUCTS L.P.; DELL SOFTWARE INC.; SECUREWORKS, INC.
To: BANK OF AMERICA, N.A., AS COLLATERAL AGENT
Reel/Frame 032810/0038 →
SUPPLEMENT TO PATENT SECURITY AGREEMENT (NOTES) Recorded May 1, 2014
From: DELL PRODUCTS L.P.; DELL SOFTWARE INC.; SECUREWORKS, INC.
To: THE BANK OF NEW YORK MELLON TRUST COMPANY N.A., AS NOTES COLLATERAL AGENT
Reel/Frame 032809/0987 →
SUPPLEMENT TO PATENT SECURITY AGREEMENT (ABL) Recorded May 1, 2014
From: DELL PRODUCTS L.P.; DELL SOFTWARE INC.; SECUREWORKS, INC.
To: BANK OF AMERICA, N.A., AS ADMINISTRATIVE AGENT
Reel/Frame 032810/0023 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 12, 2014
From: BOTERO, LUIS J.
To: DELL PRODUCTS L.P.
Reel/Frame 032412/0369 →