Sap Se

Markus Gebhard

Volker Driesen

Andreas Jahr

Oleg Koutyrine

Torsten Ziegler

Nicolai Jordt

Frank-Martin Haas

Wolfgang Degenhardt

Andreas Zimmermann

Techniques and solutions are described for facilitating the distribution of tables and table data between a shared container and one or more tenant containers. The tables can include a sharing indicator that can designate a table (or a view on a table) as having a materializable type. Materializable types can initially be deployed in the shared container, and a tenant container can have read access to the table via a view. If the tenant attempts to modify the materializable table, the table can be materialized in the tenant container. Metadata for a materializable table can include materialization instructions. Techniques and solutions are also provided for converting between sharing types, and for updating shared containers or table schemas.

Materializable database objects in multitenant environments

An upgrade procedure for an application system without downtime is presented. The upgrade procedure includes a mix of a rolling upgrade of application servers, shadow systems, and record and replay mechanisms that employ transformation and locking, for the upgrade of the applications on the application system. Application servers are upgraded one after another. A target version of the system is simultaneously added to the original system and a shadow, or target, system. Data changes are not only carried out in the original system, but are also carried out in the target system, so that a customer realizes no downtime for their data requests to the applications.

Multi-version systems for zero downtime upgrades

Growing community of inventors

Karlsruhe, Germany

Markus Gebhard