Retrieval of attribute values based upon identified entities

Patent metadata

Field	Value
Publication number	US-10776375-B2
Application number	US-201414283273-A
Country	US
Kind code	B2
Filing date	May 21, 2014
Priority date	Jul 15, 2013
Publication date	Sep 15, 2020
Grant date	Sep 15, 2020

Abstract

Various technologies that facilitate performance of a data finding data (DFD) search are described herein. A user specifies entities, for example, by entering the entities into a query field, selecting the entities from a computer-executable application, or the like. The user further specifies an attribute of the entities that is of interest. A query is constructed based upon the entities and the attribute, and a search for tables is performed based upon the entities and the attribute. Values of the attribute for the selected entities are identified in a table, and the values of the attribute are returned.

First claim

What is claimed is:

1. A computing system comprising:
a processor; and
memory that has a spreadsheet application loaded therein, wherein the spreadsheet application, when executed by the processor, causes the processor to perform acts comprising:
displaying, on a display of the computing system, the spreadsheet in a graphical user interface of a spreadsheet application, wherein the spreadsheet comprises a table, and the table comprises a column that includes entities, wherein an entity is a string that represents a person, place, or thing, and wherein people, places, or things represented by the entities in the column have an attribute;
receiving an indication that a user has selected the entities in the table by way of the graphical user interface of the spreadsheet application;
receiving an indication that the user has requested a search to be performed based upon the selected entities from the column;
transmitting the selected entities to a server computing device that is programmed with instructions that, when executed by the server computing device, cause the server computing device to search over an index of source tables based upon the selected entities;
responsive to transmitting the selected entities to the server computing device, receiving attribute values for the attribute from the server computing device, the attribute values being values of the attribute of the computer-readable entities; and
responsive to receiving the attribute values for the attribute, updating the spreadsheet in the graphical user interface of the spreadsheet application to include another column, wherein the another column is populated with the attribute values such that the attribute values are displayed to correspond to the selected entities.

2. The computing system of claim 1 being one of a mobile telephone or a tablet computing device.

3. The computing system of claim 1 , the acts further comprising:
prior to receiving the attribute values from the server computing device, receiving table snippets from the server computing device, the table snippets summarizing respective source tables identified by the server computing device as being relevant to the selected entities; and
displaying the table snippets in the graphical user interface of the spreadsheet application responsive to receiving the table snippets.

4. The computing system of claim 3 , the acts further comprising:
receiving a selection of a table snippet in the table snippets, the attribute values comprised by a source table summarized by the table snippet, wherein the spreadsheet in the graphical user interface is updated to include the another column responsive to receipt of the selection of the table snippet.

5. The computing system of claim 4 , the table snippet comprises a title of the source table summarized by the table snippet, data that identifies a network location of the source table, and a sample portion of the source table, wherein keywords in a query utilized to locate the source table are highlighted in the table snippet where such keywords occur in the table snippet.

6. The computing system of claim 4 , the acts further comprising:
receiving an indication that a column represented in the table snippet has been selected from the table snippet, wherein updating the spreadsheet in the graphical user interface of the spreadsheet application to include the another column comprises adding contents of the column represented in the table snippet to the another column.

7. The computing system of claim of claim 1 , the acts further comprising:
receiving a selection of the attribute; and
transmitting the identity of the attribute to the server computing device with the entities.

8. The computing system of claim 1 , wherein the another column is adjacent to the column in the updated graphical user interface of the spreadsheet application.

9. The computing system of claim 1 , the acts further comprising:
displaying a popup window in the graphical user interface of the spreadsheet application in response to receiving the indication that the user has selected the entities in the table, wherein the popup window comprises a selectable option for retrieving the attribute values, wherein the indication that the user has requested the search to be performed is receipt of selection of the selectable option.

10. A method executed at a client computing device, the method comprising:
displaying a table in a graphical user interface of a spreadsheet application on a display of the client computing device, wherein the table has a column that the column includes entities, wherein an entity is a string that represents a person, place, or thing, and wherein people, places, or things represented by the entities in the column have an attribute;
receiving an indication that a user of the client computing device has selected the entities in the column of the table;
responsive to receiving the indication that the user of the client computing device has selected the entities, transmitting the entities to a server computing device, wherein the server computing device is programmed with instructions that, when executed by the server computing device, cause the server computing device to perform a search over an index of network-accessible tables based upon the selected entities;
receiving, from the server computing device, respective attribute values for the selected entities, the attribute values being values of the attribute; and
responsive to receiving the attribute values, updating the graphical user interface of the spreadsheet application such that the table includes another column, the another column comprises the attribute values, wherein the attribute values are arranged in the another column to correspond to the entities in the column that have the attribute values.

11. The method of claim 10 , the indication corresponding to one of a:
a selection the entities by way of a mouse pointer;
a selection of the entities by way of a gesture performed on a touch-sensitive display of the client computing device; or
a spoken command that identifies the entities.

12. The method of claim 10 , wherein responsive to transmitting the entities to the server computing device, attributes of the entities are received from the server computing device, the attributes comprise the attribute, the method further comprises:
receiving a selection of the attribute from the attributes;
responsive to receiving the selection of the attribute from the attributes, transmitting the attribute to the server computing device, wherein
the attribute values are received from the server computing device responsive to transmitting the attribute to the server computing device.

13. The method of claim 10 , further comprising:
responsive to transmitting the entities to the server computing device, receiving a ranked list of table snippets from the server computing device, each table snippet in the ranked list of table snippets summarizes a respective source table accessible by way of a network connection, each table snippet in the ranked list of table snippets comprises:
a title for the respective source table;
a network location of the respective source table; and
a representative portion of the respective source table;

prior to receiving the respective attribute values from the server computing device:
displaying the ranked list of table snippets on the display;
receiving a selection of a table snippet in the ranked list of table snippets, the table snippet summarizes a source table that comprises the attribute values;
responsive to receiving the selection of the table snippet, transmitting the selection of the tabl

Assignees

• Microsoft Corp
• Microsoft Technology Licensing Llc

Inventors

• Ganjam Kris
• Chen Zhimin
• Chakrabarti Kaushik
• Chaudhuri Surajit
• Narasayya Vivek
• Finnigan James
• Zoryn Kanstantsyn

Classifications

• G10L15/183 Primary

  using context dependencies, e.g. language models · CPC title

• G06F40/166 Primary

  Editing, e.g. inserting or deleting · CPC title

• G06F16/248 Primary

  Presentation of query results · CPC title

• G06F16/24578

  using ranking · CPC title

• G10L2015/228

  of application context · CPC title