# US 2017/0286501 A1 · Data set preview technology

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2017/0286501 A1
- Document ID: US20170286501A1
- Status: Published application
- Kind: A1
- Application number: 15/626,903
- Filed: 2017-06-19
- Published: 2017-10-05
- Earliest claimed: 2014-06-25
- Assignees: Microsoft Technology Licensing, LLC
- Applicants: Microsoft Technology Licensing, LLC
- Inventors: Cheryl Couris; Jason Walken Falk; Drew Voegele; Jean-Sebastien Brunner; Konstantin Zoryn; Roman Kogan; Francesco Lunetta; Shankar Gopalakrishnan; Miguel Llopis; Shankar Regunathan
- Web page: https://patentgrep.com/patent/US20170286501A1

## CPC

- G06F 16/248: Presentation of query results
- G06F 16/9535: Search customisation based on user profiles and personalisation
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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

### Claim 1

(canceled)

### Claim 2

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.

### Claim 3 (depends on 2)

The computer-implemented method in accordance with claim 2, 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.

### Claim 4 (depends on 3)

The computer-implemented method in accordance with claim 3, 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.

### Claim 5 (depends on 4)

The computer-implemented method in accordance with claim 4, 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.

### Claim 6 (depends on 4)

The computer-implemented method in accordance with claim 4, 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.

### Claim 7 (depends on 3)

The computer-implemented method in accordance with claim 3, 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.

### Claim 8 (depends on 3)

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

### Claim 9

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.

### Claim 10 (depends on 9)

The system in accordance with claim 9, 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.

### Claim 11 (depends on 10)

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

### Claim 12 (depends on 10)

The system in accordance with claim 10, 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.

### Claim 13 (depends on 10)

The system in accordance with claim 10, 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.

### Claim 14 (depends on 9)

The system in accordance with claim 9, 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.

### Claim 15 (depends on 9)

The system in accordance with claim 9, 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.

### Claim 16 (depends on 15)

The system in accordance with claim 15, 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.

### Claim 17 (depends on 15)

The system in accordance with claim 15, 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.

### Claim 18 (depends on 9)

The system in accordance with claim 9, 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.

### Claim 19 (depends on 9)

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

### Claim 20

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.

### Claim 21 (depends on 20)

The computer-implemented method in accordance with claim 20, 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.

### Claim 22 (depends on 21)

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

### Claim 23 (depends on 21)

The computer-implemented method in accordance with claim 21, 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.

### Claim 24 (depends on 21)

The computer-implemented method in accordance with claim 21, 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.

### Claim 25 (depends on 20)

The computer-implemented method in accordance with claim 20, 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.

### Claim 26 (depends on 20)

The computer-implemented method in accordance with claim 20, 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.

### Claim 27 (depends on 26)

The computer-implemented method in accordance with claim 26, 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.

### Claim 28 (depends on 26)

The computer-implemented method in accordance with claim 26, 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.

### Claim 29 (depends on 20)

The computer-implemented method in accordance with claim 20, 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.

### Claim 30 (depends on 20)

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