Dynamic structure for a multi-tenant database

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.

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.