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 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.