APPARATUS FOR PROCESSING MATERIALIZED TABLES IN A MULTI-TENANT APPLICATION SYSTEM

• US 20120030192A1
• Filed: 06/22/2011
• Published: 02/02/2012
• Est. Priority Date: 07/30/2010
• Status: Active Grant

• Current Assignee: ServiceNow Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: An, Wen Hao, Duan, Ning, Gao, Bo, Guo, Chang Jie, Wang, Zhi Hu
• Granted Patent: US 8,533,159 B2
• Time in Patent Office: Days
• US Class Current: 707/717
• CPC Class Codes: G06F 16/213 with details for schema evolution support
• CPC Class Codes: G06F 16/28 Databases characterised by their database models, e.g. relational or object models

Abstract

A method, system and computer program for processing materialized tables in a multi-tenant application system, wherein in the multi-tenant application system, a plurality of tenants share one or more basic-tables. According to the data access history information of the plurality of tenants, an update pattern analyzer analyzes the similarity of the update patterns for one or more basic-tables by the plurality of tenants. Furthermore, according to the similarity analyzed by the update pattern analyzer, a tenant grouping means groups the plurality of tenants into a plurality of tenant groups. Additionally, according to the tenant groups grouped by the tenant grouping means, a materialized table constructor constructs the tenant group materialized tables from the one or more basic-tables.

Claims

1. A method for processing materialized tables in a multi-tenant application system, wherein in the multi-tenant application system, a plurality of tenants share one or more basic-tables, the method comprising:

according to data access history information of said plurality of tenants, analyzing a similarity of update patterns for said one or more basic-tables by said plurality of tenants;

according to said similarity of update patterns analyzed, grouping said plurality of tenants into a plurality of tenant groups;

according to said plurality of tenant groups, constructing, by a processor, tenant group materialized tables from said one or more basic-tables.

2. The method as recited in claim 1 further comprising:

based on updates to said one or more basic-tables by a tenant, determining whether to enable or disable a corresponding tenant group materialized table.

3. The method as recited in claim 2 further comprising:

based on a determination that currently at least one tenant in said plurality of tenants will perform updates to a basic-table, determining to disable the tenant group materialized table of a tenant group to which the tenant belongs.

4. The method as recited in claim 2 further comprising:

after at least one tenant in said plurality of tenants performs updates to a basic-table, enabling the tenant group materialized table of a tenant group to which the tenant belongs.

5. The method as recited in claim 1, wherein the similarity of the update patterns includes adjacency in time of performing deletion, insertion or rewrite operations on records of an associated basic-table of a materialized table.

6. The method as recited in claim 1, wherein constructing a tenant group materialized table from said one or more basic-tables includes constructing the tenant group materialized table corresponding to a tenant group by using a DDL script.

7. The method as recited in claim 1 further comprising:

storing at least one of the following;

corresponding relationships between said plurality of tenants and said plurality of tenant groups; and

times for said plurality of tenants’

updates.

8. A computer program product embodied in a computer readable storage medium for processing materialized tables in a multi-tenant application system, wherein in the multi-tenant application system, a plurality of tenants share one or more basic-tables, the computer program product comprising the programming instructions for:

according to data access history information of said plurality of tenants, analyzing a similarity of update patterns for said one or more basic-tables by said plurality of tenants;

according to said similarity of update patterns analyzed, grouping said plurality of tenants into a plurality of tenant groups;

according to said plurality of tenant groups, constructing tenant group materialized tables from said one or more basic-tables.

9. The computer program product as recited in claim 8 further comprising the programming instructions for:

based on updates to said one or more basic-tables by a tenant, determining whether to enable or disable a corresponding tenant group materialized table.

10. The computer program product as recited in claim 9 further comprising the programming instructions for:

based on a determination that currently at least one tenant in said plurality of tenants will perform updates to a basic-table, determining to disable the tenant group materialized table of a tenant group to which the tenant belongs.

11. The computer program product as recited in claim 9 further comprising the programming instructions for:

after at least one tenant in said plurality of tenants performs updates to a basic-table, enabling the tenant group materialized table of a tenant group to which the tenant belongs.

12. The computer program product as recited in claim 8, wherein the similarity of the update patterns includes adjacency in time of performing deletion, insertion or rewrite operations on records of an associated basic-table of a materialized table.

13. The computer program product as recited in claim 8, wherein constructing a tenant group materialized table from said one or more basic-tables includes constructing the tenant group materialized table corresponding to a tenant group by using a DDL script.

14. The computer program product as recited in claim 8 further comprising the programming instructions for:

storing at least one of the following;

corresponding relationships between said plurality of tenants and said plurality of tenant groups; and

times for said plurality of tenants'"'"' updates.

15. A system, comprising:

a memory unit for storing a computer program for processing materialized tables in a multi-tenant application system, wherein in the multi-tenant application system, a plurality of tenants share one or more basic-tables; and

a processor coupled to said memory unit, wherein said processor, responsive to said computer program, comprises

according to data access history information of said plurality of tenants, circuitry for analyzing a similarity of update patterns for said one or more basic-tables by said plurality of tenants;

according to said similarity of update patterns analyzed, circuitry for grouping said plurality of tenants into a plurality of tenant groups;

according to said plurality of tenant groups, circuitry for constructing tenant group materialized tables from said one or more basic-tables.

16. The system as recited in claim 15, wherein said processor further comprises:

circuitry for based on updates to said one or more basic-tables by a tenant, determining whether to enable or disable a corresponding tenant group materialized table.

17. The system as recited in claim 16, wherein said processor further comprises:

based on a determination that currently at least one tenant in said plurality of tenants will perform updates to a basic-table, circuitry for determining to disable the tenant group materialized table of a tenant group to which the tenant belongs.

18. The system as recited in claim 16, wherein said processor further comprises:

after at least one tenant in said plurality of tenants performs updates to a basic-table, circuitry for enabling the tenant group materialized table of a tenant group to which the tenant belongs.

19. The system as recited in claim 15, wherein the similarity of the update patterns includes adjacency in time of performing deletion, insertion or rewrite operations on records of an associated basic-table of a materialized table.

20. The system as recited in claim 15, wherein constructing a tenant group materialized table from said one or more basic-tables includes constructing the tenant group materialized table corresponding to a tenant group by using a DDL script.