Deploying changes in a multi-tenancy database system

Patent metadata

Field	Value
Publication number	US-10452646-B2
Application number	US-201715794335-A
Country	US
Kind code	B2
Filing date	Oct 26, 2017
Priority date	Oct 26, 2017
Publication date	Oct 22, 2019
Grant date	Oct 22, 2019

Abstract

The present disclosure involves systems, software, and computer implemented methods for deploying changes in a multi-tenancy database system. One example method includes upgrading at least one tenant database container in a database system. Table structure differences and table sharing type differences are determined by comparing tables in a current-version shared container to tables in a next-version shared container. A current key pattern configuration in the current-version shared container is compared to an updated key pattern configuration in the next-version shared container to identify key pattern configuration differences. Each table in the at least one tenant database container is upgraded based on the table structure differences, the table sharing type differences, and the key pattern configuration differences.

First claim

What is claimed is:

1. A database system comprising:
one or more computers;
a computer-readable medium coupled to the one or more computers, the computer readable medium having instructions stored thereon which, when executed by the one or more computers, cause the one or more computers to perform operations;
wherein the computer readable medium includes:
a current-version shared database container;
a next-version shared database container; and
at least one tenant database container;

wherein each tenant database container includes local content that is local to a respective tenant; and
wherein the current-version shared database container includes shared content shared by multiple tenants and a current key pattern configuration, the current key pattern configuration specifying data that is allowed to be written, by tenants that are connected to the current-version shared database container, to respective tenant database containers;
wherein the next-version shared database container is a copy of the current-version shared database container that includes updated shared content that has been modified to reflect changes for a new version of the database system and an updated key pattern configuration that specifies data that is allowed to be written, by tenants that are connected to the next-version shared database container, to respective tenant database containers; and
wherein the deployment tool is configured to upgrade the at least one tenant database container;
and wherein the operations include:
determining a table structure and a table sharing type for each table in the current-version shared database container;
determining a table structure and a table sharing type for each table in the next-version shared database container;
comparing the table structures of the tables in the current-version shared database container to the table structures of the tables in the next-version shared database container to identify table structure differences;
comparing the table sharing types of the tables in the current-version shared database container to the table sharing types of the tables in the next-version shared database container to identify table sharing type differences;
comparing the current key pattern configuration to the updated key pattern configuration to identify key pattern configuration differences; and
upgrading each table in the at least one tenant database container based on the table structure differences, the table sharing type differences, and the key pattern configuration differences.

2. The system of claim 1 , wherein upgrading a given table comprises determining whether a table structure difference, a sharing type difference, or a key pattern configuration difference applies to the given table.

3. The system of claim 2 , wherein the operations include:
determining that one type of difference applies to the given table, the one type of difference being one of the table structure difference, the sharing type difference, or the key pattern configuration difference; and wherein upgrading the given table comprises:
updating a table structure of the given table based on the table structure difference, using a table structure change infrastructure, when the one type of difference is the table structure difference;
updating a table sharing type of the given table based on the sharing type difference, using a table sharing type change infrastructure, when the one type of difference is the table sharing type difference; and
upgrading the table based on the key pattern configuration difference, using a key pattern change infrastructure, when the one type of difference is the key pattern configuration difference.

4. The system of claim 3 , wherein the operations include:
determining that a table structure difference and a sharing type difference apply to the given table; and
upgrading the given table using the sharing type change infrastructure based on the sharing type difference and the table structure difference.

5. The system of claim 3 , wherein the operations include:
determining that a table structure difference and a key pattern configuration difference apply to the given table;
updating the table structure of the given table, based on the table structure difference, using the table structure change infrastructure; and
upgrading the table based on the key pattern configuration difference, using the key pattern change infrastructure, after the table structure of the given table has been updated.

6. The system of claim 3 , wherein the one type of difference is the table structure difference and updating the table structure comprises determining a sharing type of the given table.

7. The system of claim 6 , wherein the determined sharing type of the given table is writable, and updating the table structure comprises:
identifying the given table as a first writable table in the tenant database container being upgraded;
changing the structure of the first writable table based on the table structure difference.

8. The system of claim 6 , wherein the determined sharing type of the given table is read-only, and updating the table structure comprises:
identifying a first view in the tenant database container being upgraded, the first view providing access to a first read-only table included in the current-version shared database container;
dropping the first view;
creating a second view, in the tenant database container being upgraded, to a second read-only table included in the next-version shared database container.

9. The system of claim 6 , wherein the determined sharing type of the given table is split, and updating the table structure comprises:
identifying a first view in the tenant database container being upgraded, the first view providing access to a first read-only table included in the current-version shared database container, the first read-only table storing read-only records associated with a split table;
dropping the first view;
creating a second view, in the tenant database container being upgraded, to a second read-only table included in the next-version shared database container;
identifying a first writable table in the tenant database container being upgraded, the first writable table storing writable records associated with the split table;
identifying a union view in the tenant database container being upgraded, the union view providing unified access to the first read-only table and the first writable table;
adjusting the structure of the first writable table based on the table structure difference to create an adjusted writable table;
dropping the union view; and
creating a new union view that provides unified access to the first read-only table and the adjusted writable table.

10. A method comprising:
identifying, in a database system, a current-version shared database container, the current-version shared database container including shared content shared by multiple tenants and a current key pattern configuration, the current key pattern configuration specifying data that is allowed to be written, by tenants that are connected to the current-version shared database container, to respective tenant database containers;
identifying a next-version shared database container, the next-version shared database container being a copy of the current-version shared database container that includes updated shared content that has been modified to reflect changes for a new version of the database system and an updated key pattern configuration that specifies data that is allowed to be written, by tenants that are connected to the next-version shared database container, to respective tenant database containers; and
upgrading the at least one

Assignees

• Sap Se

Inventors

• Schlarb Uwe
• Neufeld Andrea
• Birn Immo-Gert
• Driesen Volker

Classifications

• G06F16/248

  Presentation of query results · CPC title

• G06F16/24553

  of query operations · CPC title

• G06F16/2264

  Multidimensional index structures · CPC title

• G06F21/6218

  to a system of files or objects, e.g. local or distributed file system or database · CPC title

• G06F16/21

  Design, administration or maintenance of databases · CPC title