IP Library Granted Patent US 11,163,759
Granted Patent B2
US 11,163,759 · App. 15/851,161 · Granted Nov 2, 2021

Predicting entities for database query results

Inventor: Guillaume Kempf (Grenoble, FR)
Assignee: salesforce.com, inc.
G06F16/2425G06F16/24578G06F16/2455
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,163,759
App. No.
15/851,161
Granted
Nov 2, 2021
Kind
B2
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.

Claims (55)

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 include the query term to a total number of database records that correspond to the entity.

18. The method of claim 15 , the method further comprising:

identifying a selection of another record; and

storing information that associates the query term with another entity that corresponds to the selected other record.

19. The method of claim 18 , the method further comprising scaling the information that associates the query term with the other entity.

20. The method of claim 19 , wherein the other query result is further based on the scaled information that associates the query term with the other entity.

Assignments (2)
CHANGE OF NAME Recorded Nov 21, 2024
From: SALESFORCE.COM, INC.
To: SALESFORCE, INC.
Reel/Frame 069431/0247 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 21, 2017
From: KEMPF, GUILLAUME
To: SALESFORCE.COM, INC.
Reel/Frame 044465/0844 →
Continuity (1)
Related Publication 20190197152A1 · Jun 27, 2019
Cited By (1)
US 12,254,002