IP Library Granted Patent US 11,410,087
Granted Patent B2
US 11,410,087 · App. 16/504,578 · Granted Aug 9, 2022

Dynamic query response with metadata

Inventors: Derek Brian Hatchard (New Maryland, CA); Jordan Patrick Lutes (New Maryland, CA); Michael Gordon Luff (New Maryland, CA)
Assignee: Salesforce, Inc.
G06Q10/00G06Q30/02G06Q30/0201G06Q50/01
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,410,087
App. No.
16/504,578
Granted
Aug 9, 2022
Kind
B2
Abstract

Metadata and for posts originating from different social media sources and the posts themselves may be collected. A query specifying search criteria for the posts and filter criteria related to the metadata may be submitted to the system disclosed herein. The system may allow a client or tenant of the system to filter and search the metadata stored therein. The system may provide the posts in response to the query and permit a client or tenant to rapidly switch between social media sources and corresponding metadata types.

Claims (41)

1. A system, comprising:

a memory and a processor communicatively coupled to the memory, the processor configured to:

assign identification numbers for posts stored in a first database;

associate the identification numbers with metadata stored in a second database, the metadata associated with corresponding posts stored in the first database;

receive a request for posts that meet search criteria for media sources and filter criteria that specify a subset of the metadata;

retrieve, from the first database, identification numbers of posts that meet the search criteria;

receive, from the second database, metadata that are associated with the identification numbers of the posts that meet the search criteria and that meet the filter criteria; and

provide, in response to the request, posts that meet the search criteria and the filter criteria.

2. The system of claim 1 , wherein the processor is further configured to obtain, for the first database, the posts from a social media source.

3. The system of claim 1 , wherein the processor is further configured to obtain, for the second database, the metadata from a social media source.

4. The system of claim 1 , wherein the processor is further configured to associate the metadata with the posts.

5. The system of claim 1 , wherein the processor is further configured to deserialize the metadata.

6. The system of claim 1 , wherein the second database is separate from the first database.

7. The system of claim 1 , wherein the system further comprises at least one of the first database or the second database.

8. The system of claim 1 , wherein the processor is configured to receive the request for the posts that meet the search criteria and the filter criteria by producing a user interface configured to allow a user to view types of the metadata and to select the subset of the metadata.

9. The system of claim 1 , wherein the system comprises a multi-tenant system.

10. A method, comprising:

assigning, by a processor, identification numbers for posts stored in a first database;

associating, by the processor, the identification numbers with metadata stored in a second database, the metadata associated with corresponding posts stored in the first database;

receiving, by the processor, a request for posts that meet search criteria for media sources and filter criteria that specify a subset of the metadata;

retrieving, by the processor and from the first database, identification numbers of posts that meet the search criteria;

receiving, by the processor and from the second database, metadata that are associated with the identification numbers of posts that meet the search criteria and that meet the filter criteria; and

providing, by the processor and in response to the request, posts that meet the search criteria and the filter criteria.

11. The method of claim 10 , further comprising obtaining, for the first database, the posts from a social media source.

12. The method of claim 11 , wherein the obtaining the posts comprises crawling a web network to obtain the posts.

13. The method of claim 10 , further comprising obtaining, for the second database, the metadata from a social media source.

14. The method of claim 13 , wherein the obtaining the metadata comprises crawling a web network to obtain the posts.

15. The method of claim 10 , further comprising deserializing the metadata.

16. The method of claim 10 , wherein the metadata comprise at least one of information about entities that produced the posts, times of production of the posts, languages of the posts, or uniform resource locators associated with the posts.

17. The method of claim 16 , wherein the information about the entities that produced the posts comprises at least one of identities of the entities, geographical information about the entities, or demographical information about the entities.

18. The method of claim 10 , further comprising receiving, by processor and from a client device, information about an entity that produced the request, wherein the providing the posts that meet the search criteria and the filter criteria comprises providing, based on the information about the entity that produced the request, the posts that meet the search criteria and the filter criteria.

19. The method of claim 18 , wherein:

the retrieving the identification numbers of the posts that meet the search criteria comprises retrieving, based on the information about the entity that produced the request, the identification numbers of the posts that meet the search criteria; and

the receiving the metadata that are associated with the identification numbers of posts that meet the search criteria and that meet the filter criteria comprises receiving, based on the information about the entity that produced the request, the metadata that are associated with the identification numbers of posts that meet the search criteria and that meet the filter criteria.

20. A non-transitory computer-readable medium storing computer code, the computer code including instructions to cause the processor to:

assign identification numbers for posts stored in a first database;

associate the identification numbers with metadata stored in a second database, the metadata associated with corresponding posts stored in the first database;

receive a request for posts that meet search criteria for media sources and filter criteria that specify a subset of the metadata;

retrieve, from the first database, identification numbers of posts that meet the search criteria;

receive, from the second database, metadata that are associated with the identification numbers of posts that meet the search criteria and that meet the filter criteria; and

provide, in response to the request, posts that meet the search criteria and the filter criteria.

Assignments (2)
CHANGE OF NAME Recorded Dec 18, 2024
From: SALESFORCE.COM, INC.
To: SALESFORCE, INC.
Reel/Frame 069717/0427 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 8, 2019
From: HATCHARD, DEREK BRIAN; LUTES, JORDAN PATRICK; LUFF, MICHAEL GORDON
To: SALESFORCE.COM, INC.
Reel/Frame 049686/0691 →
Continuity (3)
Continuation 14505863 · Oct 3, 2014
Provisional Application 61893582 · Oct 21, 2013
Related Publication 20190332972A1 · Oct 31, 2019