IP Library Granted Patent US 10,503,723
Granted Patent B2
US 10,503,723 · App. 14/335,540 · Granted Dec 10, 2019

Method and system for migrating data between systems without downtime

Inventors: Espen Zachrisen (Bartlett, IL); Tariq Afeef (Streamwood, IL); Ganesh Venkatachalam (Round Lake, IL); Vinayak Subray Hegde (Hoffman Estates, IL)
Assignee: TRANSFORM SR BRANDS LLC
G06F16/2365G06F3/067G06F3/0617G06F3/0647G06F16/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,503,723
App. No.
14/335,540
Granted
Dec 10, 2019
Kind
B2
Abstract

Methods and systems are provided for migrating data between systems without downtime. Data migration may be performed by selecting one or more data records for migration from a first record system to a second record system, and copying the one or more data records from the first record system to the second record system in manner where the data record remains accessible and available during the migration. The migrating may comprise verifying each copied data record, and when the data record is successfully verified, marking it as available on the second record system, and updating user interaction related functions to use a copy of the data record in the second record system when handling interactions by a user associated with the data record. User interactions may be handled adaptively during data migration by verifying the availability of data records in the first record system and the second record system.

Claims (50)

1. A method, comprising:

in an electronic system that is configured for handling data migration:

selecting one or more data records for migration from a first record system to a second record system;

migrating the one or more data records from the first record system to the second record system, the migrating comprising:

obtaining the one or more data records from the first record system;

loading the one or more data records into the second record system; and

for each data record of the one or more data records:

verifying the data record;

when the data record is successfully verified, marking it as available on the second record system; and

updating user interaction related functions to use a copy of the data record in the second record system when handling interactions by a user associated with the data record; and

handling during the migrating of the one or more data records, user requests for particular data records, wherein the handling comprises for each requested data record, selecting between the first record system and the second record system based on the user interaction related functions.

2. The method of claim 1 , comprising marking the one or more data records in the first record system as unavailable after loading the one or more data records into the second record system.

3. The method of claim 1 , comprising verifying the data record by comparing the copy of the data record in the second record system with a copy of the data record that still remains in the first record system.

4. The method of claim 3 , comprising, when the copy of the data record in the second record system does not match the copy of the data record that still remains in the first record system:

marking the copy of the data record that still remains in the first record system as available; and

marking the loaded copy of the data record into the second record system for deletion.

5. The method of claim 3 , comprising marking the data record, when the loaded copy of the data record into the second record system does not match the copy of the data record that still remains in the first record system, for re-migration.

6. The method of claim 1 , wherein the handling comprises:

determining for each user request, at least one data record associated with the user request;

determining if a copy of the one data record in the first record system is still active; and

when the copy of the one data record in the first record system is still active, forwarding the user request to the first record system.

7. The method of claim 6 , comprising, when the copy of the one data record in the first record system is not active, forwarding the user request to the second record system.

8. The method of claim 7 , comprising, when receiving from the second record system an indication that a copy of the one data record in the second record system is not active in the second record system, retrying to forward the user request to the second record system after a particular wait period.

9. The method of claim 8 , comprising determining the particular wait period for each user request.

10. The method of claim 9 , comprising determining the particular wait period based on level of service associated with the user request.

11. A system, comprising:

one or more circuits for use in an electronic system that is configured for handling data migration, the one or more circuits being operable to:

select one or more data records for migration from a first record system to a second record system; and

migrate the one or more data records from the first record system to the second record system, the migrating comprising:

obtaining the one or more data records from the first record system;

loading the one or more data records into the second record system; and

for each data record of the one or more data records:

verify the data record;

when the data record is successfully verified, mark it as available on the second record system; and

update user interaction related functions to use a copy of the data record in the second record system when handling interactions by a user associated with the data record;

handle during the migrating of the one or more data records, user requests for particular data records, wherein the handling comprises for each requested data record, selecting between the first record system and the second record system based on the user interaction related functions.

12. The system of claim 11 , wherein the one or more circuits are operable to mark the one or more data records in the first record system as unavailable after loading the one or more data records into the second record system.

13. The system of claim 11 , wherein the one or more circuits are operable to verify the data record by comparing the copy of the data record in the second record system with a copy of the data record that still remains in the first record system.

14. The system of claim 13 , wherein the one or more circuits are operable to, when the copy of the data record in the second record system does not match the copy of the data record that still remains in the first record system:

mark the copy of the data record that still remains in the first record system as available; and

mark the loaded copy of the data record into the second record system for deletion.

15. The system of claim 13 , wherein the one or more circuits are operable to mark the data record, when the loaded copy of the data record into the second record system does not match the copy of the data record that still remains in the first record system, for re-migration.

16. The system of claim 11 , wherein the one or more circuits are operable to:

determine for each user request, at least one data record associated with the user request;

determine if a copy of the one data record in the first record system is still active; and

when the copy of the one data record in the first record system is still active, forward the user request to the first record system.

17. The system of claim 16 , wherein the one or more circuits are operable to, when the copy of the one data record in the first record system is not active, forward the user request to the second record system.

18. The system of claim 17 , wherein the one or more circuits are operable to, when receiving from the second record system an indication that a copy of the one data record in the second record system is not active in the second record system, retry to forward the user request to the second record system after a particular wait period.

19. The system of claim 18 , wherein the one or more circuits are operable to determine the particular wait period for each user request.

20. The system of claim 19 , wherein the one or more circuits are operable to determine based on level of service associated with the user request.

Assignments (14)
SECURITY INTEREST Recorded May 7, 2021
From: TRANSFORM SR BRANDS LLC
To: CANTOR FITZGERALD SECURITIES
Reel/Frame 056179/0863 →
SECURITY INTEREST Recorded May 15, 2020
From: TRANSFORM SR BRANDS LLC
To: JPP, LLC
Reel/Frame 053467/0062 →
RELEASE OF SECURITY INTEREST Recorded Mar 18, 2020
From: CITIBANK, N.A., AS AGENT
To: TRANSFORM SR BRANDS LLC
Reel/Frame 052188/0176 →
RELEASE OF SECURITY INTEREST Recorded Mar 17, 2020
From: CANTOR FITZGERALD SECURITIES
To: TRANSFORM SR BRANDS LLC
Reel/Frame 052184/0782 →
RELEASE OF SECURITY INTEREST Recorded Mar 17, 2020
From: BANK OF AMERICA, N.A.
To: TRANSFORM SR BRANDS LLC
Reel/Frame 052183/0879 →
SECURITY INTEREST Recorded Sep 20, 2019
From: TRANSFORM SR BRANDS LLC
To: CANTOR FITZGERALD SECURITIES
Reel/Frame 050451/0309 →
RELEASE OF SECURITY INTEREST Recorded Apr 22, 2019
From: CANTOR FITZGERALD SECURITIES, AS AGENT
To: TRANSFORM SR BRANDS LLC
Reel/Frame 049284/0149 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 27, 2019
From: SEARS BRANDS, L.L.C.
To: TRANSFORM SR BRANDS LLC
Reel/Frame 048710/0182 →
SECURITY INTEREST Recorded Feb 25, 2019
From: TRANSFORM SR BRANDS LLC
To: BANK OF AMERICA, N.A.
Reel/Frame 048433/0001 →
SECURITY INTEREST Recorded Feb 25, 2019
From: TRANSFORM SR BRANDS LLC
To: CITIBANK, N.A.
Reel/Frame 048424/0291 →
RELEASE OF SECURITY INTEREST Recorded Feb 15, 2019
From: JPP, LLC
To: SEARS BRANDS, L.L.C.
Reel/Frame 048352/0708 →
SECURITY INTEREST Recorded Feb 12, 2019
From: TRANSFORM SR BRANDS LLC
To: CANTOR FITZGERALD SECURITIES, AS AGENT
Reel/Frame 048308/0275 →
SECURITY INTEREST Recorded Jan 5, 2018
From: SEARS BRANDS, L.L.C.
To: JPP, LLC
Reel/Frame 045013/0355 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 18, 2014
From: ZACHRISEN, ESPEN; AFEEF, TARIQ; VENKATACHALAM, GANESH; HEGDE, VINAYAK SUBRAY
To: SEARS BRANDS L.L.C.
Reel/Frame 033346/0128 →
Cited By (3)
US 12,475,140 US 12,585,623 US 12,688,198