DATA MODIFICATION IN HYPOTHETICAL PLANNING WITH BRANCHING DELTAS

摘要

A system, medium, and method including receiving a request to initiate a hypothetical transaction at a first logical time including changes made to a actual table and storage of the actual table being represented by a main storage data structure and a delta storage data structure; generating a hypothetical delta storage data structure to include the changes made by the hypothetical transaction, the hypothetical delta storage data structure being separate and distinct from the delta storage data structure; and applying the changes made by the hypothetical transaction included in the hypothetical delta storage data structure to the actual table to obtain a hypothetical result data structure that includes the data of the actual table existing at the first logical time and any changes made by the hypothetical transaction.

主权项

1. A method implemented by a computing system in response to execution of program instructions by a processor of the computing system, the method comprising:
receiving a request to initiate a first hypothetical transaction at a first logical time, the first hypothetical transaction including any changes to one or more actual tables and storage of the actual table being represented by a main storage data structure to store an immutable portion of data of the actual table and a delta storage data structure to store actual changes to the data of the actual table; generating, in response to the request to initiate the first hypothetical transaction, a hypothetical delta storage data structure to include any changes made by the hypothetical transaction, the hypothetical delta storage data structure being separate and distinct from the delta storage data structure; and logically applying the changes made by the first hypothetical transaction included in the hypothetical delta storage data structure to the actual table to obtain a hypothetical result data structure that includes the data of the actual table existing at the first logical time and any changes made by the first hypothetical transaction.