In-memory caching of shared customizable multi-tenant data

• US 20080244184A1
• Filed: 03/30/2007
• Published: 10/02/2008
• Est. Priority Date: 03/30/2007
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Ott, Michael James, Smertin, Andrei, Grewal, Jay, Lewis, Elliot, Vijayaraghavan, Mahesh
• Granted Patent: US 8,095,618 B2
• Time in Patent Office: Days
• US Class Current: 711/130
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising

Abstract

In a multi-tenant data sharing environment with shared, customizable data attributes are assigned to requested data and stored in a cache store along with the requested data. For non-customized data designated as system data, one copy is stored in the cache store for use by multiple tenants allowing optimization of memory and performance for each data request/retrieval operation. A “delete sentinel” attribute may be assigned to non-existing data in the cache store enabling notification of requesting tenant(s) without a need to access the tenant data store each time a request for the non-existing data is received.

Claims

1. A method to be executed at least in part in a computing device for handling customizable data in a multi-tenant environment, the method comprising:

receiving a request for data from a tenant;

determining whether an entry associated with the requested data is stored in a cache store;

if the entry is stored and is a delete sentinel, providing a notice of non-existent data to the requesting tenant;

if the entry is stored and is a system sentinel, retrieving requested system data from the cache store and providing the data to the requesting tenant; and

if the entry is stored and is the requested data that is customized for the tenant, providing the customized requested data to the requesting tenant.

2. The method of claim 1, further comprising:

if no entry associated with the requested data is stored in the cache store;

determining whether the data exists in a data store associated with the tenant;

if the data does not exist in the data store associated with the tenant, storing a “

delete sentinel”

entry in the cache store and providing the notice of non-existent data to the requesting tenant;

if the data exists in the data store associated with the tenant and is customized data for the tenant, storing the customized data in the cache store and providing the customized data to the requesting tenant; and

if the data exists in the data store associated with the tenant and is system level data, storing a system sentinel and the system level data in the cache store and providing the customized data to any requesting tenant.

3. The method of claim 2, wherein only one copy of retrieved system level data is stored in the cache store for providing to any requesting tenant.

4. The method of claim 1, wherein the customized data is provided to the requesting tenant based on a data key and a tenant identifier associated with the request.

5. The method of claim 1, wherein data customized by a tenant is accessible by that tenant only.

6. The method of claim 1, further comprising:

enabling a tenant to access data customized by another tenant.

7. The method of claim 1, wherein the customizable data includes at least one from a set of:

metadata, a user interface form, a user interface view, an extensibility plug-in, and a communication parameter.

8. The method of claim 1, wherein a customization status of the data is stored as a customization level attribute.

9. A system for handling customizable data in a multi-tenant business application environment, comprising:

a cache memory;

a processor coupled to the memory, wherein the processor is configured to execute program modules including;

a caching module configured to;

determine whether an entry associated with the requested record is stored in the cache memory;

provide a notice of non-existent record to the requesting tenant responsive to determining that the entry is stored and is a delete sentinel;

retrieve the requested record from the cache memory and provide to the requesting tenant responsive to determining that the entry is stored and is a system sentinel, wherein a single copy of the record is stored in the cache memory for any requesting tenant; and

provide the customized requested record to the requesting tenant responsive to determining that the entry is stored and is the requested record customized for the tenant.

10. The system of claim 9, wherein the caching module is further configured to:

determine whether the record exists in a data store associated with the tenant responsive to determining that no entry associated with the record exists in the cache memory;

store a “

delete sentinel”

entry in the cache memory and provide the notice of non-existent record to the requesting tenant responsive to determining one of;

that the record does not exist and the record exists but is indicated as having been deleted by the tenant based on a value of a customization level of that record;

store the customized record in the cache memory and provide the customized record to the requesting tenant responsive to determining that the record exists in the data store associated with the tenant and is customized record for the tenant; and

store a system sentinel and the system level record in the cache store and provide the customized record to any requesting tenant responsive to determining that the record exists in the data store associated with the tenant and is system level record.

11. The system of claim 10, wherein the caching module is further configured to:

store a customization level attribute indicating customization status of the retrieved record in the cache memory as part of the entry associated with the record.

12. The system of claim 10, wherein the customization level attribute is stored in an attribute table associated with the requested record.

13. The system of claim 9, wherein the processor is further configured to execute a business application module associated with a Customer Relationship Management (CRM) system for communicating with the requesting tenant.

14. The system of claim 9, wherein the data store associated with the requesting tenant is one of an individual database assigned to a single tenant and a portion of a database assigned to a plurality of tenants.

15. The system of claim 9, wherein the caching module is further configured to enable a tenant to permit sharing of customized record with other tenants based on a record identifier and a tenant identifier for each tenant.

16. The system of claim 9, wherein the caching module is further configured to update the entry associated with the requested data in the cache memory based on at least one of:

expiration of a period, a tenant request, and notice of change from a data store associated with the tenant.

17. A computer-readable storage medium with instructions stored thereon for handling customizable data in a multi-tenant business application environment, the instructions comprising:

determining whether an entry associated with requested data is stored in a cache store in response to receiving a request for data from a tenant;

if the entry is stored and is a delete sentinel, providing a notice of non-existent data to the requesting tenant;

if the entry is stored and is a system sentinel, making the requested data available to a plurality of requesting tenants without retrieving the data from a tenant data store for each request; and

if the entry is stored and is the requested data that is customized for the tenant, making the customized data available only to the requesting tenant.

18. The computer-readable storage medium of claim 17, wherein the instructions further comprise:

if no entry associated with the requested data is stored in the cache store and the requested data is available from a data store associated with the tenant;

retrieving the data from the data store associated with the tenant;

determining a customization level of the retrieved data;

if the data is customized, providing the customized data only to the requesting tenant; and

if the data is non-customized, making the non-customized data available to any requesting tenant, wherein only one copy of the non-customized data is stored in the cache store.

19. The computer-readable storage medium of claim 18, wherein the instructions further comprise storing a system sentinel indicating a non-customized status of the retrieved data in the cache store.

20. The computer-readable storage medium of claim 17, wherein the tenant includes one of an organization and a member of an organization participating in a CRM system.