Logless atomic data movement

A system for log-less atomic data movement in a unified table database architecture comprising:

• at least one processor;
• a multi-level storage architecture including a first level storage structure to store incoming data requests in a logical row format as data records and a second level storage structure to encode and store the data records in a logical column format;
• and
• at least one non-transitory machine-readable medium storing instructions that, when executed by the at least one processor, cause the at least one processor to perform operations comprising:
• starting a transaction within the multi-level storage architecture, an internal transaction to move data from the first level storage structure to the second level storage structure;
• reading committed data from the first level storage structure as specified by the internal transaction;
• inserting the committed data from the first level storage structure into the second level storage structure in a bulk insertion process;
• and
• committing the internal transaction to the multi-level storage architecture, when the committed data has been inserted into the second level storage structure.

A computer-implemented method of log-less atomic data movement in a unified table database architecture, the computer-implemented method performed by an in-memory computing system, the method comprising:

• merging, by the in-memory computing system, data from a first level storage structure to a second level storage structure of a multi-level storage database architecture, the first level storage structure configured to store incoming data requests in a logical row format and the second level storage structure configured to encode and store the data records in a logical column format;
• designating, by the in-memory computing system, committed data and non-committed data in the first level storage structure;
• reading, by the in-memory computing system, the committed data from the first level storage structure as specified by the merge;
• inserting, by the in-memory computing system, the committed data from the first level storage structure into the second level storage structure in a bulk insertion process;
• designating, by the in-memory computing system, the committed data in the multi-level storage architecture for deletion from the first level storage;
• and
• committing, by the in-memory computing system, the merged data to the multi-level storage architecture, when the committed data has been inserted into the second level storage structure.