Database Report Offload Server

• US 20170213046A1
• Filed: 01/27/2016
• Published: 07/27/2017
• 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
• Granted Patent: US 10,642,859 B2
• Time in Patent Office: Days
• 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 database;

a second database, wherein the second database is normally read only; and

;

a server to submit 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.

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

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

4. The 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 data storage.

5. The system of claim 1, wherein the link is appended manually.

6. The system of claim 1, wherein wherein the link is appended automatically.

7. A method comprising:

receiving a request intended for a first database;

establishing a service having write privileges to a second database that is normally read only;

establishing a service user account that includes the write privilege;

editing the request to include a link to the second database; and

submitting the request to 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 request.

11. The 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 request intended for a first database, establishing a service having write privileges to a second database that is normally read only, establishing a service user account that includes the write privilege, editing the request to include a link to the second database, and submitting the request to 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 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.