Interactively building previews of extract, transform, load (ETL) graphs using cached previews of subgraphs

    公开(公告)号:US11841872B2

    公开(公告)日:2023-12-12

    申请号:US17385393

    申请日:2021-07-26

    CPC classification number: G06F16/254 G06F3/0486 G06F16/24552 G06F16/26

    Abstract: Disclosed are some implementations of systems, apparatus, methods and computer program products for executing a process flow represented by a graph or portion thereof using cached subgraphs. A first request to execute a first portion of a process flow is processed, where the first portion of the process flow is represented by a first subgraph of a graph representing the process flow and a final node of the first subgraph corresponds to a set of computer-readable instructions. The first portion of the process flow is executed such that a first output of executing the first portion of the process flow is obtained. The first subgraph is stored in association with the first output in a first cache entry of a cache. A second request to execute a second portion of the process flow is processed, where the second portion of the process flow is represented by a second subgraph of the graph. At least one cache entry for which a corresponding subgraph matches at least a portion of the second subgraph is identified in the cache, where the at least one cache entry includes the first cache entry. The first output is retrieved from the first cache entry, a node of the second subgraph to which the final node of the first subgraph is connected is identified, and the second portion of the process flow is executed by providing the first output as input to the identified node of the second subgraph without executing the set of computer-readable instructions.

    Visual context in dataflows
    2.
    发明授权

    公开(公告)号:US11262898B2

    公开(公告)日:2022-03-01

    申请号:US16670717

    申请日:2019-10-31

    Abstract: Disclosed herein are system, method, and device embodiments for implementing visual context in dataflows. A computing device may display a dataflow representation associated with a transformative process, receive selection of an individual node of the dataflow representation, and determine a visual context associated with the individual node based on a data transformation step associated with the individual node. Further, the computing device may determine a plurality of nodes associated with the visual context, and apply a graphical effect to the individual node and the plurality of nodes, the graphical effect modifying an attribute of the individual node and the plurality of nodes.

    Smart column selection for table operations in data preparation

    公开(公告)号:US11132501B2

    公开(公告)日:2021-09-28

    申请号:US15989982

    申请日:2018-05-25

    Abstract: A computer implemented method of providing suggestions of related columns for a table operation in a data management system is provided. In one embodiment, the method includes storing, by a processor, a table having a plurality of rows and a plurality of columns, metadata associated with the plurality of columns, and data stored within the plurality of rows and the plurality of columns; receiving, by a processor, a table operation selected by a system or user; processing, by a processor, at least one of the data stored in the plurality of columns and the metadata associated with plurality columns based on a type of the selected table operation to determine at least one relationship between at least two columns of the plurality of columns; and generating, by the processor, dialog data that presents the at least one relationship between the at least two columns to a system or user for use in the table operation.

    High-dimensional data management and presentation

    公开(公告)号:US10831757B2

    公开(公告)日:2020-11-10

    申请号:US15885499

    申请日:2018-01-31

    Abstract: An online system manages data by determining relevance of data dimensions to users. The online system determines which data dimensions a user is likely to be interested in. If a user requests to access a data set that includes data of different dimensions, the online system analyzes the dimensions' relevance to the user before providing the data set to the user. The online system provides the data to the user by prioritizing data dimensions that are more relevant to the user. As such, the online system improves the user experience by allowing users to conveniently and quickly locate relevant data and minimizing the distraction caused by irrelevant data. The online system may create and provide a user interface to present data dimensions that are determined to be relevant.

    VISUAL CONTEXT IN DATAFLOWS
    5.
    发明申请

    公开(公告)号:US20210132777A1

    公开(公告)日:2021-05-06

    申请号:US16670717

    申请日:2019-10-31

    Abstract: Disclosed herein are system, method, and device embodiments for implementing visual context in dataflows. A computing device may display a dataflow representation associated with a transformative process, receive selection of an individual node of the dataflow representation, and determine a visual context associated with the individual node based on a data transformation step associated with the individual node. Further, the computing device may determine a plurality of nodes associated with the visual context, and apply a graphical effect to the individual node and the plurality of nodes, the graphical effect modifying an attribute of the individual node and the plurality of nodes.

    HIGH-DIMENSIONAL DATA MANAGEMENT AND PRESENTATION

    公开(公告)号:US20190236191A1

    公开(公告)日:2019-08-01

    申请号:US15885499

    申请日:2018-01-31

    Abstract: An online system manages data by determining relevance of data dimensions to users. The online system determines which data dimensions a user is likely to be interested in. If a user requests to access a data set that includes data of different dimensions, the online system analyzes the dimensions' relevance to the user before providing the data set to the user. The online system provides the data to the user by prioritizing data dimensions that are more relevant to the user. As such, the online system improves the user experience by allowing users to conveniently and quickly locate relevant data and minimizing the distraction caused by irrelevant data. The online system may create and provide a user interface to present data dimensions that are determined to be relevant.

Patent Agency Ranking