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 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