Systems and methods for multitenancy data

• US 9,542,432 B2
• Filed: 12/20/2011
• Issued: 01/10/2017
• Est. Priority Date: 09/30/2011
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Pelletier, Guy, Clarke, Douglas
• Primary Examiner(s): Rones, Charles
• Assistant Examiner(s): WONG, NANCI N
• Application Number:
  US13/332,126
• Publication Number:
  US 20130086322A1
• Time in Patent Office: 1,848 Days
• Field of Search: 711/119
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity

Abstract

Systems and methods are provided to support multitenant data in an EclipseLink environment. EclipseLink supports shared multitenant tables using tenant discriminator columns, allowing an application to be re-used for multiple tenants and have all their data co-located. Tenants can share the same schema transparently, without affecting one another and can use non-multitenant entity types as per usual. This functionality is flexible enough to allow for its usage at an Entity Manager Factory level or with individual Entity Manager'"'"'s based on the application'"'"'s needs. Support for multitenant entities can be done though the usage of a multitenant annotation or <multitenant> xml element configured in an eclipselink-orm.xml mapping file. The multitenant annotation can be used on an entity or mapped superclass and is used in conjunction with a tenant discriminator column or <tenant-discriminator-column> xml element.

Claims

1. A method for supporting multitenant data in a multitenant system, the method comprising:

configuring a multitenant application to be used by a plurality of tenants, wherein each tenant of the plurality of tenants is associated with a different tenant discriminator value identifying said tenant;

storing data for use by said multitenant application in a table corresponding to an entity defined by said multitenant application such that columns of the table correspond to properties of the entity, wherein said table is a shared multitenant table in which all of said data for all of the plurality of tenants is co-located, and wherein said table holds a plurality of rows of data from each of said plurality of tenants;

providing said table with a tenant discrimination column for holding tenant discriminator values which identify which of said plurality of rows of data held in said table is associated with which particular tenant of the plurality of tenants;

creating a plurality of entity managers including an entity manager for each tenant of said plurality of tenants, wherein the entity manager associated with each tenant of said plurality of tenants is configured with the tenant discriminator value associated with said each tenant of said plurality of tenants by one of the multitenant application or a shared entity manager factory configured to create the plurality of entity managers;

creating a plurality of transactional entity instances, using said multitenant application, for each of said plurality of tenants, wherein each of said plurality of transactional entity instances is associated with a particular row of data of said plurality of rows of data and with a tenant discriminator value used to identify a particular one of said plurality of tenants, and wherein each of said plurality of transactional entity instances is associated with a transaction performed by said multitenant application on said row of data held in said table and identified by the tenant discriminator value associated with said entity instance;

providing a plurality of caches, wherein a different one of said plurality of caches is associated with each particular one of the plurality of tenants; and

using each cache to manage transactional entity instances associated with said particular one of said plurality of tenants associated with the cache.

2. The method of claim 1, further comprising:

said multitenant application requesting a particular cache associated with a particular tenant.

3. The method of claim 1, further comprising:

providing said table with a plurality of tenant discrimination columns.

4. The method of claim 1, further comprising:

managing the plurality of transactional entity instances associated with each of said plurality of tenants with the entity manager associated with said each of said plurality of tenants.

5. The method of claim 1, further comprising:

automatically augmenting database queries directed to said table to limit query results based on the tenant discriminator values.

6. The method of claim 1, further comprising:

providing said shared entity manager factory; and

wherein the entity manager associated with each tenant of said plurality of tenants is configured with the tenant discriminator value associated with said each tenant of said plurality of tenants by said shared entity manager factory.

7. The method of claim 1, wherein the entity manager associated with each tenant of said plurality of tenants is configured with the tenant discriminator value associated with said each tenant of said plurality of tenants directly by said multitenant application.

8. A non-transitory computer readable storage medium including instructions stored thereon for supporting multitenant data in a multitenant system, which instructions, when executed by a computer, cause the computer to:

configure a multitenant application to be used by a plurality of tenants wherein each tenant of the plurality of tenants is associated with a different tenant discriminator value identifying said tenant;

store data for use by said multitenant application in a table corresponding to an entity defined by said multitenant application such that columns of the table correspond to properties of the entity, wherein said table is a shared multitenant table in which all of said data for all of the plurality of tenants is co-located, and wherein said table holds a plurality of rows of data from each of said plurality of tenants;

provide said table with a tenant discrimination column for holding tenant discriminator values which identify which of said plurality of rows of data held in said table is associated with which particular tenant of the plurality of tenants;

create a plurality of entity managers including an entity manager for each tenant of said plurality of tenants, wherein the entity manager associated with each tenant of said plurality of tenants is configured with the tenant discriminator value associated with said each tenant of said plurality of tenants by one of the multitenant application or a shared entity manager factory configured to create the plurality of entity managers;

create a plurality of transactional entity instances, using said multitenant application, for each of said plurality of tenants wherein each of said plurality of transactional entity instances is associated with a particular row of data of said plurality of rows of data and with a tenant discriminator value used to identify a particular one of said plurality of tenants, and wherein each of said plurality of transactional entity instances is associated with a transaction performed by said multitenant application on said row of data held in said table and identified by the tenant discriminator value associated with said entity instance;

provide a plurality of caches, wherein a different one of said plurality of caches is associated with each particular one of the plurality of tenants; and

use each cache to manage transactional entity instances associated with said particular one of said plurality of tenants associated with the cache.

9. The non-transitory computer readable storage medium of claim 8, further including instructions which, when executed by a computer, cause the computer to:

request a particular cache associated with a particular tenant.

10. The non-transitory computer readable storage medium of claim 8, further including instructions which, when executed by a computer, cause the computer to:

provide said table with a plurality of tenant discrimination columns.

11. The non-transitory computer readable storage medium of claim 8, further including instructions which, when executed by a computer, cause the computer to:

manage the plurality of transactional entity instances associated with each of said plurality of tenants with the entity manager associated with said each of said plurality of tenants.

12. The non-transitory computer readable storage medium of claim 8, further including instructions which, when executed by a computer, cause the computer to:

automatically augment database queries directed to said table to limit query results based on the tenant discriminator values.

13. The non-transitory computer readable storage medium of claim 8, further including instructions which, when executed by a computer, cause the computer to:

provide said shared entity manager factory; and

wherein the entity manager associated with each tenant of said plurality of tenants is configured with the tenant discriminator value associated with said each tenant of said plurality of tenants by said shared entity manager factory.

14. A multitenant system, comprising:

a microprocessor;

a multitenant application executing on the microprocessor, and configured to be used by a plurality of tenants, wherein each tenant of the plurality of tenants is associated with a different tenant discriminator value identifying said tenant;

a table which holds data corresponding to an entity defined by said multitenant application such that columns of the table correspond to properties of the entity, wherein said table is a shared multitenant table in which all of said data for all of the plurality of tenants is co-located, wherein said table holds a plurality of rows of data from each of said plurality of tenants, and wherein said table comprises a tenant discrimination column holding tenant discriminator values used to identify which of said plurality of rows of data held in said table is associated with which particular tenant of the plurality of tenants;

a plurality of transactional entity instances for each of said plurality of tenants, wherein each of said plurality of transactional entity instances is associated with a particular row of data of said plurality of rows of data and with a tenant discriminator value used to identify a particular one of said plurality of tenants, and wherein each of said plurality of transactional entity instances is associated with a transaction effected by said multitenant application on said particular row of data associated with said transactional entity instance;

a plurality of entity managers comprising an entity manager associated with each tenant of said plurality of tenants wherein each entity manager is configured with the tenant discriminator value associated with each respective tenant of said plurality of tenants by one of the multitenant application or a shared entity manager factory configured to create the plurality of entity managers; and

a plurality of caches, wherein a different one of said plurality of caches is associated with each particular one of the plurality of tenants, and wherein each cache is configured to manage transactional entity instances associated with said particular one of said plurality of tenants associated with the cache.

15. The multitenant system of claim 14, wherein said multitenant application is configured to request a particular cache associated with a particular tenant.

16. The multitenant system of claim 14, wherein said table includes a plurality of tenant discrimination columns.

17. The multitenant system of claim 14, wherein the entity manager associated with each of said plurality of tenants is configured to manage the plurality of transactional entity instances associated with said each of said plurality of tenants.

18. The multitenant system of claim 14, wherein database queries directed to said table are automatically augmented to limit query results based on the tenant discriminator values.

19. The system of claim 14, wherein the system comprises the shared entity manager factory and wherein each entity manager is configured with the tenant discriminator value associated with said each respective tenant of said plurality of tenants by the shared entity manager factory.

20. The system of claim 14, wherein each entity manager is configured with the tenant discriminator value associated with each respective tenant of said plurality of tenants directly by the multitenant application.