Explore query caching
Assigneesalesforce.com, inc.
InventorsGregg Lawton, Derek Brian Hatchard, Bruce Hamilton, Chris Myer
Life of this patent
Estimating the term…
Abstract
Provided are technical solutions for preparing and using a cache of social media post data. In an example, a database of social media posts is queried for matching posts and respective metadata for each matching post. Index item data describing one or more respective attributes of each matching post is gathered. For each of the matching posts, the respective index item data is combined with the respective metadata to form combined data. The matching posts and the combined data for each matching post are stored in the cache of social media post data. The cache can be indexed. The cache index can be subsequently queried to provide, for further analysis, social media data which matches specific attributes.
Claims21
A method for preparing a cache of social media post data, the method comprising:
- receiving initial query terms;
- searching, using the initial query terms, a database of social media posts for matching posts and respective metadata for each of the matching posts, wherein the searching is performed using a processing device;
- gathering respective index item data describing one or more respective attributes of each matching post, the index item data being at least one from the group consisting of:
- a media type, a media provider, a language in which the respective matching post is written, a region of origin of the respective matching post, a sentiment of the respective matching post, an author of the respective matching post, and a date the respective matching post was published;
- combining, for each of the matching posts, the respective index item data with the respective metadata to form combined data;
- storing, in a cache, the matching posts and the combined data for each matching post to provide the cache of social media post data;
- preparing a cache index by indexing the cache;
- analyzing the social media post data stored in the cache based on at least a media type and a sentiment;
- and
- displaying results from analyzing the social media post data.
A system for preparing a cache of social media post data, the system comprising:
- a processor;
- and
- a memory coupled to the processor and storing instructions configured to cause the processor to:
- initiate receiving initial query terms;
- initiate searching, using the initial query terms, a database of social media posts for matching posts and respective metadata for each of the matching posts, wherein the searching is performed using a processing device;
- initiate gathering respective index item data describing one or more respective attributes of each matching post, the index item data being at least one from the group consisting of:
- a media type, a media provider, a language in which the respective matching post is written, a region of origin of the respective matching post, a sentiment of the respective matching post, an author of the respective matching post, and a date the respective matching post was published;
- initiate combining, for each of the matching posts, the respective index item data with the respective metadata to form combined data;
- initiate storing, in a cache, the matching posts and the combined data for each matching post to provide the cache of social media post data;
- initiate preparing a cache index by indexing the cache;
- analyze the social media post data stored in the cache based on at least a media type and a sentiment;
- and
- display results from analyzing the social media post data.
A non-transitory computer-readable storage medium comprising instructions stored thereon which are configured to cause a processor in a host organization to perform operations, wherein the operations include:
- initiating receiving initial query terms;
- initiating searching, using the initial query terms, a database of social media posts for matching posts and respective metadata for each of the matching posts, wherein the searching is performed using a processing device;
- initiating gathering respective index item data describing one or more respective attributes of each matching post, the index item data being at least one from the group consisting of:
- a media type, a media provider, a language in which the respective matching post is written, a region of origin of the respective matching post, a sentiment of the respective matching post, an author of the respective matching post, and a date the respective matching post was published;
- initiating combining, for each of the matching posts, the respective index item data with the respective metadata to form combined data;
- initiating storing, in a cache, the matching posts and the combined data for each matching post to provide the cache of social media post data;
- initiating preparing a cache index by indexing the cache;
- analyzing the social media post data stored in the cache based on at least a media type and a sentiment;
- and
- displaying results from analyzing the social media post data.
Dependencies are inferred from the claim text.