SUPPORTING MULTI-TENANT APPLICATIONS ON A SHARED DATABASE USING PRE-DEFINED ATTRIBUTES

• US 20160292216A1
• Filed: 04/01/2015
• Published: 10/06/2016
• Est. Priority Date: 04/01/2015
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Joshi, Vinayak, Priyadarshini, Pallavi, Tatini, Parameswara R., Weihrauch, Maryela E.
• Granted Patent: US 10,628,388 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/1805 Append-only file systems, e.g. using logs or journals to store data
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

Exposing existing database server attributes that are used for load balancing, accounting, log filtering, problem determination, and end user identification as tenant identifiers. An example of such attribute is the values in existing client information fields that are available to applications for passing additional information to the database server via connections. These values are then used by the database server for enhanced operational functions of load balancing, accounting, log filtering, problem determination, and end user identification.

Claims

1-10. -10. (canceled)

11. A computer program product for establishing a multi-tenant database, the computer program product comprising a computer readable storage medium having stored thereon:

first program instructions programmed to determine a database server attribute as a tenant identifier (ID) for a first tenant;

second program instructions programmed to receive a database query originating from the first tenant; and

third program instructions programmed to modify the database query to create a modified query by injecting the tenant ID into the database query; and

fourth program instructions programmed to query a database server with the modified query.

12. The computer program product of claim 11, wherein the multi-tenant database includes a shared database table including first tenant data owned by the first tenant and a second tenant data owned by the second tenant.

13. The computer program product of claim 11, wherein the multi-tenant database includes a first tenant table owned by the first tenant and a second tenant table owned by the second tenant.

14. The computer program product of claim 11, having further stored thereon:

fifth program instructions programmed to responsive to receiving the modified query, return a qualified dataset to the first tenant.

15. The computer program product of claim 11, wherein the computer program product is provided as a service in a cloud environment.

21. The computer program product of claim 11, wherein modifying the database query to create a modified query by injecting the tenant ID into the database query is performed by a database driver between an application layer and a database layer.

22. The computer program product of claim 11, having further stored thereon:

fifth program instructions programmed to determine a priority for each connection of a set of connections from a set of tenants.

23. The computer program product of claim 11, having further stored thereon:

fifth program instructions programmed to write a set of accounting statistics based on a tenant usage.

24. The computer program product of claim 11, having further stored thereon:

fifth program instructions programmed to identify the first tenant in a problem determination dataset including a trace and a log.

25. The computer program product of claim 11, wherein the database server attribute is an attribute used for at least one of workload balancing, accounting, log filtering, and problem determination.

26. The computer program product of claim 11, wherein the database server attribute is a value in a client information field.

16. A computer system for establishing a multi-tenant database, the computer system comprising:

a processor(s) set; and

a computer readable storage medium;

wherein;

the processor set is structured, located, connected and/or programmed to run program instructions stored on the computer readable storage medium; and

the program instructions include;

first program instructions programmed to determine a database server attribute as a tenant identifier (ID) for a first tenant;

second program instructions programmed to receive a database query originating from the first tenant; and

third program instructions programmed to modify the database query to create a modified query by injecting the tenant ID into the database query; and

fourth program instructions programmed to query a database server with the modified query.

17. The computer system of claim 16, wherein the multi-tenant database includes a shared database table including first tenant data owned by the first tenant and a second tenant data owned by the second tenant.

18. The computer system of claim 16, wherein the multi-tenant database includes a first tenant table owned by the first tenant and a second tenant table owned by the second tenant.

19. The computer system of claim 16, the program instructions further including:

fifth program instructions programmed to responsive to receiving the modified query, return a qualified dataset to the first tenant.

20. The computer system of claim 16, the program instructions further including:

fifth program instructions programmed to determine a priority for each connection of a set of connections from a set of tenants.

27. The computer system of claim 16, wherein modifying the database query to create a modified query by injecting the tenant ID into the database query is performed by a database driver between an application layer and a database layer.

28. The computer system of claim 16, the program instructions further including:

fifth program instructions programmed to write a set of accounting statistics based on a tenant usage.

29. The computer system of claim 16, the program instructions further including:

fifth program instructions programmed to identify the first tenant in a problem determination dataset including a trace and a log.

30. The computer system of claim 16, wherein the database server attribute is an attribute used for at least one of workload balancing, accounting, log filtering, and problem determination.