IP Library Granted Patent US 12,189,498
Granted Patent B2
US 12,189,498 · App. 18/378,538 · Granted Jan 7, 2025

Database recovery and database recovery testing

Inventors: Shana Meyers (Shakopee, MN); Meghasyam Bokam (Charlotte, NC); Ian Bundock (Staines-Upon-Thames, GB); Larry N. Cotten, Jr. (Huntington Beach, CA); Jason Fleck (Spanish Fort, AL); Jason Garland (Orange, TX); David Gilboy (Leeds, GB); Jeffrey J. Hodges (Gilbert, AZ); Chun-Kai Jason Hsu (Austin, TX); Lori McFadden (Salina, KS); Peter Thomas McLean (Gilbert, AZ); Abhijit Moharil (Tempe, AZ)
Assignee: Insight Direct USA, Inc.
G06F11/1469G06F11/1464G06F2201/84
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 12,189,498
App. No.
18/378,538
Granted
Jan 7, 2025
Kind
B2
Abstract

A method of database recovery includes starting a first database server, starting a second database server, starting a third database server, and starting an application server after starting the first database server, the second database server, and the third. The first, second, and third database servers are configured to store data according to first, second, and third database management systems, respectively, and the application server is configured to run application modules of a set of application modules. The method of database recovery further includes starting a search module, starting a product catalog management module, starting a web connectivity module after starting the search module, starting a graphical user interface module after starting the web connectivity module, and starting at least one business operations module.

Claims (113)

1. A method of database recovery, the method comprising:

starting a first database server, wherein:

the first database server is configured to store data according to a first database management system, and

starting the first database server comprises restoring the first database server from a first database backup;

starting a second database server, wherein:

the second database server is configured to store data according to a second database management system, and

starting the second database server comprises restoring the second database server from a second database backup;

starting an application server after starting the first database server and the second database server, wherein:

starting the application server from comprises restoring the application server from an application server backup,

the application server is configured to run application modules of a set of application modules, and

the set of application modules comprises:

a web connectivity module configured to allow other application modules of the set of application modules to connect to the Internet;

a search module for searching at least one of the first database server and the second database server;

a product catalog management module for managing a product catalog; and

starting the search module;

starting the product catalog management module; and

starting the web connectivity module after starting the search module, wherein the web connectivity module is configured to request data from the search module.

2. The method of claim 1 , wherein the set of application modules further comprises a graphical user interface module configured to request data from the web connectivity module and to request data from the search module, and further comprising starting the graphical user interface module.

3. The method of claim 1 , wherein the set of application modules further comprises at least one business operations module configured to request data from at least one of the search module, the product catalog management module, and the web connectivity module, and further comprising starting the at least one business operations module.

4. The method of claim 3 , wherein starting the at least one business operations module comprises starting the at least one business operations module after the at least one of the search module, the product catalog management module, and the web connectivity module.

5. The method of claim 3 , wherein the at least one business operations module is one or more of a credit card verification module, a shipping address verification module, a reporting module, or a financial consolidation module.

6. The method of claim 3 , and further comprising starting a third database server before starting the application server, wherein the search module is configured to search at least one of the first database server, the second database server, and the third database server.

7. The method of claim 3 , further comprising validating, after starting the at least one business operations module, connections used by application modules of the set of application modules.

8. The method of claim 7 , further comprising using, after validating connections used by the set of application modules, the application server, the first database server, the second database server, and the third database server to perform a business operation.

9. The method of claim 7 , further comprising validating, after starting the at least one business operations module, functionality of application modules of the set of application modules.

10. The method of claim 9 , wherein the set of application modules further comprises a graphical user interface module configured to request data from the web connectivity module and to request data from the search module, and further comprising starting the graphical user interface module, and wherein validating connections used by application modules of the set of application modules comprises validating that:

the web connectivity module is able to request data from the search module;

the graphical user interface module is able to request data from the web connectivity module;

the graphical user interface module is able to request data from the search module; and

the at least one business operations module is able to request data from at least one of the search module, the product catalog management module, and the web connectivity module.

11. The method of claim 1 , further comprising:

copying, before starting the first database server and the second database server:

a first data set from a first active database server to the first database backup;

a second data set from a second active database server to the second database backup;

the set of application modules from an active application server to the application server backup.

12. The method of claim 1 , wherein restoring the first database server comprises:

starting a first backup database server storing the first database backup;

creating first virtual disks on the first database server according to the first database backup; and

copying the first database backup from the first backup database server to the first database server.

13. The method of claim 12 , wherein restoring the second database server comprises:

starting a second backup database server storing the second database backup;

creating second virtual disks on the second database server according to the second database backup; and

copying the second database backup from the second backup database server to the second database server.

14. The method of claim 1 , wherein:

the first database server is restored using a first recovery tool;

the second database server is restored using a second recovery tool; and

the application server is restored using a third recovery tool.

15. The method of claim 1 , wherein starting at least one of the first database server and the second database server comprises switching the at least one of the first database server and the second database server from an inactive state to an active state, wherein:

in the inactive state, the at least one of the first database server and the second database server in the inactive state is configured to allow data to be copied to the at least one of the first database server and the second database server; and

in the active state, the at least one of the first database server and the second database server is configured to allow data to be read from the at least one of the first database server and the second database server.

16. A method of performing a database recovery test, the method comprising:

disconnecting a first backup database server from a first active database server,

wherein:

the first backup database server is configured to store data according to a first database management system; and

the first backup database server is configured to back up a first set of data from the first active database server;

disconnecting a second backup database server from a second active database server, wherein:

the second backup database server is configured to store data according to a second database management system; and

the second backup database server is configured to back up a second set of data from the second active database server;

disconnecting a backup application server from an active application server,

wherein:

the backup application server is configured to back up application modules of a set of application modules from the active application server; and

the backup application server is configured to run the application modules of the set of application modules;

assigning new network configurations to the first backup database server, the second backup database server, and the backup application server after disconnecting the first backup database server, the second backup database server, and the backup application server;

providing the new network configurations for the first backup database server and the second backup database server to the backup application server;

transitioning the first backup database server to an active state from an inactive state after providing the new network configurations to the backup application server, wherein the first database management system is configured to recall data when the first backup database server is active;

transitioning the second backup database server to an active state from an inactive state, wherein the second database management system is configured to recall data when the second backup database server is active;

transitioning the backup application server to an active state from an inactive state after transitioning the first backup database server to an active state and transitioning the second backup database server to an active state, wherein the backup application server is configured to recall data from at least one of the first backup database server and the second backup database server;

starting the set of application modules;

validating connections used by application modules of the set of application modules;

stopping the set of application modules after validating connections;

transitioning the backup application server to an inactive state after stopping the set of application modules;

transitioning the first backup database server and the second backup database server to inactive states after transitioning the backup application server to an inactive state; and

reconnecting, after transitioning the first backup database server and the second backup database server to inactive states:

the first backup database server to the first active database server;

the second backup database server to the second active database server; and

the backup application server to the active application server.

17. The method of claim 16 , and further comprising:

disconnecting a third backup database server from a third active database server,

wherein:

the third backup database server is configured to store data according to a third database management system; and

the third backup database server is configured to back up a third set of data from the third active database server;

the backup application server is configured to recall data from at least one of the first backup database server, the second backup database server, and the third backup database server;

assigning new network configurations to the third backup database server after disconnecting the third backup database server;

providing the new network configurations for the third backup database server to the backup application server;

transitioning the third backup database server to an active state from an inactive state before transitioning the backup application server, wherein the third database management system is configured to recall data when the third backup database server is active;

transitioning the third backup database server to an inactive state after transitioning the backup application server to an inactive state; and

reconnecting the third backup database server to the third active database server after transitioning the third backup database server to the inactive state.

18. The method of claim 17 , wherein, prior to assigning new network configurations, the first active database server has a first network configuration, the second active database server has a second network configuration, the third backup database server has a third network configuration, and the active application server has a fourth network configuration, and further comprising, after deactivating the first backup database server, the second backup database server, the third backup database server, and the backup application server and before reconnecting the first backup database server, the second backup database server, the third backup database server, and the backup application server:

assigning the first network configuration to the first backup database server;

assigning the second network configuration to the second backup database server; and

assigning the third network configuration to the third backup database server.

19. The method of claim 18 , wherein the set of application modules comprises:

a web connectivity module configured to allow other application modules of the set of application modules to connect to the Internet;

a search module for searching at least one of the first database server, the second database server, and the third database server;

a product catalog management module for managing a product catalog;

a graphical user interface module configured to allow a user to interact with one or more application modules of the set of application modules; and

at least one business operations module.

20. A method of database recovery, the method comprising:

starting a first database server and a second database server, wherein:

the first database server is configured to store data according to a first database management system,

the second database server is configured to store data according to a second database management system

starting at least one of the first database server and the second database server comprises switching the at least one of the first database server and the second database server from an inactive state to an active state,

in the inactive state, the at least one of the first database server and the second database server is configured to allow data to be copied to the at least one of the first database server and the second database server; and

in the active state, the at least one of the first database server and the second database server is configured to allow data to be read from the at least one of the first database server and the second database server;

starting an application server after starting the first database server and the second database server, wherein:

the application server is configured to run application modules of a set of application modules, and

the set of application modules comprises:

a web connectivity module configured to allow other application modules of the set of application modules to connect to the Internet;

a search module for searching at least one of the first database server and the second database server;

a product catalog management module for managing a product catalog; and

starting the search module;

starting the product catalog management module; and

starting the web connectivity module after starting the search module, wherein the web connectivity module is configured to request data from the search module.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 10, 2023
From: MEYERS, SHANA; BOKAM, MEGHASYAM; BUNDOCK, IAN; COTTEN, LARRY N., JR.; FLECK, JASON; GARLAND, JASON; GILBOY, DAVID; HODGES, JEFFREY J.; HSU, CHUN-KAI JASON; MCFADDEN, LORI; MCLEAN, PETER THOMAS; MOHARIL, ABHIJIT
To: INSIGHT DIRECT USA, INC.
Reel/Frame 065174/0625 →
Continuity (2)
Continuation 17686886 · Mar 4, 2022
Related Publication 20240036991A1 · Feb 1, 2024
References Cited (34)
US 6108671A · Ogawa · 2000 [cited by applicant]
US 7769648B1 · Nolan · 2010 [cited by examiner]
US 8065189B1 · Ballaro · 2011 [cited by examiner]
US 8549114B2 · Reddy · 2013 [cited by examiner]
US 8918366B2 · D'Souza et al. · 2014 [cited by applicant]
US 9032247B2 · Ahmed et al. · 2015 [cited by applicant]
US 9286369B2 · Pei et al. · 2016 [cited by applicant]
US 9619342B2 · He et al. · 2017 [cited by applicant]
US 9817726B2 · Lee et al. · 2017 [cited by applicant]
US 10097399B1 · Pillay · 2018 [cited by examiner]
US 10310949B1 · Chakraborty et al. · 2019 [cited by applicant]
US 10693955B2 · Lalsangi et al. · 2020 [cited by applicant]
US 10795758B2 · Korotaev et al. · 2020 [cited by applicant]
US 10992633B1 · Nachman · 2021 [cited by applicant]
US 20030033179A1 · Katz · 2003 [cited by examiner]
US 20030086549A1 · Boehmke · 2003 [cited by examiner]
US 20030139975A1 · Perkowski · 2003 [cited by applicant]
US 20050251456A1 · Perkowski · 2005 [cited by applicant]
US 20070226064A1 · Yu · 2007 [cited by examiner]
US 20140258241A1 · Chen et al. · 2014 [cited by applicant]
US 20140304230A1 · Simon et al. · 2014 [cited by applicant]
US 20160197993A1 · Perkowski · 2016 [cited by examiner]
US 20160253400A1 · Mcalister et al. · 2016 [cited by applicant]
US 20180239677A1 · Chen et al. · 2018 [cited by applicant]
US 20190138402A1 · Bikumala et al. · 2019 [cited by applicant]
US 20200134686A1 · Fahey et al. · 2020 [cited by applicant]
US 20210271390A1 · Shemer et al. · 2021 [cited by applicant]
US 20210279150A1 · Mogilevskiy et al. · 2021 [cited by applicant]
US 20230153302A1 · Shen · 2023 [cited by examiner]
CN 104813276A · 2015 [cited by applicant]
CN 104714859B · 2017 [cited by applicant]
IN 201741019336A · 2018 [cited by applicant]
IN 355643B · 2021 [cited by applicant]
International Search Report and Written Opinion for International Application No. PCT/US2023/013969, dated Jun. 30, 2023, 13 pages. [cited by applicant]