Multi-database subsetting
    1.
    发明授权

    公开(公告)号:US11636086B1

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

    申请号:US17706278

    申请日:2022-03-28

    申请人: Tonic AI, Inc.

    摘要: Multi-database subsetting includes receiving a set of source tables. It further includes sorting the set of source tables based at least in part on dependency relationships among tables in the set of source tables. It further includes determining a traversal order based at least in part on the sorting of the set of source tables. It further includes executing the traversal order. Executing the traversal order includes visiting a table in the source set of tables according to the determined traversal order and issuing a query to extract a subset of data from the table being visited.

    Virtual foreign keys
    2.
    发明授权

    公开(公告)号:US12130840B2

    公开(公告)日:2024-10-29

    申请号:US18084001

    申请日:2022-12-19

    申请人: Tonic AI, Inc.

    摘要: Generating virtual foreign key relationships includes determining and displaying, in a user interface, a set of candidate foreign keys. It further includes determining and displaying, in the user interface, a set of candidate primary keys. It further includes receiving a request, via the user interface, to generate a virtual foreign key relationship between a selected candidate foreign key and a selected candidate primary key. It further includes in response to receiving the request to generate the virtual foreign key relationship between the selected candidate foreign key and the selected candidate primary key, generating the virtual foreign key relationship at least in part by generating a record for the virtual foreign key relationship.
    Determining a schema for non-relational data includes receiving a document in a first format. It further includes scanning the document and determining, for a field in the document, a corresponding path of the field and a data type of the field. It further includes updating a hybrid schema based at least in part on the determined path and data type of the field in the document.

    VIRTUAL FOREIGN KEYS
    4.
    发明公开

    公开(公告)号:US20230195752A1

    公开(公告)日:2023-06-22

    申请号:US18084001

    申请日:2022-12-19

    申请人: Tonic AI, Inc.

    摘要: Generating virtual foreign key relationships includes determining and displaying, in a user interface, a set of candidate foreign keys. It further includes determining and displaying, in the user interface, a set of candidate primary keys. It further includes receiving a request, via the user interface, to generate a virtual foreign key relationship between a selected candidate foreign key and a selected candidate primary key. It further includes in response to receiving the request to generate the virtual foreign key relationship between the selected candidate foreign key and the selected candidate primary key, generating the virtual foreign key relationship at least in part by generating a record for the virtual foreign key relationship.
    Determining a schema for non-relational data includes receiving a document in a first format. It further includes scanning the document and determining, for a field in the document, a corresponding path of the field and a data type of the field. It further includes updating a hybrid schema based at least in part on the determined path and data type of the field in the document.