Trend Data Aggregation

• US 20150220938A1
• Filed: 01/31/2014
• Published: 08/06/2015
• Est. Priority Date: 01/31/2014
• Status: Active Grant

• Current Assignee: Walmart Apollo, LLC (WalMart Inc.)
• Original Assignee: Wal-Mart Stores Texas LLC (WalMart Inc.)
• Inventors: Tuteja, Bhupesh, Khanchi, Amit, Kamble, Abhay Maruti
• Granted Patent: US 10,332,127 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data

Abstract

Systems and methods are provided for collecting, sorting, and reporting data sets representing transactions, product reviews, social media product mentions, or the like. According to embodiments of the present disclosure, a trend aggregation system includes a backend data collector, a trend database, and a trend server. Data may be gathered from heterogeneous sources such as transaction records, product reviews posted by consumers on web sites, and product mentions posted on social network platforms. The data may be sorted and stored in a way to provide recall of trend data segments filtered according to selected parameters.

Claims

1. A computer-implemented method for providing trending information, comprising:

at a backend data collector, receiving a dataset regarding a trend action, the dataset comprising a product identifier, a category identifier, and a trend type action;

at the backend data collector, sorting the dataset to populate a product column in a category row of a trend database, wherein;

a key for the category row comprises the category identifier;

a value for the product column comprises the product identifier;

the category identifier represents a product category; and

the product identifier represents a product within the product category;

at the backend data collector, sorting the dataset to populate a category column in a trend type row of the trend database, wherein;

a key for the trend type row comprises the trend type action and

a value for the category column comprises the category identifier;

receiving a query for one or more trending products;

at the trend database, searching the category column, thereby identifying the product category;

at the trend database, searching the product column, thereby identifying the product;

from a trend server, transmitting a set of trending products, the set comprising the product identifier.

2. The method of claim 1, wherein the dataset further comprises a timestamp.

3. The method of claim 2, wherein:

a key for the product column comprises the timestamp; and

a key for the category column comprises the timestamp.

4. The method of claim 1, wherein:

a key for the product column comprises a counter value;

a key for the category column comprises the counter value; and

the method further comprises;

initializing the product column and setting the counter value to one and

initializing the category column and setting the counter value to one.

5. The method of claim 1, wherein the trend action comprises one of the group consisting of:

best-rated products, newly pinned products, best seller products, recently reviewed products, just sold products, and products mentioned in other social platforms.

6. The method of claim 1, wherein:

a key for the product column comprises a concatenation of a timestamp and a counter value;

a key for the category column matches the key for the product column;

the counter value corresponds to a count of occurrences of products in the dataset during a selected time interval;

the timestamp reflects a start of the time interval.

7. A system for providing product trending information, comprising:

a backend data collector;

a trend database comprising;

a trend type row, comprising at least one category column;

a category row, comprising at least one product column;

wherein;

a category identifier represents a product category;

the category row has a key comprising the category identifier and a trend type;

the trend type row has a key comprising the trend type;

the at least one product column has a value comprising a product identifier;

the product identifier represents a product within the product category; and

the at least one category column has a value comprising the category identifier;

a trend server adapted to search the trend database to identify at least one trending product.

8. The system of claim 7, wherein the backend data collector is adapted to receive a dataset, the dataset comprising the product identifier, the category identifier, and the trend type.

9. The system of claim 7, further comprising a web server adapted to:

receive the product identifier from the trend server;

construct a user interface, the user interface comprising the at least one trending product; and

transmit the user interface to a user computing device for display to a user.

10. The system of claim 7, wherein the trend type comprises one of the group consisting of:

best-rated products, newly pinned products, best seller products, recently reviewed products, just sold products, and products mentioned in other social platforms.

11. A method of sorting trend data in a trend database, comprising:

at a trend database, receiving a dataset, the dataset comprising;

a product identifier;

a category identifier; and

a trend type;

at the trend database, generating a product column in a category row in the trend database, wherein;

the category row has a key comprising the trend type and the category identifier;

the product column has a name comprising a timestamp and a counter value; and

the product column has a value comprising the product identifier;

at the trend database, generating a category column in a trend type row in the trend database, wherein;

the trend type row has a key comprising the trend type;

the category column has a name comprising the timestamp and the counter value; and

the category column has a value comprising the category identifier.

12. The method of claim 11, wherein:

the key of the category row further comprises a date stamp and

the key of the trend type row further comprises the date stamp.

13. The method of claim 11, wherein the trend type comprises one of the group consisting of:

best-rated products, newly pinned products, best seller products, recently reviewed products, just sold products, and products mentioned in other social platforms.

14. The method of claim 11, further comprising transmitting a set of product identifiers to a user device for display at the user device in response to a query.