Sharing information between tenants of a multi-tenant database

• US 9,292,534 B2
• Filed: 09/04/2014
• Issued: 03/22/2016
• Est. Priority Date: 06/04/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Kuruganti, Aditya S., Fell, Simon Z., Pasala, Jayaprakash, Sanikommu, Samatha, Doshi, Kedar, Lai, Sanjaya
• Primary Examiner(s): Fleurantin, Jean B
• Application Number:
  US14/477,802
• Publication Number:
  US 20150088855A1
• Time in Patent Office: 565 Days
• Field of Search: 707/608, 707/769, 707/770, 707/827
• US Class Current: 1/1
• CPC Class Codes: G06F 16/176 Support for shared access to files; File sharing support
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: G06F 16/40 of multimedia data, e.g. slideshows comprising image and additional audio data retrieval of still image data G06F16/50; retrieval of audio data G06F16/60; retrieval of video data G06F16/70
• CPC Class Codes: H04L 63/102 Entity profiles
• CPC Class Codes: H04L 67/06 specially adapted for file transfer, e.g. file transfer protocol [FTP]

Abstract

In a method, system, and computer-readable medium having instructions for sharing information between tenants of a multi-tenant database, information is received on a connection between a first tenant of a multi-tenant database and a second tenant and the connection has information on a scope of data from the first tenant shared with the second tenant, data is allowed for a record of the first tenant to be accessible to the second tenant in accordance with the connection, information is received on a file related to the record of the first tenant, and data is allowed from the file to be accessible to the second tenant in accordance with the connection.

Claims

1. A computer program product embodied on a non-transitory computer readable storage medium, the computer program product including code adapted to be executed by a computer to perform a method comprising:

receiving, by a system from a first user, data of the first user for being stored by the system;

storing, by the system, the data of the first user;

receiving, by the system from the first user, a file of the first user and an indication that the file of the first user is related to the data of the first user;

storing, by the system, the file of the first user and the indication that the file of the first user is related to the data of the first user;

receiving, by the system from the first user, information on a connection between the first user and a second user, the information on the connection indicating that the data of the first user stored by the system is shared with the second user;

notifying the second user of the connection, by the system;

after the second user accepts the connection, storing, by the system, the information on the connection between the first user and the second user;

based on the stored information on the connection, allowing, by the system, the second user to access the data of the first user stored within the system including;

receiving, by the system, a first request from the second user for at least a portion of the data of the first user, and

in response to receipt of the first request and based on the stored information on the connection, generating a first query to retrieve the at least a portion of the data of the first user and providing to the second user the at least a portion of the data of the first user retrieved using the first query; and

based on the stored information on the connection and the stored indication that the file of the first user is related to the data of the first user, allowing, by the system, the second user to access the file of the first user stored within the system including;

receiving, by the system, a second request from the second user for the file of the first user, and

in response to receipt of the second request and based on the stored information on the connection and the stored indication that the file of the first user is related to the data of the first user, generating a second query to retrieve the file of the first user and providing to the second user the file of the first user retrieved using the second query.

2. The computer program product of claim 1, wherein the first user is a subscriber to the system.

3. The computer program product of claim 1, wherein the second user is a subscriber to the system.

4. The computer program product of claim 1, wherein the system includes a database system.

5. The computer program product of claim 4, wherein the data of the first user, the file of the first user, and the indication that the file of the first user is related to the data of the first user are stored within the database system.

6. The computer program product of claim 4, wherein the database system is shared by multiple users that are subscribers to the system, and wherein data of the multiple users is stored logically separate within the database system.

7. The computer program product of claim 1, wherein the second user is notified of the connection by an email.

8. The computer program product of claim 7, wherein the first user initiates, through the system, the second user being notified of the connection by email.

9. The computer program product of claim 1, wherein the second user is required to accept the connection prior to being allowed to access the data of the first user stored within the system.

10. The computer program product of claim 1, wherein the file is received as a file attachment.

11. The computer program product of claim 1, wherein the file is received using a name of the file and a path to the file.

12. A method, comprising:

receiving, by a processing device of a computer system from a first user, data of the first user for being stored by the system;

storing, by the processing device of the computer system, the data of the first user;

receiving, by the processing device of the computer system from the first user, a file of the first user and an indication that the file of the first user is related to the data of the first user;

storing, by the processing device of the computer system, the file of the first user and the indication that the file of the first user is related to the data of the first user;

receiving, by the processing device of the computer system from the first user, information on a connection between the first user and a second user, the information on the connection indicating that the data of the first user stored by the system is shared with the second user;

notifying the second user of the connection, by the processing device of the computer system;

after the second user accepts the connection, storing, by the processing device of the computer system, the information on the connection between the first user and the second user;

based on the stored information on the connection, allowing, by the processing device of the computer system, the second user to access the data of the first user stored within the system including;

receiving, by the processing device of the computer system, a first request from the second user for at least a portion of the data of the first user, and

in response to receipt of the first request and based on the stored information on the connection, generating a first query to retrieve the at least a portion of the data of the first user and providing to the second user the at least a portion of the data of the first user retrieved using the first query; and

based on the stored information on the connection and the stored indication that the file of the first user is related to the data of the first user, allowing, by the processing device of the computer system, the second user to access the file of the first user stored within the system including;

receiving, by the processing device of the computer system, a second request from the second user for the file of the first user, and

in response to receipt of the second request and based on the stored information on the connection and the stored indication that the file of the first user is related to the data of the first user, generating a second query to retrieve the file of the first user and providing to the second user the file of the first user retrieved using the second query.

13. An apparatus, comprising:

a processor of a system for;

receiving, by the system from a first user, data of the first user for being stored by the system;

storing, by the system, the data of the first user;

receiving, by the system from the first user, a file of the first user and an indication that the file of the first user is related to the data of the first user;

storing, by the system, the file of the first user and the indication that the file of the first user is related to the data of the first user;

receiving, by the system from the first user, information on a connection between the first user and a second user, the information on the connection indicating that the data of the first user stored by the system is shared with the second user;

notifying the second user of the connection, by the system;

after the second user accepts the connection, storing, by the system, the information on the connection between the first user and the second user;

based on the stored information on the connection, allowing, by the system, the second user to access the data of the first user stored within the system including;

receiving, by the system, a first request from the second user for at least a portion of the data of the first user, and

in response to receipt of the first request and based on the stored information on the connection, generating a first query to retrieve the at least a portion of the data of the first user and providing to the second user the at least a portion of the data of the first user retrieved using the first query; and

based on the stored information on the connection and the stored indication that the file of the first user is related to the data of the first user, allowing, by the system, the second user to access the file of the first user stored within the system including;

receiving, by the system, a second request from the second user for the file of the first user, and in response to receipt of the second request and based on the stored information on the connection and the stored indication that the file of the first user is related to the data of the first user, generating a second query to retrieve the file of the first user and providing to the second user the file of the first user retrieved using the second query.