System, method and computer program product for using a database to access content stored outside of the database

• US 9,251,164 B2
• Filed: 02/28/2011
• Issued: 02/02/2016
• Est. Priority Date: 02/26/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Doshi, Kedar, Agrawal, Sonali, Wong, Simon, Bhatt, Chaitanya, Ghosh, Sandip, Baker, Gary, Macklem, Walter
• Primary Examiner(s): ADAMS, CHARLES D
• Application Number:
  US13/037,240
• Publication Number:
  US 20110213816A1
• Time in Patent Office: 1,800 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/122 using management policies backup systems G06F11/1446; file migration policies for HSM systems G06F16/185
• CPC Class Codes: G06F 16/13 File access structures, e.g. distributed indices arrangements of input from, or output to, record carriers G06F3/06
• CPC Class Codes: G06F 16/14 Details of searching files based on file metadata
• CPC Class Codes: G06F 16/1748 De-duplication implemented within the file system, e.g. based on file segments de-duplication techniques in storage systems for the management of data blocks G06F3/0641
• CPC Class Codes: G06F 16/176 Support for shared access to files; File sharing support
• CPC Class Codes: G06F 16/182 Distributed file systems

Abstract

In accordance with embodiments, there are provided mechanisms and methods for using a database to access content stored outside of the database. These mechanisms and methods for using a database to access content stored outside of the database can enable embodiments to provide a database system which can be used to access content when the content is incapable of being stored in the database system, or is otherwise not stored in the database system. The ability of embodiments to provide access to such data via the database system can improve the usability of the database system.

Claims

1. A computer program product, comprising a non-transitory computer usable medium having a computer readable program code embodied therein, the computer readable program code adapted to be executed to implement a method, the method comprising:

providing a multi-tenant database system that is shared by multiple tenants, wherein content of one tenant is kept logically separate from content of other tenants;

receiving content at the multi-tenant database system from one of the tenants of the multi-tenant database system for storage thereof in the multi-tenant database system, the received content being in a first format;

determining whether a database of the multi-tenant database system supports the first format of the received content;

in response to determining that the database supports the first format of the received content, storing the received content in the database;

in response to determining that the database does not support the first format of the received content;

determining whether a copy of the received content is stored in a file server of the multi-tenant database system that is separate from the database, and

(i) in response to determining that the copy of the received content is not stored in the file server;

storing the received content in the file server separate from the database,

storing, in the database separate from the file server, a first instance of metadata referencing a location of the stored content in the file server,

configuring a counter specific to the stored content to an initial value, wherein the counter is of a number of instances of metadata in the database referencing the location of the stored content in the file server, and

enabling access by the tenant to the stored content in the file server via the first instance of the metadata, and

(ii) in response to determining that the copy of the received content is stored in the file server;

storing, in the database separate from the file server, a second instance of metadata referencing the location of the stored content in the file server,

incrementing the counter specific to the stored content, and

enabling access by the tenant to the stored content in the file server via the second instance of the metadata,

receiving at the multi-tenant database system from the tenant a request that the stored content be converted from the first format to a second format different from the first format,

in response to receiving the request, converting the stored content in the file server from the first format to the second format and converting a field of the file server storing the stored content from being configured to store content of the first format to being configured to store content of the second format,

for each instance of the metadata in the database referencing the location of the stored content in the file server, setting a flag included in the metadata to indicate that a type of the stored content has been changed;

wherein the multi-tenant database system limits an amount of content allowed to be stored by each tenant in the multi-tenant database system to a maximum amount, and wherein content stored in the file server by a particular tenant and referenced by multiple instances of metadata is counted once against the maximum amount allowed to be stored by the particular tenant.

2. The computer program product of claim 1, wherein the received content includes a file.

3. The computer program product of claim 2, wherein the file includes an image file.

4. The computer program product of claim 1, wherein the stored content in one of the first format and the second format includes rich text.

5. The computer program product of claim 1, wherein the content is received using a graphical user interface used for configuring a webpage.

6. The computer program product of claim 1, wherein storing, in the database, the first instance of metadata referencing the location of the stored content in the file server includes storing an identifier of the location of the received content in a reference table of the database.

7. The computer program product of claim 6, wherein the identifier of the location of the stored content is stored in association with a content identifier.

8. The computer program product of claim 7, wherein the content identifier is stored in a field data table in association with a reference identifier.

9. The computer program product of claim 8, wherein the reference identifier is stored in a field of a record of an entity table, for referencing the stored content.

10. The computer program product of claim 9, wherein the entity table stores information associated with an entity including the stored content.

11. The computer program product of claim 10, wherein the entity includes a webpage.

12. The computer program product of claim 8, wherein the counter is stored in the reference table in association with the content identifier.

13. The computer program product of claim 12, further comprising updating the counter to reflect one less instance of metadata in the database in response to deletion of one of the instances of metadata in the database, and preventing a deletion of the stored content from the file server if the counter indicates that at least one of the instances of metadata is stored in the database.

14. The computer program product of claim 1, wherein accessing the stored content includes retrieving the stored content for inclusion in an entity provided to a user requesting the entity.

15. The computer program product of claim 1, wherein the receiving content is stored in the file server in response to a determination that the received content does not include malicious content.

16. The computer program product of claim 1, further comprising storing additional metadata associated with the stored content and retrieving or filtering the additional metadata using a query.

17. The computer program product of claim 1, further comprising:

storing the metadata referencing the location of the stored content in a first table of the database, where the metadata is stored in association with a first instance of a unique identifier of the stored content;

storing a second instance of the unique identifier of the stored content in association with a first instance of a reference identifier within a second table, where the second instance of the unique identifier stored in the second table points to the first instance of the unique identifier stored in the first table; and

storing a second instance of the reference identifier within a field of a record of a third table, where the second instance of the reference identifier stored in the third table points to the first instance of the reference identifier stored within the second table.

18. The computer program product of claim 17, further comprising storing a type of the stored content in the field of the record.

19. The computer program product of claim 17, wherein the stored content is accessed utilizing the second instance of the reference identifier within the field of the record.

20. The computer program product of claim 1, wherein metadata referencing the location of the stored content in the file server is stored in a field of a table of the database in which the stored content would otherwise be stored if supported by the database.

21. The computer program product of claim 1, wherein when the stored content stored in the file server by the particular tenant is referenced by other tenants using the multiple instances of metadata, then the stored content stored in the file server is only counted once against the maximum amount allowed to be stored by the particular tenant.

22. The computer program product of claim 1, further comprising:

after converting the stored content from the first format to the second format, receiving at the multi-tenant database system from the tenant a subsequent request that the stored content be converted back to the first format from the second format,

in response to receiving the subsequent request, converting the stored content in the file server from the second format to the first format and converting a field of the file server storing the stored content from being configured to store content of the first format to being configured to store content of the first format, and

for each instance of the metadata in the database referencing the location of the stored content in the file server and having the flag indicating that the type of the stored content has been changed, removing the flag responsive to converting the stored content in the file server from the second format to the first format.

23. The computer program product of claim 1, wherein the multi-tenant database system supports a bulk conversion of content in the file server, including:

receiving at the multi-tenant database system from the tenant a bulk conversion request to convert content in a specified field of the file server from the first format to the second format,

in response to receipt of the bulk conversion request, finding all data rows of the file server that have a non-null value for the specified field,

converting all of the content in the found data rows from being in the first format to being in the second format and converting the specified field of the file server from being configured to store content of the first format to being configured to store content of the second format,

for each instance of the metadata in the database referencing the location of the content in the file server, setting a flag included in the metadata to indicate that a type of the content has been changed.

24. A method, comprising:

providing a multi-tenant database system that is shared by multiple tenants, wherein content of one tenant is kept logically separate from content of other tenants;

receiving content at the multi-tenant database system from one of the tenants of the multi-tenant database system for storage thereof in the multi-tenant database system, the received content being in a first format;

determining whether a database of the multi-tenant database system supports the first format of the received content;

in response to determining that the database supports the first format of the received content, storing the received content in the database;

in response to determining that the database does not support the first format of the received content;

determining whether a copy of the received content is stored in a file server of the multi-tenant database system that is separate from the database, and

(i) in response to determining that the copy of the received content is not stored in the file server;

storing the received content in the file server separate from the database,

storing, in the database separate from the file server, a first instance of metadata referencing a location of the stored content in the file server,

configuring a counter specific to the stored content to an initial value, wherein the counter is of a number of instances of metadata in the database referencing the location of the stored content in the file server, and

enabling access by the tenant to the stored content in the file server via the first instance of the metadata, and

(ii) in response to determining that the copy of the received content is stored in the file server;

storing, in the database separate from the file server, a second instance of metadata referencing the location of the stored content in the file server,

incrementing the counter specific to the stored content, and

enabling access by the tenant to the stored content in the file server via the second instance of the metadata,

receiving at the multi-tenant database system from the tenant a request that the stored content be converted from the first format to a second format different from the first format,

in response to receiving the request, converting the stored content in the file server from the first format to the second format and converting a field of the file server storing the stored content from being configured to store content of the first format to being configured to store content of the second format,

for each instance of the metadata in the database referencing the location of the stored content in the file server, setting a flag included in the metadata to indicate that a type of the stored content has been changed;

wherein the multi-tenant database system limits an amount of content allowed to be stored by each tenant in the multi-tenant database system to a maximum amount, and wherein content stored in the file server by a particular tenant and referenced by multiple instances of metadata is counted once against the maximum amount allowed to be stored by the particular tenant.

25. An apparatus, comprising:

a processor; and

a memory storing instructions which when executed by the processor cause the processor to perform a method comprising;

providing a multi-tenant database system that is shared by multiple tenants, wherein content of one tenant is kept logically separate from content of other tenants;

receiving content at the multi-tenant database system from one of the tenants of the multi-tenant database system for storage thereof in the multi-tenant database system, the received content being in a first format;

determining whether a database of the multi-tenant database system supports the first format of the received content;

in response to determining that the database supports the first format of the received content, storing the received content in the database;

in response to determining that the database does not support the first format of the received content;

determining whether a copy of the received content is stored in a file server of the multi-tenant database system that is separate from the database, and

(i) in response to determining that the copy of the received content is not stored in the file server;

storing the received content in the file server separate from the database,

storing, in the database separate from the file server, a first instance of metadata referencing a location of the stored content in the file server,

configuring a counter specific to the stored content to an initial value, wherein the counter is of a number of instances of metadata in the database referencing the location of the stored content in the file server, and

enabling access by the tenant to the stored content in the file server via the first instance of the metadata, and

(ii) in response to determining that the copy of the received content is stored in the file server;

storing, in the database separate from the file server, a second instance of metadata referencing the location of the stored content in the file server,

incrementing the counter specific to the stored content, and

enabling access by the tenant to the stored content in the file server via the second instance of the metadata,

receiving at the multi-tenant database system from the tenant a request that the stored content be converted from the first format to a second format different from the first format,

in response to receiving the request, converting the stored content in the file server from the first format to the second format and converting a field of the file server storing the stored content from being configured to store content of the first format to being configured to store content of the second format,

for each instance of the metadata in the database referencing the location of the stored content in the file server, setting a flag included in the metadata to indicate that a type of the stored content has been changed;

wherein the multi-tenant database system limits an amount of content allowed to be stored by each tenant in the multi-tenant database system to a maximum amount, and wherein content stored in the file server by a particular tenant and referenced by multiple instances of metadata is counted once against the maximum amount allowed to be stored by the particular tenant.