Extending database tables in a multi-tenant environment
First Claim
Patent Images
1. A computer-implemented method to provide a database table adaptable to include tenant-specific and tenant-neutral columns, the method comprising:
- receiving, from a first tenant of a plurality of tenants, a request to adapt a database table in a multi-tenant database system to include a first tenant-specific column that is specific to the first tenant, wherein the database table has an associated schema specifying that the database table includes an extended field;
adapting the database table to include the first tenant-specific column by generating a first description file corresponding to the first tenant and to the database table according to the received request and by operation of one or more computer processors, the first description file associating the extended field with the first tenant-specific column; and
rewriting, based on the first description file, a data processing request received from the first tenant and pertaining to the first tenant-specific column, wherein the first description file is located according to identification information contained in the data processing request, wherein data processing is performed using the rewritten data processing request.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments relate to database technology, and more specifically, to extending database tables in a multi-tenant environment. A method for extending a database table, includes receiving a request of a tenant for extending a database table; and generating a description file corresponding to the tenant according to the received request, the description file describing an extended field defined for the database table as at least one extended column.
39 Citations
17 Claims
-
1. A computer-implemented method to provide a database table adaptable to include tenant-specific and tenant-neutral columns, the method comprising:
-
receiving, from a first tenant of a plurality of tenants, a request to adapt a database table in a multi-tenant database system to include a first tenant-specific column that is specific to the first tenant, wherein the database table has an associated schema specifying that the database table includes an extended field; adapting the database table to include the first tenant-specific column by generating a first description file corresponding to the first tenant and to the database table according to the received request and by operation of one or more computer processors, the first description file associating the extended field with the first tenant-specific column; and rewriting, based on the first description file, a data processing request received from the first tenant and pertaining to the first tenant-specific column, wherein the first description file is located according to identification information contained in the data processing request, wherein data processing is performed using the rewritten data processing request. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A system to provide a database table adaptable to include tenant-specific and tenant-neutral columns, the system comprising:
-
a hardware storage element containing a database table; and a processor which, when executing a program, is configured to; receive, from a first tenant of a plurality of tenants, a request to adapt a database table in a multi-tenant database system to include a first tenant-specific column that is specific to the first tenant, wherein the database table has an associated schema specifying that the database table includes an extended field; adapt the database table to include the first tenant-specific column by generating a first description file corresponding to the first tenant and to the database table according to the received request, the first description file associating the extended field with the first tenant-specific column; and rewrite, based on the first description file, a data processing request received from the first tenant and pertaining to the first tenant-specific column, wherein the first description file is located according to identification information contained in the data processing request, wherein data processing is performed using the rewritten data processing request. - View Dependent Claims (14)
-
-
15. A computer program product to provide a database table adaptable to include tenant-specific and tenant-neutral columns, the computer program product comprising:
-
a computer-readable storage medium having computer-readable program code embodied therewith, the computer-readable program code comprising; first computer-readable program code configured to receive, from a first tenant of a plurality of tenants, a request to adapt a database table in a multi-tenant database system to include a first tenant-specific column that is specific to the first tenant, wherein the database table has an associated schema specifying that the database table includes an extended field; second computer-readable program code configured to adapt the database table to include the first tenant-specific column by generating a first description file corresponding to the first tenant and to the database table according to the received request and by operation of one or more computer processors when executing the computer-readable program code, the first description file associating the extended field with the first tenant-specific column; and third computer-readable program code configured to rewrite, based on the first description file, a data processing request received from the first tenant and pertaining to the first tenant-specific column, wherein the first description file is located according to identification information contained in the data processing request, wherein data processing is performed using the rewritten data processing request. - View Dependent Claims (16, 17)
-
Specification