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

• US 20160292236A1
• Filed: 03/08/2016
• 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,528,528 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. A method for establishing a multi-tenant database, the method comprising:

determining a database server attribute as a tenant identifier (ID) for a first tenant;

receiving a database query originating from the first tenant;

modifying the database query to create a modified query by injecting the tenant ID into the database query; and

querying a database server with the modified query;

wherein;

at least the modifying and querying steps are performed by computer software running on computer hardware.

2. The method of claim 1, 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.

3. The method of claim 1, 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.

4. The method of claim 1, 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.

5. The method of claim 1, further comprising:

responsive to receiving the modified query, returning a qualified dataset to a first tenant;

6. The method of claim 1, further comprising:

determining a priority for each connection of a set of connections from a set of tenants.

7. The method of claim 1, further comprising:

writing a set of accounting statistics based on a tenant usage.

8. The method of claim 1, further comprising:

identifying the first tenant in a problem determination dataset including a trace and a log.

9. The method of claim 1, wherein the database server attribute is an attribute used for at least one of workload balancing, accounting, log filtering, and problem determination.

10. The method of claim 9, wherein the database server attribute is a value in a client information field.