Granted Patent B2

US 12,373,422 · App. 18/409,351 · Granted Jul 29, 2025

Inventor: Alalaa N. Tashkandi (Dhahran, SA)

Assignee: SAUDI ARABIAN OIL COMPANY

G06F16/2365G06F11/1448G06F2201/80

Abstract

Claims (61)

1. A computer-implemented method for preparing and providing database patching as a service, the method comprising:

accessing database patch information by at least one computing device, configured by executing instructions stored on non-transitory processor readable media, to provide database patching as a service to a plurality of computing devices in a distributed computer environment, wherein the database patch information represents a respective new database patch for a respective database system;

downloading, by the at least one computing device, at least one package comprising the respective new database patch;

accessing, by the at least one computing device, a model usable for implementing database patching for a plurality of different database systems, wherein each of the plurality of different database systems has a plurality of respective releases and each respective release has respective database patching requirements;

determining, by the at least one computing device, a current release of the respective database system configured with at least one of the plurality of computing devices in the distributed computer environment;

determining, by the at least one computing device, patching requirements for implementing the respective new database patch to the current release of the respective database system;

customizing, by the at least one computing device, the model as a function of: the database patch information; the current release of the respective database system; and the patching requirements for implementing the respective new patch to the current release of the respective database system;

generating, by the at least one computing device, in a test lab that includes access to respective base levels of a plurality of different database systems, a clone of the respective database;

executing in the test lab, by the at least one computing device using the model, pre-patching steps for the new database patch on the clone of the respective database;

executing in the test lab, by the at least one computing device using the model, patching steps for the new database patch on the clone of the respective database; and

executing in the test lab, by the at least one computing device using the model, post-patching steps for the new database patch on the clone of the respective database;

where the pre-patching steps, patching steps, and post-patching steps complete successfully, implementing, on the clone of the respective database, a rollback process and

implementing the respective new database patch, by the at least one computing device for the at least one of the plurality of computing devices in the distributed computer environment configured with the current release of the respective database system, as a function of the pre-patching steps, the patching steps, and the post-patching steps performed on the respective database system.

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

determining, by the at least one computing device, a failed process; and

generating and transmitting, by the at least one computing device, a notification associated with the failed process.

3. The computer-implemented method of claim 2 , wherein the failed process includes at least one of an invalid database object, a failed patching process, and a failed rollback process.

4. The computer-implemented method of claim 1 , wherein the model can be configured by parameters representing network configuration information, database configuration information, and standby database configuration information.

5. The computer-implemented method of claim 1 , wherein the model includes a plurality of submodels.

6. The computer-implemented method of claim 5 , wherein the plurality of submodels include operations for pre-patch logical fixes, patching database objects, post-patch logical fixes, recompiling patched database objects, and hardening database security.

7. The computer-implemented method of claim 1 , further comprising creating, by the at least one computing device, a database restore point prior to executing the pre-patching steps and the post-patching steps and removing the restore point after patching, by the at least one computing device using the model, the respective database.

8. The computer-implemented method of claim 1 , where the rollback process on the clone of the respective database is unsuccessful:

generating, by the at least one computing device, a first notification representing the failed rollback process; and

transmitting, by the at least one computing device, the first notification to at least one other computing device.

9. The computer-implemented method of claim 1 , where at least one of the pre-patching steps, the patching steps, and the post-patching steps are unsuccessfully implemented on the clone of the respective database:

generating, by the at least one computing device, a second notification representing the at least one of the pre-patching steps, the patching steps, and the post-patching steps; and

transmitting, by the at least one computing device, the second notification to at least one other computing device.

10. The computer-implemented method of claim 1 , wherein following the rollback process on the clone of the respective database completed successfully:

destroying, by the at least one computing device, the clone of the respective database.

11. A computer-implemented system for preparing and providing database patching as a service, the system comprising:

at least one computing device, wherein the at least one computing device is configured by executing instructions for providing database patching as a service to a plurality of computing devices in a distributed computer environment, including by:

accessing database patch information representing a respective new database patch for a respective database system;

downloading at least one package comprising the respective new database patch;

accessing a model usable for implementing database patching for a plurality of different database systems, wherein each of the plurality of different database systems has a plurality of respective releases and each respective release has respective database patching requirements;

determining a current release of the respective database system configured with at least one of the plurality of computing devices in the distributed computer environment;

determining patching requirements for implementing the respective new database patch to the current release of the respective database system;

customizing the model as a function of: the database patch information; the current release of respective database system; and the patching requirements for implementing the respective new patch to the current release of the respective database system;

generating in a test lab that includes access to respective base levels of a plurality of different database systems, a clone of the respective database a clone of the respective database;

executing in the test lab, using the model, pre-patching steps for the new database patch on the clone of the respective database;

executing in the test lab, using the model, patching steps for the new database patch on the clone of the respective database; and

executing in the test lab, using the model, post-patching steps for the new database patch on the clone of the respective database;

where the pre-patching steps, patching steps, and post-patching steps complete successfully, implementing, on the clone of the respective database, a rollback process;

where the rollback process on the clone of the respective database completes successfully:

implementing the respective new database patch, for the at least one of the plurality of computing devices in the distributed computer environment configured with the current release of the respective database system, as a function of the pre-patching steps, the patching steps, and the post-patching steps performed on the respective database system.

12. The system of claim 11 , wherein the at least one computing device is configured by executing instructions for:

determining a failed process; and

generating and transmitting a notification associated with the failed process.

13. The system of claim 12 , wherein the failed process includes at least one of an invalid database object, a failed patching process, and a failed rollback process.

14. The system of claim 11 , wherein the model can be configured by parameters representing network configuration information, database configuration information, and standby database configuration information.

15. The system of claim 11 , wherein the model includes a plurality of submodels.

16. The system of claim 15 , wherein the plurality of submodels includes operations for pre-patch logical fixes, patching database objects, post-patch logical fixes, recompiling patched database objects, and hardening database security.

17. The system of claim 11 , wherein the at least one computing device is configured by executing instructions for:

creating a database restore point prior to executing the pre-patching steps and the post-patching steps and removing the restore point after patching, by the at least one computing device using the model, the respective database.

18. The computer-implemented system of claim 11 , where the rollback process on the clone of the respective database is unsuccessful:

generating a first notification representing the failed rollback process; and

transmitting the first notification to at least one other computing device.

19. The computer-implemented system of claim 11 , where at least one of the pre-patching steps, the patching steps, and the post-patching steps are unsuccessfully implemented on the clone of the respective database:

generating, by the at least one computing device, a second notification representing the at least one of the pre-patching steps, the patching steps, and the post-patching steps; and

transmitting the second notification to at least one other computing device.

20. The computer-implemented system of claim 11 , wherein following the rollback process on the clone of the respective database completed successfully:

destroying the clone of the respective database.

Assignments (1)

Continuity (1)

References Cited (11)