Predicting entities for database query results

Patent metadata

Field	Value
Publication number	US-11163759-B2
Application number	US-201715851161-A
Country	US
Kind code	B2
Filing date	Dec 21, 2017
Priority date	Dec 21, 2017
Publication date	Nov 2, 2021
Grant date	Nov 2, 2021

Abstract

Predicting entities for database query results are described. A system receives a query that includes a query term. The system outputs a query result that identifies at least one record that includes the query term. The system identifies a selection of a record that is identified by the query result and that includes the query term. The system stores information that associates the query term with an entity that corresponds to the selected record. The system scales the information that associates the query term with the entity. The system receives another query that includes the query term. The system outputs another query result in response to the other query, the other query result being based on the scaled information that associates the query term with the entity.

First claim

The invention claimed is:

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 a query comprising a query term;
output a query result that identifies at least one record comprising the query term;
identify a selection of a record identified by the query result and comprising the query term, the record being one of a plurality of records of a database;
store information that associates the query term with a database entity that includes the selected record, each record of the database being associated with one of a plurality of different entities of the database, the storing comprising adjusting a count for the database entity of the selected record, the count comprising a number of times records associated with the database entity were selected from past query results;
scale the information that associates the query term with the entity, the scaling being based on information for all entities that include records associated with the query term;
receive another query comprising the query term; and
output another query result in response to the other query, the other query result being based on the scaled information that associates the query term with the entity.

2. The system of claim 1 , wherein scaling the information that associates the query term with the entity comprises:
determining a term-entity ratio by dividing a total number of user-selected records that correspond to the entity and that comprise the query term by a total number of user-selected records that correspond to the entity; and
determining a scaled term-entity ratio by dividing the term-entity ratio by a sum of a plurality of term-entity ratios that correspond to a plurality of entities.

3. The system of claim 1 , wherein the other query result is further based on a ratio of a total number of database records that correspond to the entity and that include the query term to a total number of database records that correspond to the entity.

4. The system of claim 1 , comprising further instructions, which when executed, cause the one or more processors to:
identify a selection of another record; and
store information that associates the query term with another entity that corresponds to the selected other record.

5. The system of claim 4 , comprising further instructions, which when executed, cause the one or more processors to scale the information that associates the query term with the other entity.

6. The system of claim 5 , wherein the other query result is further based on the scaled information that associates the query term with the other entity.

7. The system of claim 1 , wherein storing the information comprises storing the information for a tenant in a multi-tenant database.

8. A computer program product comprising a non-transitory computer-readable medium having computer readable program code embodied therein to be executed by one or more processors, the program code including instructions to:
receive a query comprising a query term;
output a query result that identifies at least one record comprising the query term;
identify a selection of a record identified by the query result and comprising the query term, the record being one of a plurality of records of a database;
store information that associates the query term with a database entity that includes the selected record, each record of the database being associated with one of a plurality of different entities of the database, the storing comprising adjusting a count for the database entity of the selected record, the count comprising a number of times records associated with the database entity were selected from past query results;
scale the information that associates the query term with the entity, the scaling being based on information for all entities that include records associated with the query term;
receive another query comprising the query term; and
output another query result in response to the other query, the other query result being based on the scaled information that associates the query term with the entity.

9. The computer program product of claim 8 , wherein scaling the information that associates the query term with the entity comprises:
determining a term-entity ratio by dividing a total number of user-selected records that correspond to the entity and that comprise the query term by a total number of user-selected records that correspond to the entity; and
determining a scaled term-entity ratio by dividing the term-entity ratio by a sum of a plurality of term-entity ratios that correspond to a plurality of entities.

10. The computer program product of claim 8 , wherein the other query result is further based on a ratio of a total number of database records that correspond to the entity and that include the query term to a total number of database records that correspond to the entity.

11. The computer program product of claim 8 , wherein the program code comprises further instructions to:
identify a selection of another record; and
store information that associates the query term with another entity that corresponds to the selected other record.

12. The computer program product of claim 11 , wherein the program code comprises further instructions to scale the information that associates the query term with the other entity.

13. The computer program product of claim 12 , wherein the other query result is further based on the scaled information that associates the query term with the other entity.

14. The computer program product of claim 8 , wherein storing the information comprises storing the information for a tenant in a multi-tenant database.

15. A method comprising:
receiving a query comprising a query term;
outputting a query result that identifies at least one record comprising the query term;
identifying a selection of a record identified by the query result and comprising the query term, the record being one of a plurality of records of a database;
storing information that associates the query term with a database entity that includes the selected record, each record of the database being associated with one of a plurality of different entities of the database, the storing comprising adjusting a count for the database entity of the selected record, the count comprising a number of times records associated with the database entity were selected from past query results;
scaling the information that associates the query term with the entity, the scaling being based on information for all entities that include records associated with the query term;
receiving another query comprising the query term; and
outputting another query result in response to the other query, the other query result being based on the scaled information that associates the query term with the entity.

16. The method of claim 15 , wherein scaling the information that associates the query term with the entity comprises:
determining a term-entity ratio by dividing a total number of user-selected records that correspond to the entity and that comprise the query term by a total number of user-selected records that correspond to the entity; and
determining a scaled term-entity ratio by dividing the term-entity ratio by a sum of a plurality of term-entity ratios that correspond to a plurality of entities.

17. The method of claim 15 , wherein the other query result is further based on a ratio of a total number of database records that correspond to the entity and that

Assignees

• Salesforce Com Inc

Inventors

• Kempf Guillaume

Classifications

• G06F16/24578

  using ranking · CPC title

• G06F16/2425 Primary

  Iterative querying; Query formulation based on the results of a preceding query · CPC title

• G06F16/2455

  Query execution · CPC title