Dynamic structure for a multi-tenant database

• US 8,930,413 B2
• Filed: 01/03/2012
• Issued: 01/06/2015
• Est. Priority Date: 01/03/2012
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Tang, Weng Sing, Xu, Liang
• Primary Examiner(s): SYED, FARHAN M
• Application Number:
  US13/342,530
• Publication Number:
  US 20130173669A1
• Time in Patent Office: 1,099 Days
• US Class Current: 707/803
• CPC Class Codes: G06F 16/211 Schema design and management

Abstract

Embodiments for using a dynamic structure of tables in a schema of a multi-tenant database are provided. For a tenant schema including a set of tenant tables, a label is created for a tenant table in the set of tenant tables. The label is partitioned into a set of constituent primary labels. A subset of columns is selected from the set of n columns of the tenant table, the subset of columns corresponding to a primary label in the set of constituent primary labels. The subset of columns is mapped to a table in the dynamic structure of tables in the schema of the multi-tenant database, the table in the dynamic structure of tables having the primary label. In the multi-tenant database executing in a data processing system, the dynamic structure of tables is populated with data from the tenant schema according to the mapping.

Claims

1. A computer implemented method for using a dynamic structure of tables in a schema of a multi-tenant database, the method comprising:

creating, for a tenant schema including a set of tenant tables, a label for a tenant table in the set of tenant tables, wherein the tenant table includes a set of n columns, and wherein the label is formed by converting (n−

1) to a representation in a selected base system;

partitioning the label into a set of constituent primary labels;

selecting a subset of columns from the set of n columns of the tenant table, the subset of columns corresponding to a primary label in the set of constituent primary labels;

mapping the subset of columns to a table in the dynamic structure of tables in the schema of the multi-tenant database, the table in the dynamic structure of tables having the primary label; and

populating, in the multi-tenant database executing in a data processing system, the dynamic structure of tables with data from the tenant schema according to the mapping.

2. The computer implemented method of claim 1, wherein the selected base system is 2.

3. The computer implemented method of claim 1, wherein a primary label in the set of constituent primary labels comprises a single 1 in the leading position.

4. The computer implemented method of claim 1, further comprising:

creating the dynamic structure of tables in the schema of the multi-tenant database, such that a table in the dynamic structure of tables corresponds to a primary label under a selected M-nary base system where M is any natural number.

5. The computer implemented method of claim 4, wherein the m-nary base system is a base 3 system.

6. The computer implemented method of claim 4, further comprising:

creating a set of (M−

1) versions of a first table corresponding to first primary label; and

uniquely identifying each version of the first table in the set of (M−

1) versions such that the subset of columns is mapped to a first identified version in the set in priority over a second identified version in the set.

7. A computer usable program product comprising a computer readable storage device including computer usable code for using a dynamic structure of tables in a schema of a multi-tenant database, the computer usable code comprising:

computer usable code for creating, for a tenant schema including a set of tenant tables, a label for a tenant table in the set of tenant tables, wherein the tenant table includes a set of n columns, and wherein the label is formed by converting (n−

1) to a representation in a selected base system;

computer usable code for partitioning the label into a set of constituent primary labels;

computer usable code for selecting a subset of columns from the set of n columns of the tenant table, the subset of columns corresponding to a primary label in the set of constituent primary labels;

computer usable code for mapping the subset of columns to a table in the dynamic structure of tables in the schema of the multi-tenant database, the table in the dynamic structure of tables having the primary label; and

computer usable code for populating, in the multi-tenant database executing in a data processing system, the dynamic structure of tables with data from the tenant schema according to the mapping.

8. The computer usable program product of claim 7, wherein the selected base system is 2.

9. The computer usable program product of claim 7, wherein a primary label in the set of constituent primary labels comprises a single 1 in the leading position.

10. The computer usable program product of claim 7, further comprising:

computer usable code for creating the dynamic structure of tables in the schema of the multi-tenant database, such that a table in the dynamic structure of tables corresponds to a primary label under a selected M-nary base system where M is any natural number.

11. The computer usable program product of claim 10, wherein the m-nary base system is a base 3 system.

12. The computer usable program product of claim 10, further comprising:

computer usable code for creating a set of (M−

1) versions of a first table corresponding to first primary label; and

computer usable code for uniquely identifying each version of the first table in the set of (M−

1) versions such that the subset of columns is mapped to a first identified version in the set in priority over a second identified version in the set.

13. The computer usable program product of claim 7, wherein the computer usable code is stored in a computer readable storage medium in a data processing system, and wherein the computer usable code is transferred over a network from a remote data processing system.

14. The computer usable program product of claim 7, wherein the computer usable code is stored in a computer readable storage medium in a server data processing system, and wherein the computer usable code is downloaded over a network to a remote data processing system for use in a computer readable storage medium associated with the remote data processing system.

15. A data processing system for using a dynamic structure of tables in a schema of a multi-tenant database, the data processing system comprising:

a storage device including a storage medium, wherein the storage device stores computer usable program code; and

a processor, wherein the processor executes the computer usable program code, and wherein the computer usable program code comprises;

computer usable code for creating, for a tenant schema including a set of tenant tables, a label for a tenant table in the set of tenant tables, wherein the tenant table includes a set of n columns, and wherein the label is formed by converting (n−

1) to a representation in a selected base system;

computer usable code for partitioning the label into a set of constituent primary labels;

computer usable code for selecting a subset of columns from the set of n columns of the tenant table, the subset of columns corresponding to a primary label in the set of constituent primary labels;

computer usable code for mapping the subset of columns to a table in the dynamic structure of tables in the schema of the multi-tenant database, the table in the dynamic structure of tables having the primary label; and

computer usable code for populating, in the multi-tenant database executing in the data processing system, the dynamic structure of tables with data from the tenant schema according to the mapping.

16. The data processing system of claim 15, wherein the selected base system is 2.

17. The data processing system of claim 15, wherein a primary label in the set of constituent primary labels comprises a single 1 in the leading position.