-
公开(公告)号:US20240134894A1
公开(公告)日:2024-04-25
申请号:US18381165
申请日:2023-10-17
发明人: Thomas NEUMANN , Viktor Leis , Alfons Kemper , Tobias Muehlbauer , Jan Finis
CPC分类号: G06F16/3332 , G06F16/23 , G06F16/334
摘要: A method executes at a computer system to retrieve data from a database. Upon receiving a database query, the computer system translates the query into an intermediate representation, and estimates a compilation time to compile the intermediate representation into machine executable code. The query execution time to retrieve a result set is also estimated. In accordance with a determination that the query execution time and compilation time satisfy an interpretation criterion, the computer system invokes a byte code interpreter to interpret the intermediate representation and retrieve the result set from the database. In accordance with a determination that the query execution and compilation times satisfy one of a plurality of compilation criteria, the computer system compiles the intermediate representation to form machine code and executes the machine code to retrieve the result set from the database. In some cases, the query intermediate representation is optimized prior to compilation.
-
公开(公告)号:US20240126815A1
公开(公告)日:2024-04-18
申请号:US18393517
申请日:2023-12-21
发明人: Ryan Andrew Atallah
IPC分类号: G06F16/9032 , G06F16/901 , G06F16/904 , G06F16/957
CPC分类号: G06F16/90332 , G06F16/9024 , G06F16/9027 , G06F16/904 , G06F16/9577
摘要: A computer system obtains a data model that encodes a data source as a tree of logical tables. Each logical table includes respective data fields of the data source. For each data field in the logical tables, the system automatically assigns a semantic role to the data field based on a concept obtained from a concept graph, a data type of the data field, and data values of the data field. The system determines hierarchies between the data field and other data fields in the data source based on their respective semantic roles. The system validates the data field based on the assigned semantic role and the determined hierarchies. The system displays transformations to clean the data field based on the assigned semantic role. The system transforms data values for the data field according to a user input and updates the logical tables according to the transforming.
-
公开(公告)号:US11853542B2
公开(公告)日:2023-12-26
申请号:US18112437
申请日:2023-02-21
发明人: Jun Kim , Christopher Richard Stolte , Jock Douglas Mackinlay , Robin Stewart , Bora Beran , Justin Talbot , Marc Rueter
IPC分类号: G06F3/0486 , G06F3/04817 , G06F3/0482 , G06F16/26 , G06T11/20 , G06T11/60
CPC分类号: G06F3/0486 , G06F3/0482 , G06F3/04817 , G06F16/26 , G06T11/206 , G06T11/60
摘要: An electronic device displays a chart in accordance with contents of a plurality of shelf regions of a data visualization interface. The chart includes visual marks representing a set of data. The electronic device generates a visual analytic object by applying a first analytic operation to the set of data represented by the visual marks, and displays the visual analytic object superimposed over the chart. The device detects user input to select the displayed visual analytic object and place an icon representing the visual analytic object onto a first shelf region of the plurality of shelf regions. In response to the user input, the electronic device updates content of the first shelf region to include an association with the first analytic operation corresponding to the visual analytic object.
-
公开(公告)号:US11797258B2
公开(公告)日:2023-10-24
申请号:US17142082
申请日:2021-01-05
发明人: Quentin Moy , Gaurav Chandna , Michael Chen
IPC分类号: G06F3/0482 , G06F3/147 , G06F16/438 , G06F3/04845 , H04L65/403
CPC分类号: G06F3/147 , G06F3/0482 , G06F3/04845 , G06F16/438 , H04L65/403 , G06F2203/04803
摘要: A method implements data visualization collaboration. The method displays, for a second user, an interface with a comment pane that displays a first comment text and a first thumbnail image of a data visualization generated according to a first visual specification, from a first user. In response to detecting an input from the second user to select the first thumbnail image, the method generates and displays the data visualization. The method receives, from the second user, input modifying the data visualization, and input specifying a second comment that refers to the data visualization. In response, the method generates a second thumbnail image and a second visual specification corresponding to the modified data visualization, and transmits that information along with the second comment text to the first user.
-
公开(公告)号:US11790182B2
公开(公告)日:2023-10-17
申请号:US17152762
申请日:2021-01-19
发明人: Melanie K. Tory , Vidya R. Setlur
IPC分类号: G06F40/35 , G06F40/289 , G06F16/332 , G06F40/20 , G06F40/30 , G06F40/40 , G06F40/00 , G06F3/0484
CPC分类号: G06F40/35 , G06F16/3329 , G06F40/00 , G06F40/20 , G06F40/289 , G06F40/30 , G06F40/40 , G06F3/0484
摘要: A method uses natural language processing for visual analysis of a dataset by a computer. The computer displays a data visualization based on a dataset retrieved from a database. The computer computes an initial visualization state that includes elements corresponding to data attributes of the data visualization. The computer receives user input to specify a natural language command related to the displayed data visualization. The computer extracts cue phrases from the natural language command. The computer also determines a transitional goal, to transform the data visualization, based on the cue phrases. The computer derives an updated visualization state based on the transitional goal, by applying transitional rules to each element of the initial visualization state. The computer subsequently computes analytical functions associated with the visualization states, thereby creating functional phrases. The computer then updates the data visualization based on the functional phrases.
-
公开(公告)号:US11720230B2
公开(公告)日:2023-08-08
申请号:US17478815
申请日:2021-09-17
发明人: Robin Stewart
IPC分类号: G06F3/0482 , G06F3/04883 , G06T13/80 , G06F3/04845 , G06F3/04842 , G06F3/04847 , G06F40/18
CPC分类号: G06F3/0482 , G06F3/04842 , G06F3/04845 , G06F3/04847 , G06F3/04883 , G06F40/18 , G06T13/80 , G06F2203/04808
摘要: A device displays a chart representing data from a dataset. The chart has a first region displaying labels corresponding to data values of a first data field, a second region displaying labels corresponding to data values of a second data field, and a third region displaying visual marks representing aggregated data corresponding to pairs of data values from the first and second data fields. In response to a user input, the device removes visual marks from the chart. When the input location is the first region, the device removes visual marks in the first chart corresponding to a first data value of the first data field. When the input location is the second region, the device removes visual marks corresponding to a second data value of the second data field. Otherwise, the device removes only one visual mark. This updates the displayed chart.
-
公开(公告)号:US11698903B2
公开(公告)日:2023-07-11
申请号:US17409717
申请日:2021-08-23
发明人: Clark Wildenradt , Arthur Gyldenege
IPC分类号: G06F16/242 , G06F16/22 , G06F16/28
CPC分类号: G06F16/244 , G06F16/221 , G06F16/2282 , G06F16/287
摘要: A method executes at a computing device that includes a display. The device displays a user interface that includes a data flow pane and a calculation pane, the data flow pane including a node/link diagram for a data prep flow. A user selects a node in the diagram, and the device populates affordances in the calculation pane according to data fields of a data set associated with the selected node. A first user input specifies grouping on a first data field, and a second user input specifies an aggregation function on a second data field. In response to the user inputs, for each distinct value of the first data field, the device aggregates corresponding values of the second data field according to the aggregation function. Calculated data values are displayed in the calculation pane. The device saves rows of data displayed in the calculation pane as a new data source.
-
公开(公告)号:US20230037179A1
公开(公告)日:2023-02-02
申请号:US17961843
申请日:2022-10-07
发明人: Jun Kim , Christopher Richard Stolte , Jock Douglas Mackinlay , Ross Thomas Bunker , Bora Beran , Justin Talbot
IPC分类号: G06F16/248 , G06T11/20 , G06F3/0482 , G06F3/04842 , G06F3/04847
摘要: An electronic device displays a chart, which includes a first set of visual marks that represent values derived from a set of data. The device concurrently displays a chart-calculations-options area. The chart-calculations-options area displays a first plurality of options for type of calculation. The device detects user selection of (i) a first option, from the first plurality of options, for type of calculation and (ii) a second option corresponding to a parameter for the selected first option. In response to detecting the user selection, the device visually distinguishes visual marks in a second set of visual marks in the chart. The second set of visual marks is distinct from the first set of visual marks and corresponds to the first option for type of calculation and the second option corresponding to the parameter for the selected first option.
-
公开(公告)号:US20230014484A1
公开(公告)日:2023-01-19
申请号:US17947027
申请日:2022-09-16
发明人: Anushka Anand , Arthur Gyldenege , Brice Johnson
IPC分类号: G06F3/0482 , G06F3/0484
摘要: A computer system concurrently displays a plurality of panes in a user interface. The panes include a first pane that displays a flow diagram having one or more nodes. Each node contains one or more icons. Each icon represents a respective data transformation operation. The panes include a second pane that displays a plurality of data rows and/or data columns for an intermediate dataset corresponding to a user-selected node. The computer system receives a user input, in the first pane, to perform a first data transformation operation at a selected node. In response to receiving the user input, the computer system performs the first data transformation operation. The computer system displays, in the first pane, an additional icon corresponding to the first data transformation operation at the selected node. The computer system updates the second pane in accordance with the first data transformation operation.
-
10.
公开(公告)号:US11301469B2
公开(公告)日:2022-04-12
申请号:US17013439
申请日:2020-09-04
发明人: Michael Schreier , Thomas Neumann , Viktor Leis , Alfons Kemper , Tobias Muehlbauer , Jan Finis
IPC分类号: G06F16/00 , 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.
-
-
-
-
-
-
-
-
-