Tenant customization of master data in a multi-tenant computing system

Patent metadata

Field	Value
Publication number	US-11526497-B2
Application number	US-202017114135-A
Country	US
Kind code	B2
Filing date	Dec 7, 2020
Priority date	Dec 7, 2020
Publication date	Dec 13, 2022
Grant date	Dec 13, 2022

Abstract

A method can include initiating one or more transactions in response to a request associated with a first tenant in a multi-tenant computing system. The multi-tenant computing system can store a table of system master data. A determination can be made as to whether the first tenant has a table of customized master data that can include customized data values absent from the table of system master data. Based on the determination, one or more of the table of system master data and the table of customized master data can be used to respond to the request. A response to the request can be provided. Related systems and articles of manufacture, including computer program products, are also provided.

First claim

What is claimed is:

1. A computer-implemented method, comprising:
exporting a table of system master data to a first tenant included in a plurality of tenants in a multi-tenant computing system causing the first tenant to generate a table of customized master data from the table of system master data, the multi-tenant computing system comprising a first database having one or more partitions, each partition corresponding to one or more of the plurality of tenants, one of the partitions storing the table of system master data available for use by each of the plurality of tenants, the table of system master data comprising one or more attributes, each attribute having a corresponding set of one or more values;
initiating one or more transactions in response to a request associated with the first tenant;
determining whether the first tenant has the table of customized master data, the table of customized master data including one or more customized data values absent from the set of one or more values in the table of system master data, the table of customized master data accessible only for transactions associated with the first tenant;
determining whether the table of system master data is sufficient to generate a response to the request;
in response to determining whether the table of system master data is sufficient to generate the response and whether the first tenant has a table of customized master data, using one or more of the table of system master data and the table of customized master data to respond to the request; and
providing a response to the request.

2. The computer-implemented method of claim 1 , wherein the table of customized master data is stored at a first partition in the first database, the first partition associated with the first tenant.

3. The computer-implemented method of claim 1 , wherein the table of customized master data is stored at a second database maintained by the first tenant.

4. The computer-implemented method of claim 3 , wherein the determining further comprises:
querying the first database to determine a location of the table of customized data values; and
querying the second database to determine the location of the table of customized data values.

5. The computer-implemented method of claim 4 , wherein the first database is queried before the second database.

6. The computer-implemented method of claim 4 , wherein the first database is queried at approximately the same time as the second database.

7. The computer-implemented method of claim 3 , further comprising:
fetching the one or more customized data values from the table of customized master data at the second database; and
combining the one of more customized data values with the one or more values in the table of system master data to respond to the request.

8. The computer-implemented method of claim 1 , wherein the multi-tenant computing system further comprises one or more applications, and
wherein the first tenant is associated with one or more user nodes logged into the one or more applications.

9. The computer-implemented method of claim 8 , further comprising:
sending a notification to each of the one or more user nodes regarding the table of customized master data, the notification causing the one or more user nodes to update one or more caches to reflect the table of customized master data.

10. The computer-implemented method of claim 8 , wherein the one or more applications comprises an upstream application and a downstream application.

11. The computer-implemented method of claim 10 , further comprising:
sending a notification to the downstream application regarding the table of customized master data.

12. The computer-implemented method of claim 1 , further comprising:
maintaining a record of one or more changes to the table of customized master data.

13. A system, comprising:
at least one data processor; and
at least one memory storing instructions which, when executed by the at least one data processor, result in operations comprising:
exporting a table of system master data to a first tenant included in a plurality of tenants in a multi-tenant computing system causing the first tenant to generate a table of customized master data from the table of system master data, the multi-tenant computing system comprising a first database having one or more partitions, each partition corresponding to one or more of the plurality of tenants, one of the partitions storing the table of system master data available for use by each of the plurality of tenants, the table of system master data comprising one or more attributes, each attribute having a corresponding set of one or more values;
initiating one or more transactions in response to a request associated with the first tenant;
determining whether the first tenant has the table of customized master data, the table of customized master data including one or more customized data values absent from the set of one or more values in the table of system master data, the table of customized master data accessible only for transactions associated with the first tenant;
determining whether the table of system master data is sufficient to generate a response to the request;
in response to determining whether the table of system master data is sufficient to generate the response and whether the first tenant has a table of customized master data, using one or more of the table of system master data and the table of customized master data to respond to the request; and
providing a response to the request.

14. The system of claim 13 , wherein the table of customized master data is stored at a first partition in the first database, the first partition associated with the first tenant.

15. The system of claim 13 , wherein the table of customized master data is stored at a second database maintained by the first tenant.

16. The system of claim 13 , wherein the multi-tenant computing system further comprises one or more applications,
wherein the first tenant is associated with one or more user nodes logged into the one or more applications, and
wherein the operations further comprise:
sending a notification to each of the one or more user nodes regarding the table of customized master data, the notification causing the one or more user nodes to update one or more caches to reflect the table of customized master data.

17. The system of claim 16 , wherein the one or more applications comprises an
upstream application and a downstream application, and
wherein the operations further comprise:
sending a notification to the downstream application regarding the table of customized master data.

18. A non-transitory computer readable medium storing instructions, which when executed by at least one data processor, result in operations comprising:
exporting a table of system master data to a first tenant included in a plurality of tenants in a multi-tenant computing system causing the first tenant to generate a table of customized master data from the table of system master data, the multi-tenant computing system comprising a first database having one or more partitions, each partition corresponding to one or more of the plurality of tenants, one of the partitions storing the table of system master data available for use by each of the plurality of tenants, the table of system master data comprising one or more attributes, each attribute having a corresponding set of one or more values;
initiating one or more transactions in response to a request associated with the first tenant;
determining

Assignees

• Sap Se

Inventors

• Banerjee Rick
• Joshi Himanshu

Classifications

• G06F16/252 Primary

  between a Database Management System and a front-end application · CPC title

• G06F16/278

  Data partitioning, e.g. horizontal or vertical partitioning · CPC title

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title

• G06F16/245

  Query processing · CPC title

• G06F16/2471

  Distributed queries · CPC title