Suggesting query items based on database fields

Patent metadata

Field	Value
Publication number	US-2018246901-A1
Application number	US-201715444915-A
Country	US
Kind code	A1
Filing date	Feb 28, 2017
Priority date	Feb 28, 2017
Publication date	Aug 30, 2018
Grant date	—

Abstract

Suggesting query items based on database fields is described. A database system receives a character sequence entered in a search box. The database system identifies a first distribution of first field-based items that include the character sequence, and a second distribution of second field-based items that include the character sequence. The database system identifies a first item based on combining the first distribution with a distribution of queried fields, and a second item based on combining the second distribution with the distribution of queried fields. The database system outputs the first item and the second item to a location associated with the search box. The database system executes a search based on any requested item, in response to receiving a request to search for any item output to the location associated with the search box.

First claim

1 . A system comprising:
one or more processors; and a non-transitory computer readable medium storing a plurality of instructions, which when executed, cause the one or more processors to: receive, by a database system, a character sequence entered in a search box; identify, by the database system, a first distribution of first field-based items, the first field-based items including the character sequence; identify, by the database system, a second distribution of second field-based items, the second field-based items including the character sequence; identify, by the database system, a first item from the first field-based items based on combining the first distribution with a distribution of queried fields, and a second item from the second field-based items based on combining the second distribution with the distribution of queried fields; output, by the database system, the first item and the second item to a location associated with the search box; and execute, by the database system, a search based on any requested item, in response to receiving a request to search for any item output to the location associated with the search box.

2 . The system of claim 1 , comprising further instructions, which when executed, cause the one or more processors to identify, by the database system, the first distribution of first field-based items including the character sequence based on proportions of items that were in historical queries, that are stored by a first field, and that start with the character sequence.

3 . The system of claim 1 , comprising further instructions, which when executed, cause the one or more processors to identify, by the database system, the distribution of queried fields based on identifying items in historical queries and determining proportions of fields that store the identified items.

4 . The system of claim 1 , wherein identifying the first item and the second item is based on the first item and the second item being associated with corresponding item proportions that are larger than corresponding item proportions associated with a plurality of different items.

5 . The system of claim 1 , comprising further instructions, which when executed, cause the one or more processors to:
receive, by the database system, a selection of an item from the location associated with the search box and an additional character sequence entered in the search box; identify, by the database system, a third distribution of third field-based items including the additional character sequence, and a fourth distribution of fourth field-based items including the additional character sequence; identify, by the database system, a third item based on combining the third distribution with query schemas including a field storing the selected item, and a fourth item based on combining the fourth distribution with the query schemas including the field storing the selected item; and output, by the database system, the third item and the fourth item to the location associated with the search box.

6 . The system of claim 5 , comprising further instructions, which when executed, cause the one or more processors to identify, by the database system, the query schemas including the field storing the selected item based on proportions of fields being associated with the field storing the selected item via association with queried sets of items associated with the field storing the selected item.

7 . The system of claim 5 , wherein identifying the third item and the fourth item is based on the third item and the fourth item being associated with corresponding item proportions that are larger than corresponding item proportions associated with a plurality of different items.

8 . A computer program product comprising computer-readable program code to be executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code including instructions to:
receive, by a database system, a character sequence entered in a search box; identify, by the database system, a first distribution of first field-based items, the first field-based items including the character sequence; identify, by the database system, a second distribution of second field-based items, the second field-based items including the character sequence; identify, by the database system, a first item from the first field-based items based on combining the first distribution with a distribution of queried fields, and a second item from the second field-based items based on combining the second distribution with the distribution of queried fields; output, by the database system, the first item and the second item to a location associated with the search box; and execute, by the database system, a search based on any requested item, in response to receiving a request to search for any item output to the location associated with the search box.

9 . The computer program product of claim 8 , wherein the program code comprises further instructions to identify, by the database system, the first distribution of first field-based items including the character sequence based on proportions of items that were in historical queries, that are stored by a first field, and that start with the character sequence.

10 . The computer program product of claim 8 , wherein the program code comprises further instructions to identify, by the database system, the distribution of queried fields based on identifying items in historical queries and determining proportions of fields that store the identified items.

11 . The computer program product of claim 8 , wherein identifying the first item and the second item is based on the first item and the second item being associated with corresponding item proportions that are larger than corresponding item proportions associated with a plurality of different items.

12 . The computer program product of claim 8 , wherein the program code comprises further instructions to:
receive, by the database system, a selection of an item from the location associated with the search box and an additional character sequence entered in the search box; identify, by the database system, a third distribution of third field-based items including the additional character sequence, and a fourth distribution of fourth field-based items including the additional character sequence; identify, by the database system, a third item based on combining the third distribution with query schemas including a field storing the selected item, and a fourth item based on combining the fourth distribution with the query schemas including the field storing the selected item; and output, by the database system, the third item and the fourth item to the location associated with the search box.

13 . The computer program product of claim 12 , wherein the program code comprises further instructions to identify, by the database system, the query schemas including the field storing the selected item based on proportions of fields being associated with the field storing the selected item via association with queried sets of items associated with the field storing the selected item.

14 . The computer program product of claim 12 , wherein identifying the third item and the fourth item is based on the third item and the fourth item being associated with corresponding item proportions that are larger than corresponding item proportions associated with a plurality of different items.

15 . A method comprising:
receiving, by a database system, a character sequence entered in a search box; identifying, by the database system, a first distrib

Assignees

• Salesforce Com Inc

Inventors

• Fuchs Matthew

Classifications

• G06F16/90324 Primary

  using system suggestions · CPC title

• G06F16/242

  Query formulation · CPC title

• G06F17/30477

  Physics · mapped topic

• G06F17/3097 Primary

  Physics · mapped topic