IP Library Granted Patent US 8,577,862
Granted Patent B2
US 8,577,862 · App. 13/276,622 · Granted Nov 5, 2013

Answer-augmented query suggestion

Inventors: Stephen Petschulat (Coquitlam, CA); Luke Kysow (Vancouver, CA)
Assignee: Business Objects Software Limited
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 8,577,862
App. No.
13/276,622
Granted
Nov 5, 2013
Kind
B2
Abstract

A system includes reception of a partial query, determination of one or more previously-selected query phrases based on the partial query, determination, for each of the one or more previously-selected query phrases, of a dataset of a data source, determination, for each dataset determined for each of the one or more previously-selected query phrases, of a plurality of columns, and presentation, for each of the one or more previously-selected query phrases, of the previously-selected query phrase, the dataset determined for the previously-selected query phrase, and the columns determined for the dataset.

Claims (116)

1. A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:

receive a partial query;

determine one or more previously-selected query phrases based on the partial query;

for each of the one or more previously-selected query phrases, determine a dataset of a data source;

for each dataset determined for each of the one or more previously-selected query phrases, determine a plurality of columns, each of the plurality of columns being associated with a respective popularity; and

present, for each of the one or more previously-selected query phrases, the previously-selected query phrase, the dataset determined for the previously-selected query phrase, and the columns determined for the dataset.

2. A medium according to claim 1 , the program code further executable by a processor of a computing system to cause the computing system to:

receive a selection of one of the one or more presented previously-selected query phrases;

execute the selected one query phrase on the dataset determined for the selected one query phrase;

receive query results corresponding to the executed query phrase; and

present the query results, wherein the presented query results comprise the columns determined for the dataset determined for the selected one query phrase.

3. A medium according to claim 2 , the program code further executable by a processor of a computing system to cause the computing system to:

receive an indication of further usage of a plurality of columns of the presented query results; and

in response to indication,

store a first association between the determined dataset and the further usage of the plurality of columns; and

store a second association between the selected one query phrase and the determined dataset.

4. A medium according to claim 3 , wherein the plurality of columns is a subset of the columns determined for the dataset.

5. A medium according to claim 3 , wherein the columns determined for the dataset are a subset of the plurality of columns.

6. A medium according to claim 1 , wherein determination of a dataset for each of the one or more previously-selected query phrases comprises:

identification of a stored association between each of the one or more previously-selected query phrases and one or more respective datasets.

7. A medium according to claim 6 , wherein determination of a plurality of columns for each of the one or more datasets comprises:

identification of a stored association between each of the one or more datasets and a respective plurality of columns.

8. A computer-implemented method comprising:

receiving a partial query;

determining one or more previously-selected query phrases based on the partial query;

for each of the one or more previously-selected query phrases, determining a dataset of a data source;

for each dataset determined for each of the one or more previously-selected query phrases, determining a plurality of columns, each of the plurality of columns being associated with a respective popularity; and

presenting, for each of the one or more previously-selected query phrases, the previously-selected query phrase, the dataset determined for the previously-selected query phrase, and the columns determined for the dataset.

9. A method according to claim 8 , further comprising:

receiving a selection of one of the one or more presented previously-selected query phrases;

executing the selected one query phrase on the dataset determined for the selected one query phrase;

receiving query results corresponding to the executed query phrase; and

presenting the query results, wherein the presented query results comprise the columns determined for the dataset determined for the selected one query phrase.

10. A method according to claim 9 , further comprising:

receiving an indication of further usage of a plurality of columns of the presented query results; and

in response to indication,

storing a first association between the determined dataset and the further usage of the plurality of columns; and

storing a second association between the selected one query phrase and the determined dataset.

11. A method according to claim 10 , wherein the plurality of columns is a subset of the columns determined for the dataset.

12. A method according to claim 10 , wherein the columns determined for the dataset are a subset of the plurality of columns.

13. A method according to claim 8 , wherein determining a dataset for each of the one or more previously-selected query phrases comprises:

identifying a stored association between each of the one or more previously-selected query phrases and one or more respective datasets.

14. A method according to claim 13 , wherein determining a plurality of columns for each of the one or more datasets comprises:

identifying a stored association between each of the one or more datasets and a respective plurality of columns.

15. A system comprising:

a data storage device storing data;

a computing device comprising:

a memory storing processor-executable program code; and

a processor to execute the processor-executable program code in order to cause the computing device to:

receive a partial query;

determine one or more previously-selected query phrases based on the partial query;

for each of the one or more previously-selected query phrases, determine a dataset of a data source;

for each dataset determined for each of the one or more previously-selected query phrases, determine a plurality of columns, each of the plurality of columns being associated with a respective popularity; and

present, for each of the one or more previously-selected query phrases, the previously-selected query phrase, the dataset determined for the previously-selected query phrase, and the columns determined for the dataset.

16. A system according to claim 15 , the processor to further execute the processor-executable program code in order to cause the computing device to:

receive a selection of one of the one or more presented previously-selected query phrases;

execute the selected one query phrase on the dataset determined for the selected one query phrase;

receive query results from the data storage device corresponding to the executed query phrase; and

present the query results, wherein the presented query results comprise the columns determined for the dataset determined for the selected one query phrase.

17. A system according to claim 16 , the processor to further execute the processor-executable program code in order to cause the computing device to:

receive an indication of further usage of a plurality of columns of the presented query results; and

in response to indication,

store a first association between the determined dataset and the further usage of the plurality of columns; and

store a second association between the selected one query phrase and the determined dataset.

18. A system according to claim 17 , wherein the plurality of columns is a subset of the columns determined for the dataset.

19. A system according to claim 17 , wherein the columns determined for the dataset are a subset of the plurality of columns.

20. A system according to claim 15 , wherein determination of a dataset for each of the one or more previously-selected query phrases comprises:

identification of a stored association between each of the one or more previously-selected query phrases and one or more respective datasets.

21. A system according to claim 20 , wherein determination of a plurality of columns for each of the one or more datasets comprises:

identification of a stored association between each of the one or more datasets and a respective plurality of columns.

22. A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:

receive a partial query;

determine one or more previously-selected query phrases based on the partial query;

for each of the one or more previously-selected query phrases, determine a dataset of a data source;

for each dataset determined for each of the one or more previously-selected query phrases, determine a plurality of columns; and

present, for each of the one or more previously-selected query phrases, the previously-selected query phrase, the dataset determined for the previously-selected query phrase, and the columns determined for the dataset;

receive a selection of one of the one or more presented previously-selected query phrases;

execute the selected one query phrase on the dataset determined for the selected one query phrase;

receive query results corresponding to the executed query phrase; and

present the query results, wherein the presented query results comprise the columns determined for the dataset determined for the selected one query phrase;

receive an indication of further usage of a plurality of columns of the presented query results; and

in response to indication,

store a first association between the determined dataset and the further usage of the plurality of columns; and

store a second association between the selected one query phrase and the determined dataset.

23. A computer-implemented method comprising:

receiving a partial query;

determining one or more previously-selected query phrases based on the partial query;

for each of the one or more previously-selected query phrases, determining a dataset of a data source;

for each dataset determined for each of the one or more previously-selected query phrases, determining a plurality of columns;

presenting, for each of the one or more previously-selected query phrases, the previously-selected query phrase, the dataset determined for the previously-selected query phrase, and the columns determined for the dataset;

receiving a selection of one of the one or more presented previously-selected query phrases;

executing the selected one query phrase on the dataset determined for the selected one query phrase;

receiving query results corresponding to the executed query phrase;

presenting the query results, wherein the presented query results comprise the columns determined for the dataset determined for the selected one query phrase;

receiving an indication of further usage of a plurality of columns of the presented query results; and

in response to indication,

storing a first association between the determined dataset and the further usage of the plurality of columns; and

storing a second association between the selected one query phrase and the determined dataset.

24. A system comprising:

a data storage device storing data;

a computing device comprising:

a memory storing processor-executable program code; and

a processor to execute the processor-executable program code in order to cause the computing device to:

receive a partial query;

determine one or more previously-selected query phrases based on the partial query;

for each of the one or more previously-selected query phrases, determine a dataset of a data source;

for each dataset determined for each of the one or more previously-selected query phrases, determine a plurality of columns;

present, for each of the one or more previously-selected query phrases, the previously-selected query phrase, the dataset determined for the previously-selected query phrase, and the columns determined for the dataset;

receive a selection of one of the one or more presented previously-selected query phrases;

execute the selected one query phrase on the dataset determined for the selected one query phrase;

receive query results from the data storage device corresponding to the executed query phrase;

present the query results, wherein the presented query results comprise the columns determined for the dataset determined for the selected one query phrase;

receive an indication of further usage of a plurality of columns of the presented query results; and

in response to indication,

store a first association between the determined dataset and the further usage of the plurality of columns; and

store a second association between the selected one query phrase and the determined dataset.

Assignments (2)
CHANGE OF NAME Recorded Jan 26, 2026
From: BUSINESS OBJECTS SOFTWARE LIMITED
To: SAP IRELAND LIMITED
Reel/Frame 074510/0354 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 19, 2011
From: PETSCHULAT, STEPHEN; KYSOW, LUKE
To: BUSINESS OBJECTS SOFTWARE LIMITED
Reel/Frame 027086/0907 →
Continuity (1)
Related Publication 20130103710A1 · Apr 25, 2013