Using view layer in database system for zero downtime upgrade

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 minimizing downtime during execution of a maintenance procedure of a database system, the operations comprising:

• providing a first access schema in a view layer of the database system, the first access schema comprising one or more first database objects and one or more projection views, each projection view corresponding to a second database object of one or more second database objects in a data persistency of the database system;
• transitioning access of sessions of an application from the data persistency of the database system to the first access schema;
• executing at least a portion of the maintenance procedure in the database system, the at least a portion of the maintenance procedure:
• changing one or more second database objects within the data persistency,
• creating a second access schema, and
• transitioning access of the sessions of the application from the first access schema to the second access schema;
• transitioning access of the sessions of the application from the second access schema to the data persistency of the database system;
• and
• removing the second access schema from the database system.

A system, comprising:

• a computing device;
• and
• a computer-readable storage device coupled to the computing device and having instructions stored thereon which, when executed by the computing device, cause the computing device to perform operations for natural language explanations for minimizing downtime during execution of a maintenance procedure of a database system, the operations comprising:
• providing a first access schema in a view layer of the database system, the first access schema comprising one or more first database objects and one or more projection views, each projection view corresponding to a second database object of one or more second database objects in a data persistency of the database system;
• transitioning access of sessions of an application from the data persistency of the database system to the first access schema;
• executing at least a portion of the maintenance procedure in the database system, the at least a portion of the maintenance procedure:
• changing one or more second database objects within the data persistency,
• creating a second access schema, and
• transitioning access of the sessions of the application from the first access schema to the second access schema;
• transitioning access of the sessions of the application from the second access schema to the data persistency of the database system;
• and
• removing the second access schema from the database system.