公开(公告)号：US10997227B2

公开(公告)日：2021-05-04

申请号：US15408664

申请日：2017-01-18

Applicant: Google Inc.

Inventor： Nikunj Agrawal ,  Mukund Sundararajan ,  Shrikant Ravindra Shanbhag ,  Kedar Dhamdhere ,  Garima ,  Kevin Snow McCurley ,  Rohit Ananthakrishna ,  Daniel Adam Gundrum ,  Juyun June Song ,  Rifat Ralfi Nahmias

IPC: G06F16/00 ,  G06F16/338 ,  G06F3/16 ,  G06T11/20 ,  G06F16/332 ,  G06F16/33 ,  G06F40/18 ,  G06F40/58 ,  G06F40/205

Abstract: Systems and methods are disclosed herein for processing a natural language query on data tables. According to some embodiments, a natural language query may be originated by a user via a user interface. The natural language query may be parsed to obtain a query term, and a grid range may be identified in a data table as relevant to the query term. A table summary may be prepared including a plurality of data entities based on the grid range. A logic operation may then be determined to apply on the plurality of data entities to derive the query term. The logic operation may then be translated into a formula executable on the data table, and the formula is applied on the data table to generate a result in response to the natural language query.

公开(公告)号：US20180203924A1

公开(公告)日：2018-07-19

申请号：US15408664

申请日：2017-01-18

Applicant: Google Inc.

Inventor： Nikunj Agrawal ,  Mukund Sundararajan ,  Shrikant Ravindra Shanbhag ,  Kedar Dhamdhere ,  Garima ,  Kevin Snow McCurley ,  Rohit Ananthakrishna ,  Daniel Adam Gundrum ,  Juyun June Song ,  Rifat Ralfi Nahmias

IPC: G06F17/30 ,  G06F3/16 ,  G06F17/27 ,  G06F17/28 ,  G06T11/20

CPC classification number: G06F16/338 ,  G06F3/167 ,  G06F16/24522 ,  G06F16/3326 ,  G06F16/3337 ,  G06F17/246 ,  G06F17/2705 ,  G06F17/289 ,  G06T11/206

Abstract: Systems and methods are disclosed herein for processing a natural language query on data tables. According to some embodiments, a natural language query may be originated by a user via a user interface. The natural language query may be parsed to obtain a query term, and a grid range may be identified in a data table as relevant to the query term. A table summary may be prepared including a plurality of data entities based on the grid range. A logic operation may then be determined to apply on the plurality of data entities to derive the query term. The logic operation may then be translated into a formula executable on the data table, and the formula is applied on the data table to generate a result in response to the natural language query.

公开(公告)号：US20170308571A1

公开(公告)日：2017-10-26

申请号：US15134010

申请日：2016-04-20

Applicant: Google Inc.

Inventor： Kevin McCurley ,  Qiqi Yan ,  Koen Dirckx ,  Kedar Dhamdhere ,  Rifat Ralfi Nahmias ,  Mukund Sundararajan

IPC: G06F17/30 ,  G06F17/28

CPC classification number: G06F16/243 ,  G06F16/2428 ,  G06F16/248 ,  G06F17/2881

Abstract: Techniques for utilizing a natural language interface to perform data analysis include receiving a natural language question for retrieving data stored in a database and interpreting the natural language question to generate a structured query for the database. The structured query is translated into a natural language representation of the structured query, which is displayed during execution of the structured query. Responsive data is received and one or more visualization types for presenting the responsive data to the user is determined based on the natural language question, the responsive data, and one or more data types of the data. A visualization of the responsive data is generated based on one visualization type of the determined visualization types, which is displayed in a card in a graphical user interface. The card can include the natural language representation of the structured query and the visualization of the responsive data.