Constructing data visualization options for a data set according to user-selected data fields

    公开(公告)号:US11500882B2

    公开(公告)日:2022-11-15

    申请号:US15908709

    申请日:2018-02-28

    摘要: A method constructs data visualization options. A user selects data fields from a data set. The process identifies a first plurality of data visualizations that use all of the user-selected data fields. For each data visualization, the process computes a score, based in part on visual patterns corresponding to statistical properties of data values of a user-selected data field. The process also identifies a second plurality of data visualizations, each using a majority of the user-selected data fields and also using a respective additional data field that is not one of the user-selected data fields. For each of the second plurality of data visualizations, the process computes a respective score, which uses data values of the respective additional data field. The process forms a recommended set of data visualizations including high-scoring data visualizations from both the first and second pluralities. The process presents the recommended data visualizations to the user.

    Using visual cues to validate object models of database tables

    公开(公告)号:US11475052B1

    公开(公告)日:2022-10-18

    申请号:US16679111

    申请日:2019-11-08

    摘要: A computer displays data sources associated with tables of data. The computer also displays a tree of data object icons, each representing a logical combination of tables. While displaying the data sources and the data object icons, the computer detects a portion of an input on a candidate data object icon. In response, the computer determines linking fields corresponding to a neighboring data object icon and linking fields corresponding to the candidate object icon. The computer displays options for a user to select linking fields. In response to detecting selection of linking fields, the computer validates the selection and/or updates the tree of data object icons based on the selected linking fields.

    Data preparation user interface with conglomerate heterogeneous process flow elements

    公开(公告)号:US11460977B2

    公开(公告)日:2022-10-04

    申请号:US17325124

    申请日:2021-05-19

    IPC分类号: G06F3/0482 G06F3/0484

    摘要: A method that prepares data for analysis includes displaying a user interface that includes a data a data flow pane that displays a flow diagram having a plurality of nodes, each node specifying a respective primary operation, a change list pane corresponding to a user-selected node in the data flow pane, and a data pane that displays a plurality of rows for an intermediate dataset of the user-selected node. The method also includes, in response to receiving a user input to perform a secondary operation at the user-selected node: (i) displaying, in the change list pane, an ordered list of secondary operations performed at the user-selected node, including displaying the secondary operation, and (ii) updating the data pane in accordance with the secondary operation, including updating the plurality of rows for the intermediate dataset.

    Dynamic Rebuilding of Query Execution Trees and Reselection of Query Execution Operators

    公开(公告)号:US20220237193A1

    公开(公告)日:2022-07-28

    申请号:US17719346

    申请日:2022-04-12

    IPC分类号: G06F16/2453 G06F16/2455

    摘要: A method dynamically selects query execution operators. A database engine receives a query, parses the query to form a query execution tree, and compiles the tree to form a first executable plan that includes in-memory operators. The database engine executes the first plan, including executing in-memory operators in parallel. While executing a first in-memory operator, insufficient memory is detected. In response, the database engine aborts the execution, and recompiles the query tree in two ways, forming a second executable plan that replaces the first in-memory operator with a first spooling operator. The first spooling operator executes within a fixed volatile memory budget and swaps to non-volatile memory according to the budget. A third executable plan retains the first in-memory operator, but schedules it to run serially. The database engine selects either the second plan or the third plan, and executes the selected plan to return results for the query.

    Data Preparation User Interface with Conditional Remapping of Data Values

    公开(公告)号:US20220164373A1

    公开(公告)日:2022-05-26

    申请号:US17670407

    申请日:2022-02-11

    摘要: A user selects a node that specifies an operation for a dataset. In response, a computer system displays data values for the dataset, in a grid in a data pane. The grid includes a first column and a second column. In the grid, the user edits a first data value in the first column in a first row. The user input changes the first data value to a replacement data value. The computer system identifies a second data value in the second column in the first row, and identifies one or more additional rows in the grid, whose data values for the first column and the second column match the first data value and the second data value. The computer system then updates the data value in the first column for a second row in the grid to the replacement data value.