Schema stack management system for managing extensions through upgrades

Patent metadata

Field	Value
Publication number	US-12216624-B2
Application number	US-202217938101-A
Country	US
Kind code	B2
Filing date	Oct 5, 2022
Priority date	Oct 5, 2022
Publication date	Feb 4, 2025
Grant date	Feb 4, 2025

Abstract

Implementations include a schema stack management system that enables zero-downtime during execution of maintenance procedures on application systems having schema stacks including one or more customer-provided schema extensions.

First claim

What is claimed is:

1. A computer-implemented method for executing maintenance procedures on application systems that include one or more extensions, the method being executed by one or more processors and comprising:
providing, for production use, an application system comprising a schema stack comprising a first cross schema and one or more extension schemas, the first cross schema providing federated data to a first set of applications from data of respective data spaces of a second set of applications;
initiating a maintenance procedure to the application system;
during the maintenance procedure:
maintaining a first set of synonyms between the first cross schema and one or more of the respective data spaces having data stored therein to enable continued production use of the schema stack while the maintenance procedure executes, each synonym connecting a view of the first cross schema to one of a view of an application in the first set of applications and a table in a data space of an application in the second set of applications,
deploying a second cross schema in the schema stack, the second cross schema being a different version than the first cross schema,
providing a second set of synonyms between the second cross schema and the one or more data spaces to enable non-production use of the second cross schema while the maintenance procedure executes, and
in response to determining that the schema stack comprises one or more extension schemas executing one or more of providing at least one connection between a first extension schema and the second cross schema, and deploying a second extension schema; and

after completion of the maintenance procedure:
selectively transitioning the first cross schema from production use to non-production use and the second cross schema from non-production use to production use for one or more users.

2. The method of claim 1 , wherein the first extension schema is included in the schema stack prior to execution of the maintenance procedure and is available for production use through the first cross schema for production use while the maintenance procedure executes, the at least one connection between the first extension schema and the second cross schema being provided for non-production use while the maintenance procedure executes.

3. The method of claim 2 , wherein selectively transitioning the second cross schema from non-production use to production use at least partially comprises enabling the at least one connection between the first extension schema and the second cross schema for production use.

4. The method of claim 1 , wherein the second extension schema is a different version of the first extension schema and replaces the first extension schema for production use upon transitioning the second cross schema from non-production use to production use.

5. The method of claim 4 , wherein the first extension schema is created and deployed by a consumer of the application system, and in response to execution of the maintenance procedure, the consumer is alerted and provides the second extension schema to replace the first extension schema for production use.

6. The method of claim 1 , wherein selectively transitioning the first cross schema from production use to non-production use and the second cross schema from non-production use to production use for one or more users at least partially comprises transitioning at least one user from a first user interface to a second user interface.

7. The method of claim 1 , wherein the maintenance procedure is executed by a vendor of the application system.

8. A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for executing maintenance procedures on application systems that include one or more extensions, the operations comprising:
providing, for production use, an application system comprising a schema stack comprising a first cross schema and one or more extension schemas, the first cross schema providing federated data to a first set of applications from data of respective data spaces of a second set of applications;
initiating a maintenance procedure to the application system;
during the maintenance procedure:
maintaining a first set of synonyms between the first cross schema and one or more of the respective data spaces having data stored therein to enable continued production use of the schema stack while the maintenance procedure executes, each synonym connecting a view of the first cross schema to one of a view of an application in the first set of applications and a table in a data space of an application in the second set of applications,
deploying a second cross schema in the schema stack, the second cross schema being a different version than the first cross schema,
providing a second set of synonyms between the second cross schema and the one or more data spaces to enable non-production use of the second cross schema while the maintenance procedure executes, and
in response to determining that the schema stack comprises one or more extension schemas executing one or more of providing at least one connection between a first extension schema and the second cross schema, and deploying a second extension schema; and

after completion of the maintenance procedure:
selectively transitioning the first cross schema from production use to non-production use and the second cross schema from non-production use to production use for one or more users.

9. The non-transitory computer-readable storage medium of claim 8 , wherein the first extension schema is included in the schema stack prior to execution of the maintenance procedure and is available for production use through the first cross schema for production use while the maintenance procedure executes, the at least one connection between the first extension schema and the second cross schema being provided for non-production use while the maintenance procedure executes.

10. The non-transitory computer-readable storage medium of claim 9 , wherein selectively transitioning the second cross schema from non-production use to production use at least partially comprises enabling the at least one connection between the first extension schema and the second cross schema for production use.

11. The non-transitory computer-readable storage medium of claim 8 , wherein the second extension schema is a different version of the first extension schema and replaces the first extension schema for production use upon transitioning the second cross schema from non-production use to production use.

12. The non-transitory computer-readable storage medium of claim 11 , wherein the first extension schema is created and deployed by a consumer of the application system, and in response to execution of the maintenance procedure, the consumer is alerted and provides the second extension schema to replace the first extension schema for production use.

13. The non-transitory computer-readable storage medium of claim 8 , wherein selectively transitioning the first cross schema from production use to non-production use and the second cross schema from non-production use to production use for one or more users at least partially comprises transitioning at least one user from a first user interface to a second user interface.

14. The non-transitory computer-readable storage medium of claim 8 , wherein the maintenance procedure is executed by a vendor of the application system.

15. A system, comprising:
a computing device; and

Assignees

• Sap Se

Inventors

• Eberlein Peter
• Driesen Volker

Classifications

• G06F8/65

  Updates (security arrangements therefor G06F21/57) · CPC title

• G06F16/256

  in federated or virtual databases · CPC title

• G06F16/2393

  Updating materialised views · CPC title

• G06F16/21 Primary

  Design, administration or maintenance of databases · CPC title

• G06F8/71

  Version control (security arrangements therefor G06F21/57); Configuration management · CPC title