Systems and methods for providing access to external content objects

• US 9,747,388 B2
• Filed: 02/25/2014
• Issued: 08/29/2017
• Est. Priority Date: 08/31/2012
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Micucci, Michael, Mohapatra, Saurav, Goldbrenner, David, Maquaire, Nicolas, Kubaski, Laurent, Jean-Leconte, Raphael
• Primary Examiner(s): Hirl, Joseph P
• Assistant Examiner(s): GYORFI, THOMAS A
• Application Number:
  US14/189,702
• Publication Number:
  US 20140181013A1
• Time in Patent Office: 1,281 Days
• CPC Class Codes: G06F 16/90 Details of database functions independent of the retrieved data types
• CPC Class Codes: G06F 16/9536 Search customisation based on social or collaborative filtering
• CPC Class Codes: H04L 63/029 Firewall traversal, e.g. tunnelling or, creating pinholes
• CPC Class Codes: H04L 63/08 for authentication of entities cryptographic mechanisms or cryptographic arrangements for entity authentication H04L9/32
• CPC Class Codes: H04L 63/168 above the transport layer

Abstract

Disclosed are methods, apparatus, systems, and computer readable storage media for providing access in an on-demand database service to a content object stored in an external content management data source. Information data identifying a content object stored in an external content management data source can be received and communicated through one or more middleware components. The one or more middleware components can serve as a content hub to establish access with the content object and retrieve data regarding the content object. The data regarding the content object can be stored in a persistent object, which can represent the content object in a social layer of the on-demand database service.

Claims

1. A method comprising:

providing, through a database system, one or more middleware components in communication with a plurality of content management data sources external to the database system, the content management data sources being identifiable in a list in a user interface, each of the content management data sources in the list having an associated selection enabling authorization of the content management data source, each of at least a subset of authorized content management data sources in the list having an associated selection enabling customization of search settings for searching content of the content management data source;

processing information retrieved from the content management data sources using the one or more middleware components, the information identifying a plurality of content objects stored in the content management data sources;

generating and storing a plurality of persistent objects to represent the identified content objects in one or more databases of the database system;

receiving a user-submitted search query;

causing a search according to the search query to be performed on;

a plurality of native files stored in one or more databases of the database system, and

the persistent objects stored in one or more databases of the database system;

receiving a search result identifying at least a first one of the persistent objects as satisfying the search query, the first persistent object representing a first one of the identified content objects; and

enabling user composition and sharing of a post comprising a first selectable component identifying and graphically representing the first persistent object, the post shared as a feed item of a social network feed to be displayed in user interfaces of user devices of users of a social networking system implemented using the database system, the feed item configured to provide selection of the first selectable component for access to functionality associated with the first persistent object and associated with the first content object, the feed item further configured to be commented on by the users of the social networking system.

2. The method of claim 1, wherein the first persistent object includes a content object identifier including one or more of:

a title, a source, a Uniform Resource Locator (URL), or a unique identification (ID) of the first content object.

3. The method of claim 2, wherein establishing access with the first content object includes establishing access with the first content object via the content object identifier.

4. The method of claim 1, wherein the first selectable component includes a URL or a content object ID to the first content object.

5. The method of claim 1, wherein the first selectable component includes a copy of the first content object.

6. The method of claim 1, wherein a social layer includes the list, the social network feed, a group, and a record.

7. The method of claim 6, wherein the social layer further includes the first selectable component and a second selectable component for a content file natively stored in the one or more databases of the database system.

8. The method of claim 6, wherein the social layer further includes the first selectable component and a plurality of second selectable components for a subset of the persistent objects.

9. The method of claim 6, further comprising:

synchronizing the one or more databases of the database system with a storage medium of a display device, wherein the storage medium includes a further plurality of native files; and

updating the one or more databases of the database system to reflect inclusion of the further native files.

10. The method of claim 1, wherein the first persistent object has a data structure including one or more data fields stored in a table, and the first content object includes metadata corresponding to the one or more data fields.

11. The method of claim 1, wherein the one or more middleware components include one or more software components and one or more application programming interface (API) components, and wherein the one or more middleware components are configured to instantiate connection between the database system and the content management data sources.

12. The method of claim 1, wherein establishing access to the first content object includes authorizing communication with a first content management data source.

13. The method of claim 1, wherein the functionality associated with the first persistent object is based on a location of a first content management data source.

14. A system comprising:

a database system implemented using a server system, the database system configurable to cause;

providing one or more middleware components in communication with a plurality of content management data sources external to the database system, the content management data sources being identifiable in a list in a user interface, each of the content management data sources in the list having an associated selection enabling authorization of the content management data source, each of at least a subset of authorized content management data sources in the list having an associated selection enabling customization of search settings for searching content of the content management data source;

processing information retrieved from the content management data sources using the one or more middleware components, the information identifying a plurality of content objects stored in the content management data sources;

generating and storing a plurality of persistent objects to represent the identified content objects in one or more databases of the database system;

processing a user-submitted search query;

performing a search according to the search query on;

a plurality of native files stored in one or more databases of the database system, and

the persistent objects stored in one or more databases of the database system;

processing a search result identifying at least a first one of the persistent objects as satisfying the search query, the first persistent object representing a first one of the identified content objects; and

enabling user composition and sharing of a post comprising a first selectable component identifying and graphically representing the first persistent object, the post shared as a feed item of a social network feed to be displayed in user interfaces of user devices of users of a social networking system implemented using the database system, the feed item configured to provide selection of the first selectable component for access to functionality associated with the first persistent object and associated with the first content object, the feed item further configured to be commented on by the users of the social networking system.

15. The system of claim 14, wherein the first persistent object includes a content object identifier including one or more of:

a title, a source, a Uniform Resource Locator (URL), or a unique identification (ID) of the first content object.

16. The system of claim 14, wherein

a social layer includes the list, the social network feed, a group, and a record.

17. The system of claim 14, wherein the one or more middleware components include one or more software components, one or more user interface components, and one or more application programming interface (API) components, and wherein the one or more middleware components are configured to instantiate connection between the database system and the content management data sources.

18. A computer program product comprising computer-readable program code to be executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code comprising instructions configurable to cause:

providing one or more middleware components in communication with a plurality of content management data sources external to a database system, the content management data sources being identifiable in a list in a user interface, each of the content management data sources in the list having an associated selection enabling authorization of the content management data source, each of at least a subset of authorized content management data sources in the list having an associated selection enabling customization of search settings for searching content of the content management data source;

processing information retrieved from the content management data sources using the one or more middleware components, the information identifying a plurality of content objects stored in the content management data sources;

generating and storing a plurality of persistent objects to represent the identified content objects in one or more databases of the database system;

processing a user-submitted search query;

performing a search according to the search query on;

a plurality of native files stored in one or more databases of the database system, and

the persistent objects stored in one or more databases of the database system;

processing a search result identifying at least a first one of the persistent objects as satisfying the search query, the first persistent object representing a first one of the identified content objects; and

enabling user composition and sharing of a post comprising a first selectable component identifying and graphically representing the first persistent object, the post shared as a feed item of a social network feed to be displayed in user interfaces of user devices of users of a social networking system implemented using the database system, the feed item configured to provide selection of the first selectable component for access to functionality associated with the first persistent object and associated with the first content object, the feed item further configured to be commented on by the users of the social networking system.

19. The computer program product of claim 18, wherein a social layer includes the list, the social network feed, a group, and a record.