Supporting multi-tenant applications on a shared database using pre-defined attributes
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.
1. A method for managing a multi-tenant database, the method comprising:
implementing a database server comprising attributes of each tenant among a plurality tenants in a multi-tenant database system, the attributes being selected from a group consisting of: (i) an application name; (ii) a accounting string; (iii) a workstation name; (iv) an internet protocol (IP) address; (v) a system authentication identifier; (vi) a session authentication identifier; (vii) a service class;
receiving, from a first tenant of the plurality of tenants, a structured query language (SQL) database query directed to a multi-tenant database, where the SQL database query comprises a client information field of the attributes of the first tenant, the client information field having been set up in conjunction with creation of a user account of the first tenant, and the client information field comprising the IP address of the first tenant;
determining a tenant identifier (tenant ID), of the first tenant, by reference to the client information field from the IP address using the attributes of the first tenant in the database server;
injecting, the tenant ID into the SQL database query to produce an injected database query;
determining a priority level of a connection of the injected database query by the first tenant to the multi-tenant database from a set of priority levels based on service class of the first tenant;
establishing a workload balance action responsive to the connection of the injected database query according to the priority level and workload of the multi-tenant database system;
sending the injected database query to the database management system according to the workload balance action and the session authentication identifier of the first tenant;
receiving a query result from the database management system based on the system authentication identifier of the first tenant;
sending the query result to the first tenant; and
responsive to receiving the database query, writing the first tenant ID in: a trace, a log, and accounting statistics;
wherein at least the injecting step is performed by computer software running on computer hardware.
2. 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 second tenant data owned by a second tenant.
3. 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 a second tenant.
4. The method of claim 1 , further comprising: writing a set of accounting statistics based on a tenant usage.