Methods and systems for caching data shared between organizations in a multi-tenant database system
First Claim
Patent Images
1. A method of sharing data in a multi-tenant database system, comprising:
- determining at a host system, data that needs to be transferred between a first tenant'"'"'s portion of the multi-tenant database and a second tenant'"'"'s portion of the multi-tenant database, the host system including one or more machines having a processor system with at least one or more processors and a memory system that stores the multi-tenant database, wherein the first tenant'"'"'s portion of the multi-tenant database is isolated from the second tenant'"'"'s portion of the multi-tenant database;
reading metadata associated with the data from a cache, the metadata already being in the cache as a result of a prior transfer of the data, the metadata being stored in the cache for a finite predetermined period of time;
determining whether the finite predetermined period of time has expired, and when the finite predetermined period of time has not expired, determining whether changes have occurred that affect the metadata associated with the data, when the changes have occurred, fetching new metadata and storing the new metadata in cache in place of the metadata that was previously stored in cache, wherein the finite predetermined period of time is 15 minutes;
transferring the determined data from the first tenant'"'"'s portion of the multi-tenant database to the second tenant'"'"'s portion of the multi-tenant database system based on the metadata, the metadata defining how to transfer the data between the first tenant'"'"'s portion of the multi-tenant database and the second tenant'"'"'s portion of the multi-tenant database.
1 Assignment
0 Petitions
Accused Products
Abstract
Mechanisms and methods for sharing database content between tenants in a multi-tenant database system are provided. The ability to temporarily store metadata related to the shared data for subsequent use optimizes the data transfer process for multiple data transfers. In an embodiment, the metadata is stored for a pre-determined period of time and fetched again after the period elapses if required. The metadata may be erased from temporary storage if an administrator updates the shared data.
-
Citations
13 Claims
-
1. A method of sharing data in a multi-tenant database system, comprising:
-
determining at a host system, data that needs to be transferred between a first tenant'"'"'s portion of the multi-tenant database and a second tenant'"'"'s portion of the multi-tenant database, the host system including one or more machines having a processor system with at least one or more processors and a memory system that stores the multi-tenant database, wherein the first tenant'"'"'s portion of the multi-tenant database is isolated from the second tenant'"'"'s portion of the multi-tenant database; reading metadata associated with the data from a cache, the metadata already being in the cache as a result of a prior transfer of the data, the metadata being stored in the cache for a finite predetermined period of time; determining whether the finite predetermined period of time has expired, and when the finite predetermined period of time has not expired, determining whether changes have occurred that affect the metadata associated with the data, when the changes have occurred, fetching new metadata and storing the new metadata in cache in place of the metadata that was previously stored in cache, wherein the finite predetermined period of time is 15 minutes; transferring the determined data from the first tenant'"'"'s portion of the multi-tenant database to the second tenant'"'"'s portion of the multi-tenant database system based on the metadata, the metadata defining how to transfer the data between the first tenant'"'"'s portion of the multi-tenant database and the second tenant'"'"'s portion of the multi-tenant database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A non-transitory machine-readable medium carrying one or more sequences of instructions for implementing a method for providing an interface for object relationships, the method comprising:
-
determining at a host system, data that needs to be transferred between a first tenant'"'"'s portion of the multi-tenant database and a second tenant'"'"'s portion of the multi-tenant database, the host system including one or more machines having a processor system with at least one or more processors and a memory system that stores the multi-tenant database, wherein the first tenant'"'"'s portion of the multi-tenant database is isolated from the second tenant'"'"'s portion of the multi-tenant database; reading metadata associated with the data from a cache, the metadata already being in the cache as a result of a prior transfer of the data, the metadata being stored in the cache for a finite predetermined period of time; determining whether the finite predetermined period of time has expired, and when the finite predetermined period of time has not expired, determining whether changes have occurred that affect the metadata associated with the data, when the changes have occurred, fetching new metadata and storing the new metadata in cache in place of the metadata that was previously stored in cache, wherein the finite predetermined period of time is 15 minutes; and transferring the determined data from the first tenant'"'"'s portion of the multi-tenant database to the second tenant'"'"'s portion of the multi-tenant database system based on the metadata, the metadata defining how to transfer the data between the first tenant'"'"'s portion of the multi-tenant database and the second tenant'"'"'s portion of the multi-tenant database.
-
Specification