Efficient Merging of Tabular Data with Post-Processing Compaction

    公开(公告)号:US20250013644A1

    公开(公告)日:2025-01-09

    申请号:US18769269

    申请日:2024-07-10

    Abstract: A method, system, and computer system for performing an operation with respect to a target table are disclosed. The method includes performing first and second jobs, obtaining one or more other resulting files based at least in part on unmatched rows, and obtaining a set of processed files based at least in part on performing a post-processing operation with respect to the set of resulting files. The set of processed files has less files than the set of resulting files. Performing the first job includes determining a set of matching target table files and storing target table information indicating for each of the set of matching target table files, a particular set of rows having matching rows. Performing the second job includes performing a matching action based on matched rows and obtaining the second job resulting file(s).

    Efficient merge of tabular data with deletion indications

    公开(公告)号:US12045220B2

    公开(公告)日:2024-07-23

    申请号:US17895890

    申请日:2022-08-25

    CPC classification number: G06F16/2282 G06F9/4881

    Abstract: A method, system, and computer system for performing an operation with respect to a target table are disclosed. The method includes performing first and second jobs, and persist, in one or more deletion vector files, one or more deletion vectors for corresponding rows of the one or more target table files, and obtaining a resulting table based at least in part on the second job resulting file(s). Performing the first job includes determining a set of matching target table files and storing target table information indicating for each of the set of matching target table files, a particular set of rows having matching rows. Performing the second job includes performing a matching action based on matched rows and one or more deletion of vectors associated with previously removed rows of the matching target table files and obtaining the second job resulting file(s).

    EFFICIENT MERGE OF TABULAR DATA WITH DELETION INDICATIONS

    公开(公告)号:US20240070138A1

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

    申请号:US17895890

    申请日:2022-08-25

    CPC classification number: G06F16/2282 G06F9/4881

    Abstract: A method, system, and computer system for performing an operation with respect to a target table are disclosed. The method includes performing first and second jobs, and persist, in one or more deletion vector files, one or more deletion vectors for corresponding rows of the one or more target table files, and obtaining a resulting table based at least in part on the second job resulting file(s). Performing the first job includes determining a set of matching target table files and storing target table information indicating for each of the set of matching target table files, a particular set of rows having matching rows. Performing the second job includes performing a matching action based on matched rows and one or more deletion of vectors associated with previously removed rows of the matching target table files and obtaining the second job resulting file(s).

    EFFICIENT MERGE OF TABULAR DATA USING MIXING

    公开(公告)号:US20240070155A1

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

    申请号:US17895882

    申请日:2022-08-25

    CPC classification number: G06F16/2456 G06F16/2282

    Abstract: A method, system, and computer system for performing an operation with respect to a target table are disclosed. The method includes performing first and second jobs, and obtaining other resulting files based at least in part on a second set of unmatched rows among the target table and the source table that results from the first set of unmatched rows having been processed in the second job, and obtaining a resulting table based on (i) second job resulting file(s), and (ii) other resulting files. Performing the first job includes determining a set of matching target table files and storing target table information indicating for each of the set of matching target table files, a particular set of rows having matching rows. Performing the second job includes performing a first matching action based on matched rows and a second matching action based on a subset of unmatched rows.

    EFFICIENT MERGE OF TABULAR DATA USING A PROCESSING FILTER

    公开(公告)号:US20240069863A1

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

    申请号:US17895872

    申请日:2022-08-25

    CPC classification number: G06F7/14 G06F16/148 G06F16/16

    Abstract: A method, system, and computer system for performing an operation with respect to a target table are disclosed. The method includes performing first, second and a third jobs, and obtaining a resulting table based at least in part on the second job resulting file(s) and third job resulting file(s). Performing the first job includes determining a set of matching target table files and storing target table information indicating for each of the set of matching target table files, a particular set of rows having matching rows. Performing the second job includes performing a matching action based on matched rows and obtaining the second job resulting file(s). Performing the third job includes determining unmatched rows for target table files and storing the unmatched rows in third job resulting file(s).

Patent Agency Ranking