# US 9,519,702 B2 · System and method for mining category aspect information > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 9,519,702 B2 - Document ID: US9519702B2 - Status: Granted - Kind: B2 - Application number: 15/071,309 - Filed: 2016-03-16 - Published: 2016-07-07 - Granted: 2016-12-13 - Earliest claimed: 2011-06-08 - Assignees: eBay Inc. - Applicants: eBay Inc. - Inventors: Qian Zhong; Guanglei Song; Zhaohui Chen - Web page: https://patentgrep.com/patent/US9519702B2 ## CPC - G06F 16/24544: {Join order optimisation} - G06F 16/2246: {Trees, e.g. B+trees} - G06F 16/2282: {Tablespace storage structures; Management thereof} - G06F 16/2456: {Join operations} - G06F 16/24575: {using context} - G06F 16/24578: {using ranking} - G06F 16/285: {Clustering or classification} - G06Q 30/02: Marketing; Price estimation or determination; Fundraising - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR ## Abstract Systems and methods for providing category aspect information by mining historical data is provided. A table comprising joined data is accessed. The table includes historical data that comprises user behavior data based on actions performed with past queries by users listing data that includes aspect data for each listing and a determined category for each listing. Demand scores based on the joined data are determined. The determined demand scores are used to determine at least one relevant aspect name for a category. A message is transmitted for display on a device of the user that indicates the at least one most relevant aspect name for the category and suggests the user provide an aspect value that corresponds to the at least one most relevant aspect name to be included in a new listing. ## Claims ### Claim 1 A method comprising: accessing, by a hardware processor, a table comprising joined data, the joined data including historical data comprising data based on actions performed by users, listing data comprising data describing each listing, and a determined category for each listing; determining, by an aggregation module, demand scores based on the joined data; determining, by an aspect determination module, at least one most relevant aspect name for a category based on the determined demand scores; and in response to an indication that a user is creating a new listing within the category, transmitting a message for display on a device of the user, the message indicating the at least one most relevant aspect name for the category and suggesting the user provide an aspect value that corresponds to the at least one most relevant aspect name to be included in the new listing. ### Claim 2 (depends on 1) The method of claim 1, wherein the determining the demand score comprises aggregating over the joined data to define the demand score. ### Claim 3 (depends on 1) The method of claim 1, further comprising: compiling the historical data; accessing the listing data; and creating the table by joining the historical data with the listing data and the determined category of each listing. ### Claim 4 (depends on 1) The method of claim 1, wherein the determining the at least one most relevant aspect name comprises sorting the determined demand scores in descending order. ### Claim 5 (depends on 1) The method of claim 1, further comprising sorting the determined demand scores for the at least one most relevant aspect name to determine at least one most relevant aspect value for the at least one relevant aspect name. ### Claim 6 (depends on 5) The method of claim 5, further comprising determining listings having the at least one most relevant aspect name and the at least one most relevant aspect value for the at least one most relevant aspect name, the determined listings to be promoted. ### Claim 7 (depends on 6) The method of claim 6, further comprising promoting the listings having the at least one most relevant aspect name and the at least one most relevant aspect value by visually distinguishing the listings from other listings. ### Claim 8 (depends on 1) The method of claim 1, wherein the table comprises categories, aspect names, aspect values, and action counts. ### Claim 9 (depends on 1) The method of claim 1, wherein the determining the demand scores is a function of two or more action counts selected from the group comprising impression counts, click action counts, Buy-It-Now action counts, bid action counts, watch action counts, ask action counts, and offer action counts. ### Claim 10 A system comprising: one or more hardware processors configured to at least: access a table comprising joined data, the joined data including historical data comprising data based on actions performed by users, listing data comprising data describing each listing, and a determined category for each listing; determine demand scores based on the joined data; determine at least one most relevant aspect name for a category based on the determined demand scores; and in response to an indication that a user is creating a new listing within the category, transmit a message for display on a device of the user, the message indicating the at least one most relevant aspect name for the category and suggesting the user provide an aspect value that corresponds to the at least one most relevant aspect name to be included in the new listing. ### Claim 11 (depends on 10) The system of claim 10, wherein the one or more hardware processors is further configured to: compile the historical data; access the listing data; and create the table by joining the historical data with the listing data and the determined category of each listing. ### Claim 12 (depends on 10) The system of claim 10, wherein the one or more hardware processors is further configured to sort the determined demand scores for the at least one most relevant aspect name to determine at least one most relevant aspect value for the at least one relevant aspect name. ### Claim 13 (depends on 12) The system of claim 12, wherein the one or more hardware processors is further configured to determine listings having the at least one most relevant aspect name and the at least one most relevant aspect value for the at least one most relevant aspect name, the determined listings to be promoted. ### Claim 14 (depends on 13) The system of claim 13, wherein the one or more hardware processors is further configured to promote the listings having the at least one most relevant aspect name and the at least one most relevant aspect value by visually distinguishing the listings from other listings. ### Claim 15 A machine-readable storage medium having no transitory signals and storing instructions which, when executed by at least one processor of a machine, cause the machine to perform operations comprising: accessing a table comprising joined data, the joined data including historical data comprising data based on actions performed by users, listing data comprising data describing each listing, and a determined category for each listing; determining demand scores based on the joined data; determining at least one most relevant aspect name for a category based on the determined demand scores; and in response to an indication that a user is creating a new listing within the category, transmitting a message for display on a device of the user, the message indicating the at least one most relevant aspect name for the category and suggesting the user provide an aspect value that corresponds to the at least one most relevant aspect name to be included in the new listing. ### Claim 16 (depends on 15) The machine-readable storage medium of claim 15, wherein the determining the demand score comprises aggregating over the joined data to define the demand score. ### Claim 17 (depends on 15) The machine-readable storage medium of claim 15, wherein the determining the at least one most relevant aspect name comprises sorting the determined demand scores in descending order. ### Claim 18 (depends on 15) The machine-readable storage medium of claim 15, wherein the operations further comprise sorting the determined demand scores for the at least one most relevant aspect name to determine at least one most relevant aspect value for the at least one relevant aspect name. ### Claim 19 (depends on 18) The machine-readable storage medium of claim 18, wherein the operations further comprise determining listings having the at least one most relevant aspect name and the at least one most relevant aspect value for the at least one most relevant aspect name, the determined listings to be promoted. ### Claim 20 (depends on 19) The machine-readable storage medium of claim 19, wherein the operations further comprise promoting the listings having the at least one most relevant aspect name and the at least one most relevant aspect value by visually distinguishing the listings from other listings.