IP Library › Granted Patent US 11,397,770
Granted Patent B2
US 11,397,770 · App. 16/200,152 · Granted Jul 26, 2022

Query discovery and interpretation

Inventor: Satishkumar Sekharan (Coquitlam, CA)
Assignee: SAP SE
G06F16/90328G06F16/3344G06F16/9038G06F40/205
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,397,770
App. No.
16/200,152
Granted
Jul 26, 2022
Kind
B2
Abstract

A system includes reception of a token input by a user into a user interface, determination, in response to reception of the token, of a query entity associated with the token, the query entity associated with an entity type, and display of a graphical indicator on the user interface in association with the token, the graphical indicator indicating the determined entity type.

Claims (84)

1. A computing system comprising:

one or more hardware processors to:

process a token received from a first user input into a user interface;

determine at least two query entities associated with the token and entity types associated with each of the at least two query entities, the entity types being selected from a group of entity types comprising at least database schema attributes, the database schema attributes comprising at least dimensions and measures;

initiate display, on the user interface, of:

a multi-query entity indicator indicating that the token has been matched with the at least two query entities,

a menu indicating the at least two query entities determined to match with the token with at least a threshold confidence level, wherein a particular query entity of the at least two query entities is selected in response to a second user input,

a first graphical indicator comprising at least a particular color or shade to indicate the determined entity type for the selected query entity of the at least two query entities in response to the second user input, and

a textual indication of the determined entity type associated with the selected query entity and with the token in response to receiving a third user input to cause a movable second graphical indicator to hover over the token.

2. The computing system according to claim 1 , wherein the entity types comprise one or more of a measure or a dimension.

3. The computing system according to claim 1 , the computing system to:

receive a second token input by the user into the user interface during display of the first graphical indicator on the user interface in association with the token;

in response to reception of the second token, determine a second query entity associated with the second token, the second query entity associated with a second entity type; and

display a second graphical indicator on the user interface in association with the second token during display of the first graphical indicator on the user interface in association with the token, the second graphical indicator indicating the second entity type.

4. The computing system according to claim 3 , wherein the determined entity type for the selected query entity is a measure and the second entity type is a dimension, the computing system further to:

receive a query comprising the selected query entity and the second query entity;

execute the query to determine a result set; and

display a visualization of the result set on the user interface.

5. The computing system according to claim 1 , wherein the selected query entity is not identical to the token.

6. The computing system according to claim 1 , the computing system further to:

receive a query comprising the selected query entity;

execute the query to determine a result set; and

display a visualization of the result set on the user interface.

7. The computing system according to claim 6 , the computing system further to:

display the query on the user interface during display of the visualization of the result set on the user interface;

receive a second token input by the user into the user interface during display of the query on the user interface and during display of the visualization of the result set on the user interface;

in response to reception of the second token, determine a second query entity associated with the second token, the second query entity associated with a second entity type;

display a second graphical indicator on the user interface in association with the second token during display of the query on the user interface and during display of the visualization of the result set on the user interface, the second graphical indicator indicating the second entity type;

execute a second query including the query and the second query entity to determine a second result set; and

display a second visualization of the second result set on the user interface.

8. A computer-implemented method comprising:

processing a token received from a first user input into a user interface;

determining at least two query entities associated with the token and entity types associated with each of the at least two query entities, the entity types being selected from a group of entity types comprising at least database schema attributes, the database schema attributes comprising at least dimensions and measures;

initiating display, on the user interface, of:

a multi-query entity indicator indicating that the token has been matched with the at least two query entities,

a menu indicating the at least two query entities determined to match with the token with at least a threshold confidence level, wherein a particular query entity of the at least two query entities is selected in response to a second user input,

a first graphical indicator comprising at least a particular color or shade to indicate the determined entity type for the selected query entity of the at least two query entities in response to the second user input, and

a textual indication of the determined entity type associated with the selected query entity and with the token in response to receiving a third user input to cause a movable second graphical indicator to hover over the token.

9. The method according to claim 8 , wherein the entity types comprise one or more of a measure or a dimension.

10. The method according to claim 8 , further comprising:

receiving a second token input by the user into the user interface during display of the first graphical indicator on the user interface in association with the token;

in response to receiving the second token, determining a second query entity associated with the second token, the second query entity associated with a second entity type; and

adding a second graphical indicator to the user interface in association with the second token during display of the first graphical indicator on the user interface in association with the token, the second graphical indicator indicating the second entity type.

11. The method according to claim 10 , wherein a first the determined entity type for the selected query entity is a measure and the second entity type is a dimension, further comprising:

receiving a query comprising the selected query entity and the second query entity;

executing the query to determine a result set; and

displaying a visualization of the result set on the user interface.

12. The method according to claim 8 , wherein the selected query entity is not identical to the token.

13. The method according to claim 8 , further comprising:

receiving a query comprising the selected query entity;

executing the query to determine a result set; and

displaying a visualization of the result set on the user interface.

14. The method according to claim 13 , further comprising:

displaying the query on the user interface during display of the visualization of the result set on the user interface;

receiving a second token input by the user into the user interface during display of the query on the user interface and during display of the visualization of the result set on the user interface;

in response to reception of the second token, determining a second query entity associated with the second token, the second query entity associated with a second entity type;

adding a second graphical indicator to the user interface in association with the second token during display of the query on the user interface and during display of the visualization of the result set on the user interface, the second graphical indicator indicating the second entity type;

executing a second query including the query and the second query entity to determine a second result set; and

displaying a second visualization of the second result set on the user interface.

15. A computer-implemented system comprising:

a non-transitory storage medium to store executable instructions; and

one or more hardware processors to execute the instructions to implement:

a parser to identify a part of speech associated with an input token received from a user, via a first user input into a user interface;

a mapper to map the input token to at least two query entities comprising a keyword or a database schema attribute based on the part of speech, wherein each query entity of the at least two query entities is associated with an entity type comprising at least database schema attributes; and

an application to:

generate a user interface,

initiate display, on the user interface, of:

a multi-query entity indicator indicating that the input token has been matched with the at least two query entities,

a menu indicating the at least two query entities determined to match with the input token with at least a threshold confidence level, wherein a particular query entity of the at least two query entities is selected in response to a second user input,

a first graphical indicator associated with the input token, the first graphical indicator comprising at least a particular color or shade to indicate the determined entity type for the selected query entity of the at least two query entities in response to the second user input, and

a textual indication of the determined entity type associated with the selected query entity and with the input token in response to receiving a third user input to cause a movable second graphical indicator to hover over the input token.

16. The system according to claim 15 , wherein the entity type comprises one or more of a measure or a dimension.

17. The system according to claim 15 ,

the parser to identify a second part of speech associated with a second input token;

the mapper to map the second input token to a second query entity comprising a keyword or a database schema attribute based on the second part of speech; and

the application to generate a second graphical indicator indicating a second entity type of the second query entity,

wherein the generated user interface includes the second graphical indicator displayed in association with the second input token.

18. The system according to claim 17 , wherein the determined entity type for the selected query entity is a measure and the second entity type is a dimension, further comprising:

a query server to receive a query comprising the selected query entity and the second query entity, and to execute the query to determine a result set; and

the application to include a visualization of the result set on the user interface.

19. The system according to claim 15 , wherein the selected query entity is not identical to the input token.

20. The system according to claim 15 , further comprising:

a query server to receive a query comprising the selected query entity, and to execute the query to determine a result set; and

the application to include a visualization of the result set on the user interface.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 26, 2018
From: SEKHARAN, SATISHKUMAR
To: SAP SE
Reel/Frame 047583/0971 →
Continuity (1)
Related Publication 20200167432A1 · May 28, 2020
Cited By (1)
US 12,292,941