ADAPTIVE INTERPRETATION AND COMPILATION OF DATABASE QUERIES

    公开(公告)号:US20240134894A1

    公开(公告)日:2024-04-25

    申请号:US18381165

    申请日:2023-10-17

    IPC分类号: G06F16/33 G06F16/23

    摘要: 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.

    Data Preparation Using Semantic Roles
    2.
    发明公开

    公开(公告)号:US20240126815A1

    公开(公告)日:2024-04-18

    申请号:US18393517

    申请日:2023-12-21

    摘要: 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.

    Conversational analytics with data visualization snapshots

    公开(公告)号:US11797258B2

    公开(公告)日:2023-10-24

    申请号:US17142082

    申请日:2021-01-05

    摘要: 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.

    Identifying intent in visual analytical conversations

    公开(公告)号:US11790182B2

    公开(公告)日:2023-10-17

    申请号:US17152762

    申请日:2021-01-19

    摘要: 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.

    Visually defining multi-row table calculations in a data preparation application

    公开(公告)号:US11698903B2

    公开(公告)日:2023-07-11

    申请号:US17409717

    申请日:2021-08-23

    摘要: 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.

    Data Preparation User Interface with Configurable Process Flow Elements

    公开(公告)号:US20230014484A1

    公开(公告)日:2023-01-19

    申请号:US17947027

    申请日:2022-09-16

    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.

    Dynamic rebuilding of query execution trees and reselection of query execution operators

    公开(公告)号:US11301469B2

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

    申请号:US17013439

    申请日:2020-09-04

    摘要: 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.