IP Library Granted Patent US 12,028,328
Granted Patent B2
US 12,028,328 · App. 17/582,868 · Granted Jul 2, 2024

Providing database performance report in restricted environment

Inventor: Iantcho Todorov Vassilev (Sofia, BG)
Assignee: SAP SE
H04L63/0807G06F16/217G06F21/31G06F21/6218
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,028,328
App. No.
17/582,868
Granted
Jul 2, 2024
Kind
B2
Abstract

Techniques for providing a database performance report in a restricted access environment are disclosed. In some embodiments, a computer system performs a method comprising: receiving, from a computing device of a user, a request to generate a database performance report for a first database that is hosted on a cloud computing platform, the request including a service key; obtaining administrative credentials from a second database using stateless authentication and the service key; obtaining one or more database performance metrics of the first database from the first database using the administrative credentials; and generating the database performance report based on the one or more database performance metrics.

Claims (67)

1. A computer-implemented method performed by a computer system having a memory and at least one hardware processor, the computer-implemented method comprising:

receiving, from a computing device of a user, a request to generate a database performance report for a first database that is hosted on a cloud computing platform, the request including a service key;

obtaining administrative credentials from a second database using stateless authentication and the service key, the second database being different from the first database and being hosted on the cloud computing platform;

obtaining one or more database performance metrics of the first database from the first database using the administrative credentials; and

generating the database performance report based on the one or more database performance metrics.

2. The computer-implemented method of claim 1 , further comprising:

storing the database performance report in a directory;

generating an expiring link to the database performance report in the directory, the expiring link being configured to expire after a predetermined amount of time; and

displaying the expiring link on the computing device of the user.

3. The computer-implemented method of claim 2 , further comprising:

receiving a user selection of the expiring link from the computing device before the predetermined amount of time has passed; and

displaying the database performance report on the computing device in response to receiving the user selection of the expiring link from the computing device before the predetermined amount of time has passed.

4. The computer-implemented method of claim 2 , further comprising:

determining that the predetermined amount of time has passed;

deleting the database performance report from the directory in response to the determining that the predetermined amount of time has passed;

receiving a user selection of the expiring link from the computing device after the predetermined amount of time has passed; and

displaying an error message on the computing device in response to the receiving the user selection of the expiring link from the computing device after the predetermined amount of time has passed.

5. The computer-implemented method of claim 1 , wherein the obtaining the administrative credentials comprises:

attempting to connect to the first database using the service key;

determining that a connection to the first database was established using the service key; and

in response to the determining that the connection to the first database was established using the service key, retrieving the administrative credentials from the second database.

6. The computer-implemented method of claim 1 , wherein the first database comprises a user database that is hosted within a user space dedicated to a user account of the user.

7. The computer-implemented method of claim 1 , wherein the second database comprises a master database.

8. The computer-implemented method of claim 1 , wherein the request further includes one or more types of database performance checks, and the one or more database performance metrics of the first database are obtained based on the inclusion of the one or more types of database performance checks in the request.

9. A system of comprising:

at least one hardware processor; and

a non-transitory computer-readable medium storing executable instructions that, when executed, cause the at least one processor to perform operations comprising:

receiving, from a computing device of a user, a request to generate a database performance report for a first database that is hosted on a cloud computing platform, the request including a service key;

obtaining administrative credentials from a second database using stateless authentication and the service key, the second database being different from the first database and being hosted on the cloud computing platform;

obtaining one or more database performance metrics of the first database from the first database using the administrative credentials; and

generating the database performance report based on the one or more database performance metrics.

10. The system of claim 9 , wherein the operations further comprise:

storing the database performance report in a directory;

generating an expiring link to the database performance report in the directory, the expiring link being configured to expire after a predetermined amount of time; and

displaying the expiring link on the computing device of the user.

11. The system of claim 10 , wherein the operations further comprise:

receiving a user selection of the expiring link from the computing device before the predetermined amount of time has passed; and

displaying the database performance report on the computing device in response to receiving the user selection of the expiring link from the computing device before the predetermined amount of time has passed.

12. The system of claim 10 , wherein the operations further comprise:

determining that the predetermined amount of time has passed;

deleting the database performance report from the directory in response to the determining that the predetermined amount of time has passed;

receiving a user selection of the expiring link from the computing device after the predetermined amount of time has passed; and

displaying an error message on the computing device in response to the receiving the user selection of the expiring link from the computing device after the predetermined amount of time has passed.

13. The system of claim 9 , wherein the obtaining the administrative credentials comprises:

attempting to connect to the first database using the service key;

determining that a connection to the first database was established using the service key; and

in response to the determining that the connection to the first database was established using the service key, retrieving the administrative credentials from the second database.

14. The system of claim 9 , wherein the first database comprises a user database that is hosted within a user space dedicated to a user account of the user.

15. The system of claim 9 , wherein the second database comprises a master database.

16. The system of claim 9 , wherein the request further includes one or more types of database performance checks, and the one or more database performance metrics of the first database are obtained based on the inclusion of the one or more types of database performance checks in the request.

17. A non-transitory machine-readable storage medium tangibly embodying a set of instructions that, when executed by at least one hardware processor, causes the at least one processor to perform operations comprising:

receiving, from a computing device of a user, a request to generate a database performance report for a first database that is hosted on a cloud computing platform, the request including a service key;

obtaining administrative credentials from a second database using stateless authentication and the service key, the second database being different from the first database and being hosted on the cloud computing platform;

obtaining one or more database performance metrics of the first database from the first database using the administrative credentials; and

generating the database performance report based on the one or more database performance metrics.

18. The non-transitory machine-readable storage medium of claim 17 , wherein the operations further comprise:

storing the database performance report in a directory;

generating an expiring link to the database performance report in the directory, the expiring link being configured to expire after a predetermined amount of time; and

displaying the expiring link on the computing device of the user.

19. The non-transitory machine-readable storage medium of claim 18 , wherein the operations further comprise:

receiving a user selection of the expiring link from the computing device before the predetermined amount of time has passed; and

displaying the database performance report on the computing device in response to receiving the user selection of the expiring link from the computing device before the predetermined amount of time has passed.

20. The non-transitory machine-readable storage medium of claim 18 , wherein the operations further comprise:

determining that the predetermined amount of time has passed;

deleting the database performance report from the directory in response to the determining that the predetermined amount of time has passed;

receiving a user selection of the expiring link from the computing device after the predetermined amount of time has passed; and

displaying an error message on the computing device in response to the receiving the user selection of the expiring link from the computing device after the predetermined amount of time has passed.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 24, 2022
From: VASSILEV, IANTCHO TODOROV
To: SAP SE
Reel/Frame 058747/0988 →
Continuity (1)
Related Publication 20230237178A1 · Jul 27, 2023