-
公开(公告)号:US11550853B2
公开(公告)日:2023-01-10
申请号:US16681754
申请日:2019-11-12
IPC分类号: G06F16/90 , G06F16/904 , G06F40/30 , G06N5/04 , G06F40/253 , G06F40/211 , G06F16/242 , G06F16/28 , G06F16/26 , G06F16/248 , G06F40/279
摘要: A method executes at a computing device that includes a display, one or more processors, and memory. The method includes receiving user input to specify a data source. The method includes receiving a first user input in a first region of a graphical user interface to specify a natural language command related to the data source. The device determines, based on the first user input, that the natural language command includes a table calculation expression. In accordance with the determination, the method identifies a second data field in the data source, Values of the first data field are aggregated for each of the time periods in a range of dates according to the second data field. A respective difference between the aggregated values for each consecutive pair of time periods is computed. A data visualization is generated and displayed.
-
2.
公开(公告)号:US20220164540A1
公开(公告)日:2022-05-26
申请号:US17667474
申请日:2022-02-08
IPC分类号: G06F40/30 , G06F3/0484 , G06F3/0481 , G06F16/2455 , G06F16/248 , G06F40/205 , G06F40/284 , G06F16/9038 , G06F16/904 , G06F16/9032 , G06F40/211
摘要: A computing device displays a data visualization interface and receives user selection of a data source and a natural language command directed to the data source. The device forms a first intermediate expression according to a context-free grammar and a semantic model of data fields in the data source. In accordance with a determination that the first intermediate expression omits sufficient information for generating a data visualization, the device infers the omitted information associated with the data source using one or more inferencing rules based on syntactic and semantic constraints imposed by the context-free grammar. The device forms an updated intermediate expression, and translates the updated intermediate expression into database queries. It executes the database queries to retrieve data sets from the data source, then generates and displays a data visualization of the retrieved data sets.
-
公开(公告)号:US20210319186A1
公开(公告)日:2021-10-14
申请号:US17359387
申请日:2021-06-25
IPC分类号: G06F40/30 , G06F3/0484 , G06F3/0481 , G06F16/2455 , G06F16/248 , G06F40/205 , G06F40/284 , G06F16/9038 , G06F16/904 , G06F16/9032 , G06F40/211
摘要: A computing device receives user input to specify a natural language command directed to a data source. In accordance with the user input, the device forms an intermediate expression according to a context-free grammar and a semantic model of data fields in the data source. The natural language command includes (i) a first term that specifies an aggregation type in a first aggregation, (ii) a second term that specifies a data field, in the semantic model, to be aggregated for the first aggregation, and (iii) terms that specify data fields, in the semantic model, to determine grouping for the first aggregation. The device translates the intermediate expression into database queries, executes the database queries to retrieve one or more data sets from the data source, aggregated according to the first aggregation, then generates and displays a data visualization of the retrieved data sets.
-
公开(公告)号:US12032804B1
公开(公告)日:2024-07-09
申请号:US16680431
申请日:2019-11-11
发明人: Jeffrey Ericson , Vidya Raghavan Setlur , Alex Djalali , Hao Zhuang , Christopher Shawn Suley , Suyang Duan , Eliana Leite Goldner
IPC分类号: G06F16/248 , G06F3/0482 , G06F3/04842 , G06F40/166 , G06F40/30
CPC分类号: G06F3/0482 , G06F40/166 , G06F40/30
摘要: A method executes at a computing device that includes a display, one or more processors, and memory. The device displays a data visualization based on a dataset retrieved from a database. The device also displays one or more first phrases in a first region. The first phrases define the data visualization. The device receives a first user input in a second region to specify a natural language command related to the displayed data visualization. In response to the first user input, the device displays one or more proposed actions. The device receives user selection of a first proposed action of the proposed actions. In response to the user selection, the device generates an updated data visualization. The device displays the updated data visualization and displays a plurality of second phrases in the first region. The second phrases define the updated data visualization.
-
公开(公告)号:US11694036B2
公开(公告)日:2023-07-04
申请号:US17359387
申请日:2021-06-25
IPC分类号: G06F40/30 , G06F3/0484 , G06F3/0481 , G06F16/2455 , G06F16/248 , G06F40/205 , G06F40/284 , G06F16/9038 , G06F16/904 , G06F16/9032 , G06F40/211
CPC分类号: G06F40/30 , G06F3/0481 , G06F3/0484 , G06F16/248 , G06F16/24556 , G06F16/904 , G06F16/9038 , G06F16/90332 , G06F40/205 , G06F40/211 , G06F40/284
摘要: A computing device receives user input to specify a natural language command directed to a data source. In accordance with the user input, the device forms an intermediate expression according to a context-free grammar and a semantic model of data fields in the data source. The natural language command includes (i) a first term that specifies an aggregation type in a first aggregation, (ii) a second term that specifies a data field, in the semantic model, to be aggregated for the first aggregation, and (iii) terms that specify data fields, in the semantic model, to determine grouping for the first aggregation. The device translates the intermediate expression into database queries, executes the database queries to retrieve one or more data sets from the data source, aggregated according to the first aggregation, then generates and displays a data visualization of the retrieved data sets.
-
公开(公告)号:US20210073279A1
公开(公告)日:2021-03-11
申请号:US16681754
申请日:2019-11-12
IPC分类号: G06F16/904 , G06F40/30 , G06F40/211 , G06F40/253 , G06N5/04
摘要: A method executes at a computing device that includes a display, one or more processors, and memory. The method includes receiving user input to specify a data source. The method includes receiving a first user input in a first region of a graphical user interface to specify a natural language command related to the data source. The device determines, based on the first user input, that the natural language command includes a table calculation expression. In accordance with the determination, the method identifies a second data field in the data source, Values of the first data field are aggregated for each of the time periods in a range of dates according to the second data field. A respective difference between the aggregated values for each consecutive pair of time periods is computed. A data visualization is generated and displayed.
-
7.
公开(公告)号:US11995407B2
公开(公告)日:2024-05-28
申请号:US17667474
申请日:2022-02-08
IPC分类号: G06F40/30 , G06F3/0481 , G06F3/0484 , G06F16/2455 , G06F16/248 , G06F16/9032 , G06F16/9038 , G06F16/904 , G06F40/205 , G06F40/211 , G06F40/284
CPC分类号: G06F40/30 , G06F3/0481 , G06F3/0484 , G06F16/24556 , G06F16/248 , G06F16/90332 , G06F16/9038 , G06F16/904 , G06F40/205 , G06F40/211 , G06F40/284
摘要: A computing device displays a data visualization interface and receives user selection of a data source and a natural language command directed to the data source. The device forms a first intermediate expression according to a context-free grammar and a semantic model of data fields in the data source. In accordance with a determination that the first intermediate expression omits sufficient information for generating a data visualization, the device infers the omitted information associated with the data source using one or more inferencing rules based on syntactic and semantic constraints imposed by the context-free grammar. The device forms an updated intermediate expression, and translates the updated intermediate expression into database queries. It executes the database queries to retrieve data sets from the data source, then generates and displays a data visualization of the retrieved data sets.
-
8.
公开(公告)号:US11244114B2
公开(公告)日:2022-02-08
申请号:US16234470
申请日:2018-12-27
IPC分类号: G06F40/30 , G06F3/0484 , G06F3/0481 , G06F16/2455 , G06F16/248 , G06F40/205 , G06F40/284 , G06F16/9038 , G06F16/904 , G06F16/9032 , G06F40/211
摘要: A computing device displays a data visualization interface and receives user selection of a data source and a natural language command directed to the data source. The device forms a first intermediate expression according to a context-free grammar and a semantic model of data fields in the data source. In accordance with a determination that the first intermediate expression omits sufficient information for generating a data visualization, the device infers the omitted information associated with the data source using one or more inferencing rules based on syntactic and semantic constraints imposed by the context-free grammar. The device forms an updated intermediate expression, and translates the updated intermediate expression into database queries. It executes the database queries to retrieve data sets from the data source, then generates and displays a data visualization of the retrieved data sets.
-
9.
公开(公告)号:US20200089700A1
公开(公告)日:2020-03-19
申请号:US16134907
申请日:2018-09-18
IPC分类号: G06F16/35 , G06F16/335 , G06F17/28 , G06F16/904 , G06F17/24
摘要: A method is performed at a computing device having a display, one or more processors, and memory. The device displays a graphical user interface on the display. A user provides a natural language input, which specifies a filter, including a first data field, a relation, and a first comparison value. The user then replaces the first data field in the filter with a second data field. In response to replacing the first data field, the device automatically replaces the first comparison value with a second comparison value. The second comparison value corresponds to the data type of the second data field. In some instances, the device also updates the relation based on the data type of the second data field. The device then displays an updated data visualization according to the updated filter.
-
10.
公开(公告)号:US20240311571A1
公开(公告)日:2024-09-19
申请号:US18673275
申请日:2024-05-23
IPC分类号: G06F40/30 , G06F3/0481 , G06F3/0484 , G06F16/2455 , G06F16/248 , G06F16/9032 , G06F16/9038 , G06F16/904 , G06F40/205 , G06F40/211 , G06F40/284
CPC分类号: G06F40/30 , G06F3/0481 , G06F3/0484 , G06F16/24556 , G06F16/248 , G06F16/90332 , G06F16/9038 , G06F16/904 , G06F40/205 , G06F40/211 , G06F40/284
摘要: A computing device parses a user-specified natural language command to form a first expression. The computing device determines that the first expression is ambiguous or underspecified. The computing device, in accordance with the determination, infers first information using one or more inferencing rules, where at least one of the inferencing rules is based on an attribute of data fields and/or data values in a data source. The computing device forms a second expression based on the first expression using and the first information. The computing device retrieves one or more data sets from the data source using according to the second expression. The computing device generates and displays a data visualization of the retrieved one or more data sets.
-
-
-
-
-
-
-
-
-