In-memory database for multi-tenancy
An in-memory database server hosting a tenant of a multi-tenant software architecture can receive a definition of a custom data field that is unique to an organization having isolated access to the tenant. The custom data field can extend a standard table defined by central metadata stored at a system tenant of the multi-tenant software architecture. Tenant private metadata that includes the definition can be stored in memory accessible only to the tenant. A tenant-dependent table that includes the custom data field can be formed, for example by retrieving central metadata defining the standard table from the system tenant and adding the custom data field using the definition. The tenant-dependent table can be presented for access via a database client at the organization. Related systems, articles of manufacture, and computer-implemented methods are disclosed.
1. A system comprising:
at least one programmable processor; and
at least one memory including program code, which when executed by the at least one processor, causes the at least one programmable processor to perform operations comprising:
receiving, at an in-memory database server hosting a tenant of a multi-tenant software system, a definition of a custom data field that is unique to an organization having isolated access to the tenant, the custom data field extending a standard table defined by central metadata stored at a system tenant of the multi-tenant software system;
forming a tenant-dependent table comprising the custom data field, the forming comprising retrieving, from the system tenant, central metadata defining the standard table and adding, based on the received definition, the custom data field; and
accessing, via a database client at the organization having isolated access to the tenant, the tenant-dependent table.
2. The system of claim 1 , wherein the accessing further comprises presenting, via the database client at the organization having isolated access to the tenant, the tenant-dependent table.
3. The system of claim 1 , wherein the multi-tenant software system comprises a plurality of tenants hosted at a backend system, each tenant of the plurality of tenants comprising its own dedicated in-memory database server having unique access to tenant-specific data, at least one of a plurality of database servers being provided via each of a plurality of hosts on the backend system.
4. The system of claim 3 , wherein the plurality of database servers share the central metadata of the system tenant.
5. The system of claim 3 , wherein the system tenant comprises a central metadata master database server responsible for creating and maintaining the central metadata, and wherein each host of the plurality of hosts comprises a local metadata master database server that receives a copy of the central metadata from the central metadata master database server.
6. The system of claim 1 further comprising storing, in memory accessible only to the tenant, tenant private metadata comprising the definition.
7. A non-transitory computer-readable storage medium including instructions which when executed by at least one programmable processor cause the at least one programmable processor to perform operations comprising:
receiving, at an in-memory database server hosting a tenant of a multi-tenant software system, a definition of a custom data field that is unique to an organization having isolated access to the tenant, the custom data field extending a standard table defined by central metadata stored at a system tenant of the multi-tenant software system;
forming a tenant-dependent table comprising the custom data field, the forming comprising retrieving, from the system tenant, central metadata defining the standard table and adding, based on the received definition, the custom data field; and
accessing, via a database client at the organization having isolated access to the tenant, the tenant-dependent table.
8. The non-transitory computer-readable storage medium of claim 7 , wherein the accessing further comprises presenting, via the database client at the organization having isolated access to the tenant, the tenant-dependent table.
9. The non-transitory computer-readable storage medium of claim 7 , wherein the multi-tenant software system comprises a plurality of tenants hosted at a backend system, each tenant of the plurality of tenants comprising its own dedicated in-memory database server having unique access to tenant-specific data, at least one of a plurality of database servers being provided via each of a plurality of hosts on the backend system.
10. The non-transitory computer-readable storage medium of claim 9 , wherein the plurality of database servers share the central metadata of the system tenant.
11. The non-transitory computer-readable storage medium of claim 9 , wherein the system tenant comprises a central metadata master database server responsible for creating and maintaining the central metadata, and wherein each host of the plurality of hosts comprises a local metadata master database server that receives a copy of the central metadata from the central metadata master database server.
12. The non-transitory computer-readable storage medium of claim 7 further comprising storing, in memory accessible only to the tenant, tenant private metadata comprising the definition.
13. A computer-implemented method comprising:
receiving, at an in-memory database server hosting a tenant of a multi-tenant software system, a definition of a custom data field that is unique to an organization having isolated access to the tenant, the custom data field extending a standard table defined by central metadata stored at a system tenant of the multi-tenant software system;
forming a tenant-dependent table comprising the custom data field, the forming comprising retrieving, from the system tenant, central metadata defining the standard table and adding, based on the received definition, the custom data field; and
accessing, via a database client at the organization having isolated access to the tenant, the tenant-dependent table.
14. The computer-implemented method of claim 13 , wherein the accessing further comprises presenting, via the database client at the organization having isolated access to the tenant, the tenant-dependent table.
15. The computer-implemented method of claim 13 , wherein the multi-tenant software system comprises a plurality of tenants hosted at a backend system, each tenant of the plurality of tenants comprising its own dedicated in-memory database server having unique access to tenant-specific data, at least one of a plurality of database servers being provided via each of a plurality of hosts on the backend system.
16. The computer-implemented method of claim 15 , wherein the plurality of database servers share the central metadata of the system tenant.
17. The computer-implemented method of claim 15 , wherein the system tenant comprises a central metadata master database server responsible for creating and maintaining the central metadata, and wherein each host of the plurality of hosts comprises a local metadata master database server that receives a copy of the central metadata from the central metadata master database server.
18. The computer-implemented method of claim 13 , further comprising storing, in memory accessible only to the tenant, tenant private metadata comprising the definition.