Data set preview technology

• US 9,892,175 B2
• Filed: 06/19/2017
• Issued: 02/13/2018
• Est. Priority Date: 06/25/2014
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Couris, Cheryl, Falk, Jason Walken, Voegele, Drew, Brunner, Jean-Sebastien, Zoryn, Konstantin, Kogan, Roman, Lunetta, Francesco, Gopalakrishnan, Shankar, Llopis, Miguel, Regunathan, Shankar
• Primary Examiner(s): PHANTANA ANGKOOL, DAVID
• Application Number:
  US15/626,903
• Publication Number:
  US 20170286501A1
• Time in Patent Office: 239 Days
• Field of Search: 715856
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation

Abstract

A mechanism for providing a preview of a data set. The search system finds a data set relevant to the search query. For any given data set, the search system extracts only a sample of elements from the data set. The sample of elements provided to the requestor includes elements for which there is a match on the search query, and elements that have no hit, but are proximate to an element that has a hit. The user obtains a view constructed of the sample of elements provided by the search system. The user is also provided with navigation controls that correspond to the most search-relevant portions of the view. Controls associated with those portion(s) may then be selected to thereby move the preview of the data set so that the portion or corresponding hit for that portion is in view.

Claims

1. A computer-implemented method of presenting a preview of search results, comprising:

obtaining a preview of a data set that matches a search query having one or more search terms, wherein obtaining the preview of the data set comprises;

in a first display area of a user interface, presenting for selection identifications for a plurality of data sets selected in response to the search query; and

in a second display area of the user interface, presenting a navigable preview of a data set corresponding to a selection of one of the identifications for the plurality of data sets, wherein the navigable preview of the data set comprises a table having columns and rows in which data of the previewed data set is presented;

in a navigation control area of the user interface, visually emphasizing one or more portions of the table, wherein each visually emphasized portion of the table contains one or more hits for one or more search terms of the query;

selecting one of the visually emphasized portions presented in the navigation control area; and

in response to the selection, the navigable view being adjusted to present only rows or columns of the table which contain a hit for one of the search terms of the query.

2. The computer-implemented method in accordance with claim 1, wherein selection of a visually emphasized portion causes a list to appear of one or more search terms that are found in a row or column for the corresponding visually emphasized portion.

3. The computer-implemented method in accordance with claim 2, wherein adjusting the navigable view comprises, in addition to presenting only rows or columns of the table which contain a hit for one of the search terms of the query, the navigable view is further adjusted to present a given number of other rows or columns each containing a hit and selected based on proximity to the rows or columns presented when the navigable view was adjusted in response to the selection.

4. The computer-implemented method in accordance with claim 3, wherein further adjusting the navigable view comprises deleting one or more rows to present a given row containing a hit and the given number of other rows is selected based on proximity to the given row containing the hit.

5. The computer-implemented method in accordance with claim 3, wherein further adjusting the navigable view comprises deleting one or more columns to present a given column containing a hit and the given number of other columns is selected based on proximity to the given column containing the hit.

6. The computer-implemented method in accordance with claim 2, wherein the navigable preview comprising the table having columns and rows is initially presented with a concentration of rows and columns sufficient to provide an indication of the nature of the data set contained by the table presented in the navigable preview.

7. The computer-implemented method in accordance with claim 2, wherein the one or more visually emphasized portions of the table are column headings.

8. A system comprising:

one or more processors;

a computer-readable media having thereon computer-executable instructions that are structured such that, when executed by one or more processors of a computing system, cause the computing system to perform a method of presenting a preview of search results, the method comprising;

obtaining a preview of a data set that matches a search query having one or more search terms, wherein obtaining the preview of the data set comprises;

in a first display area of a user interface, presenting for selection identifications for a plurality of data sets selected in response to the search query; and

in a second display area of the user interface, presenting a navigable preview of a data set corresponding to a selection of one of the identifications for the plurality of data sets, wherein the navigable preview of the data set comprises a table having columns and rows in which data of the previewed data set is presented;

in a navigation control area of the user interface, visually emphasizing one or more portions of the table, wherein each visually emphasized portion of the table contains one or more hits for one or more search terms of the query;

selecting one the visually emphasized portions presented in the navigation control area; and

in response to the selection, the navigable view being adjusted to present only rows or columns of the table which contains a hit for one of the search terms of the query.

9. The system in accordance with claim 8, wherein the plurality of data sets are each dimensional data sets comprising a table with rows and columns in which the data is presented, and wherein obtaining the preview of a data set that matches a search query further comprises:

for one or more data sets, extracting samples of sub-dimensional elements comprised or rows or columns from the dimensional data set, the samples of sub-dimensional elements including a first set of samples of sub-dimensional elements which contain a hit for one or more terms of the search query, and a second set of samples of sub-dimensional elements that are proximate to at least one the first set of samples of sub-dimensional elements.

10. The system in accordance with claim 9, wherein the extracted samples are ranked.

11. The system in accordance with claim 9, wherein the extracted samples are not extracted until a request is received to extract the samples for a given selection of an identification of one of the plurality of data sets.

12. The system in accordance with claim 9, wherein the extracted samples are contained in the navigable preview presented in response to selection of one of the identifications for one of the plurality of data sets.

13. The system in accordance with claim 8, wherein selection of a visually emphasized portion causes a list to appear of one or more search terms that are found in a row or column for the corresponding visually emphasized portion.

14. The system in accordance with claim 8, wherein adjusting the navigable view comprises, in addition to presenting only rows or columns of the table which contain a hit for one of the search terms of the query, the navigable view is further adjusted to also present a given number of other rows or columns selected based on proximity to the rows or columns presented when the navigable view was adjusted in response to the selection.

15. The system in accordance with claim 14, wherein further adjusting the navigable view comprises deleting one or more rows to present a row containing a hit and the given number of other rows is selected based on proximity to the row containing the hit.

16. The system in accordance with claim 14, wherein further adjusting the navigable view comprises deleting one or more columns to present a column containing a hit and the given number of other columns is selected based on proximity to the column containing the hit.

17. The system in accordance with claim 8, wherein the navigable preview comprising the table having columns and rows is initially presented with a concentration of rows and columns sufficient to provide an indication of the nature of the data set contained by the table presented in the navigable preview.

18. The system in accordance with claim 8, wherein the one or more visually emphasized portions of the table are column headings.

19. A computer-implemented method of presenting a preview of search results comprising:

obtaining a preview of a data set that matches a search query having one or more search terms, wherein obtaining the preview of the data set comprises;

in a first display area of a user interface, presenting for selection identifications for a plurality of data sets selected in response to the search query; and

in a second display area of the user interface, presenting a navigable preview of a data set corresponding to a selection of one of the identifications for the plurality of data sets, wherein the navigable preview of the data set comprises a table having columns and rows in which data of the previewed data set is presented, and wherein only those rows and columns presented in the navigable preview are rows and columns that contain one or more hits for the one or more search terms;

in a navigation control area of the user interface, visually emphasizing one or more portions of the table, wherein each visually emphasized portion of the table contains one or more hits for one or more search terms of the query;

selecting for presentation with the navigable view one the visually emphasized portions presented in the navigation control area; and

in response to the selection, the navigable view being adjusted to include at least one additional row or column based on the emphasized portion selected for presentation.

20. The computer-implemented method in accordance with claim 19, wherein the plurality of data sets are each dimensional data sets comprising a table with rows and columns in which the data is presented, and wherein obtaining the preview of a data set that matches a search query further comprises:

for one or more data sets, extracting samples of sub-dimensional elements comprised or rows or columns from the dimensional data set, the samples of sub-dimensional elements including a first set of samples of sub-dimensional elements which contain a hit for one or more terms of the search query, and a second set of samples of sub-dimensional elements that are proximate to at least one the first set of samples of sub-dimensional elements.

21. The computer-implemented method in accordance with claim 20, wherein the extracted samples are ranked.

22. The computer-implemented method in accordance with claim 20, wherein the extracted samples are not extracted until a request is received to extract the samples for a given selection of an identification of one of the plurality of data sets.

23. The computer-implemented method in accordance with claim 20, wherein the extracted samples are contained in the navigable preview presented in response to selection of one of the identifications for one of the plurality of data sets.

24. The computer-implemented method in accordance with claim 19, wherein selection of a visually emphasized portion causes a list to appear of one or more search terms that are found in a row or column for the corresponding visually emphasized portion.

25. The computer-implemented method in accordance with claim 19, wherein adjusting the navigable view comprises, in addition to presenting only those rows or columns of the table which contains a hit for one of the search terms of the query, the navigable view is further adjusted to present a given number of rows or columns selected based on proximity to a given row or column which contains a hit.

26. The computer-implemented method in accordance with claim 25, wherein further adjusting the navigable view comprises deleting one or more rows to present a given row containing the hit and the given number of rows selected is based on proximity to the given row containing the hit.

27. The computer-implemented method in accordance with claim 25, wherein further adjusting the navigable view comprises deleting one or more columns to present a given column containing the hit and the given number of rows is selected based on proximity to the given column containing the hit.

28. The computer-implemented method in accordance with claim 19, wherein the navigable preview comprising the table having columns and rows is initially presented with a concentration of rows and columns sufficient to provide an indication of the nature of the data set contained by the table presented in the navigable preview.

29. The computer-implemented method in accordance with claim 19, wherein the one or more visually emphasized portions of the table are column headings.