Database report offload server

• US 10,642,859 B2
• Filed: 01/27/2016
• Issued: 05/05/2020
• Est. Priority Date: 01/27/2016
• Status: Active Grant

• Current Assignee: Dell Products LP (Dell Technologies Inc.)
• Original Assignee: Dell Products LP (Dell Technologies Inc.)
• Inventors: Kaduluri, Srinivasa Reddy, Patel, Prabhat Kumar
• Primary Examiner(s): Saeed, Usmaan
• Assistant Examiner(s): Perez-Arroyo, Raquel
• Application Number:
  US15/007,695
• Publication Number:
  US 20170213046A1
• Time in Patent Office: 1,560 Days
• Field of Search: 707783
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

An information handling system includes a first database and a second database. A server submits a request received by the first database instead to the second database by 1) establishing a service to the second database, the service having write privileges, 2) establishing a service user account that includes the write privilege, and 3) editing the request to include a link to the second database.

Claims

1. An information handling system comprising:

a first data storage system, wherein the first data storage system includes a first database;

a second data storage system, wherein the second data storage system includes a second database, wherein the second database is normally a read only disaster recovery database;

a server including a hardware processor to submit a report request received by the first database to determine whether the second database is available to process the report request while performing a disaster recovery role, and to redirect the report request to the second database if the second database is available to process the report request by

     1) establishing a service to the second database, the service having write privileges,

     2) establishing a service user account that includes the write privileges, and

     3) editing commands in the report request to include a link to the second database, wherein the editing the commands includes updating table names in the report request to refer to table names at the second database;

if the report request is redirected to the second database, then the second database to process the report request while performing the disaster recovery role else the first database to process the report request; and

the first data storage system to receive a response from the second database and to log metadata for the report request while the second database is processing the report request.

2. The information handling system of claim 1, wherein the first database is a relational database.

3. The information handling system of claim 1, wherein the second database is a relational database.

4. The information handling system of claim 1, wherein the first data storage system or the second data storage system or both have more than one server accessing their respective databases.

5. The information handling system of claim 1, wherein the response to the report request is transmitted to the first database.

6. The information handling system of claim 1, wherein the link is included automatically.

7. A method comprising:

receiving a report request intended for a first database, wherein the first database is included in a first data storage system;

establishing a service having write privileges to a second database that is normally a read only disaster recovery database, wherein the second database is included in a second data storage system;

determining whether the second database is available to process the report request while performing a disaster recovery role;

in response to the determining that the second database is available to process the report request;

establishing a service user account that includes the write privileges;

editing commands in the report request to include a link to the second database, wherein the editing the commands includes updating table names in the report request to refer to table names at the second database; and

submitting the report request to the second database;

if the report request is redirected to the second database, then processing the report request by the second database while performing the disaster recovery role else the first database to process the report request; and

logging metadata for the report request by the first data storage system during the processing of the report request by the second database.

8. The method of claim 7, wherein the first database is a relational database.

9. The method of claim 7, wherein the second database is a relational database.

10. The method of claim 7, wherein the link is appended to the report request.

11. The method of claim 10, wherein the link is appended manually.

12. The method of claim 7, wherein the link is appended automatically.

13. A system comprising:

a server; and

a non-transitory medium storing instructions that, when executed by the server, perform a method including receiving a report request intended for a first database, wherein the first database is included in a first data storage system, establishing a service having write privileges to a second database that is normally a read only disaster recovery database, wherein the second database is included in a second data storage system, determining whether the second database is available to process the report request while performing a disaster recovery role, in response to the determining that the second database is available to process the report request;

establishing a service user account that includes the write privileges, editing commands in the report request to include a link to the second database, wherein the editing the commands includes updating table names in the report request to refer to table names at the second database, and submitting the report request to the second database, if the report request is redirected to the second database, then processing the report request by the second database while performing the disaster recovery role else processing the report request by the first database, and logging metadata for the report request by the first data storage system during the processing of the report request by the second database.

14. The system of claim 13, wherein the first database is a relational database.

15. The system of claim 13, wherein the second database is a relational database.

16. The system of claim 13, wherein the link is appended to the report request.

17. The system of claim 16, wherein the link is appended manually.

18. The system of claim 13, wherein the link is appended automatically.