TABLE DATA PROCESSING USING A CHANGE TRACKING MANAGER

    公开(公告)号:US20240168938A1

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

    申请号:US18427786

    申请日:2024-01-30

    申请人: Snowflake Inc.

    摘要: A system includes one or more processors configured as a change tracking manager, and data storage containing instructions executable by the one or more processors. A table data component of the change tracking manager stores table data for a database in a plurality of partitions. A transaction data component of the change tracking manager generates a change tracking entry based on executing a transaction on the table data. The change tracking entry includes information on at least one modification made to a first table version storing the table data. A change tracking component of the change tracking manager generates a change tracking stream associated with the at least one modification. The change tracking component updates a second table version to include the change tracking stream. The second table version includes modified table data based on completing execution of the transaction on the table data in the first table version.