Filtering posts

• US 9,037,577 B1
• Filed: 12/21/2012
• Issued: 05/19/2015
• Est. Priority Date: 06/19/2012
• Status: Active Grant

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Saylor, Michael J., Vazquez, Hector, Gardner, Richard, Zhou, Xiaodong
• Primary Examiner(s): Beausoliel, Jr., Robert
• Assistant Examiner(s): Pham, Michael
• Application Number:
  US13/723,427
• Time in Patent Office: 879 Days
• Field of Search: None
• US Class Current: 707/725
• CPC Class Codes: G06F 16/2477 Temporal data queries
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06Q 50/01 Social networking

Abstract

Methods, systems, and apparatus, including computer programs encoded on computer storage media, for filtering posts. One of the methods includes filtering a set of pages that are maintained in a social networking platform and in which a user has expressed interest based on one or more user-identified categories to identify a subset of the pages that are associated with the one or more identified categories. The method includes identifying posts in a data store associated with the pages in the subset. The method includes identifying a trending post from among the identified posts based on a measure of popularity of the identified posts. The method also includes sending data to a user device to cause the user device to display at least the trending post and some of the other identified posts with the posts ordered in the display with the trending post presented first and additional posts ordered chronologically.

Claims

1. A computer implemented method comprising:

filtering a set of pages that are maintained in a social networking platform and in which a user has expressed interest based on one or more user-identified categories to identify a subset of the pages that are associated with the one or more identified categories;

identifying posts in a data store associated with the pages in the subset;

identifying a trending post from among the identified posts based on a measure of popularity of the identified posts;

sending data to a user device to cause the user device to display at least the trending post and some additional other identified posts from among the identified posts with the trending posts and the additional other identified posts ordered in the display with the trending post presented first and the additional other posts ordered chronologically;

determining to extract, from the electronic social networking platform, new posts for a page in the subset of pages based on a time of filtering the set of pages and a time of previous extraction of posts from the page; and

storing the extracted new posts for the page in the data store;

wherein determining to extract new posts for the page includes determining that a time lapse between the time of filtering to a time of a previous extraction of posts for the page is greater than a threshold.

2. The method of claim 1, wherein identifying posts in the data store associated with the pages in the subset includes identifying posts in the data store associated with the pages in the subset before storing the extracted new posts in the data store.

3. The method of claim 1, wherein identifying the trending post comprises:

calculating a score for each of multiple posts among the identified posts based on a count of users who have expressed interest in the post, a count of comments the post has received, and an age of the post.

4. The method of claim 3, wherein calculating the score includes calculating a sum of twice the count of comments the post has received and the count of users who have expressed interest in the post, and dividing that sum by the age of the post.

5. The method of claim 3, wherein the age of the post is determined in hours.

6. The method of claim 1, wherein filtering the set of pages to identify the subset of pages includes:

identifying at least one page in which the user has expressed interest but that the user had previously indicated to exclude; and

excluding the at least one page from the subset.

7. The method of claim 1, further comprising identifying a time period;

wherein identifying posts in the data store comprises identifying posts that occurred within the time period.

8. The method of claim 1, further comprising:

receiving a request to display posts associated with a second category different from the one or more categories;

filtering the set of pages to identify a second subset of the pages that are associated with the second category;

identifying second posts in the data store associated with the pages in the second subset;

identifying a second trending post from among the identified second posts based on a measure of popularity of the identified second posts; and

sending second data to the user device to cause the user device to display at least the second trending post and some additional other second posts from among the identified second posts with the trending post and the additional other second posts ordered in the display with the second trending post presented first and the additional other second posts ordered chronologically.

9. The method of claim 1, wherein the data store is a cached data store.

10. A non-transitory computer storage device encoded with computer program instructions that when executed by one or more computers cause the one or more computers to perform operations comprising:

filtering a set of pages that are maintained in a social networking platform and in which a user has expressed interest based on one or more user-identified categories to identify a subset of the pages that are associated with the one or more identified categories;

identifying posts in a data store associated with the pages in the subset;

identifying a trending post from among the identified posts based on a measure of popularity of the identified posts;

sending data to a user device to cause the user device to display at least the trending post and some additional other identified posts from among the identified posts with the trending post and the additional other identified posts ordered in the display with the trending post presented first and the additional other posts ordered chronologically;

determining to extract, from the electronic social networking platform, new posts for a page in the subset of pages based on a time of filtering the set of pages and a time of previous extraction of posts from the page; and

storing the extracted new posts for the page in the data store;

wherein determining to extract new posts for the page includes determining that a time lapse between the time of filtering to a time of a previous extraction of posts for the page is greater than a threshold.

11. The non-transitory storage device of claim 10, wherein identifying the trending post comprises:

calculating a score for each of multiple posts among the identified posts based on a count of users who have expressed interest in the post, a count of comments the post has received, and an age of the post, including calculating a sum of twice the count of comments the post has received and the count of users who have expressed interest in the post, and dividing that sum by the age of the post.

12. The non-transitory storage device of claim 10, wherein the instructions that when executed by one or more computers further cause the one or more computers to perform operations comprising:

receiving a request to display posts associated with a second category different from the one or more categories;

filtering the set of pages to identify a second subset of the pages that are associated with the second category;

identifying second posts in the data store associated with the pages in the second subset;

identifying a second trending post from among the identified second posts based on a measure of popularity of the identified second posts; and

sending second data to the user device to cause the user device to display at least the second trending post and some additional other second posts from among the identified second posts with the trending post and the additional other second posts ordered in the display with the second trending post presented first and the additional other second posts ordered chronologically.

13. A system comprising:

one or more computers and one or more storage devices storing instructions that are operable, when executed by the one or more computers, to cause the one or more computers to perform operations comprising;

filtering a set of pages that are maintained in a social networking platform and in which a user has expressed interest based on one or more user-identified categories to identify a subset of the pages that are associated with the one or more identified categories;

identifying posts in a data store associated with the pages in the subset;

identifying a trending post from among the identified posts based on a measure of popularity of the identified posts;

sending data to a user device to cause the user device to display at least the trending post and some additional other identified posts from among the identified posts with the trending post and the additional other identified posts ordered in the display with the trending post presented first and the additional other posts ordered chronologically;

determining to extract, from the electronic social networking platform, new posts for a page in the subset of pages based on a time of filtering the set of pages and a time of previous extraction of posts from the page; and

storing the extracted new posts for the page in the data store;

wherein determining to extract new posts for the page includes determining that a time lapse between the time of filtering to a time of a previous extraction of posts for the page is greater than a threshold.

14. The system of claim 13, wherein identifying the trending post comprises:

calculating a score for each of multiple posts among the identified posts based on a count of users who have expressed interest in the post, a count of comments the post has received, and an age of the post.

15. The system of claim 14, wherein calculating the score includes calculating a sum of twice the count of comments the post has received and the count of users who have expressed interest in the post, and dividing that sum by the age of the post.

16. The system of claim 13, wherein the instructions that when executed by one or more computers further cause the one or more computers to perform operations comprising:

receiving a request to display posts associated with a second category different from the one or more categories;

filtering the set of pages to identify a second subset of the pages that are associated with the second category;

identifying second posts in the data store associated with the pages in the second subset;

identifying a second trending post from among the identified second posts based on a measure of popularity of the identified second posts; and

sending second data to the user device to cause the user device to display at least the second trending post and some additional other second posts from among the identified second posts with the trending post and the additional other second posts ordered in the display with the second trending post presented first and the additional other second posts ordered chronologically.