Multi-table and multi-query transactions in data lakehouses
AssigneeSap SE
InventorsTobias Goetz, Daniel Ritter, Jana Gicheva Makreshanska
Life of this patent
Estimating the term…
Abstract
A transaction which targets an object store employing an open table format (OTF) may be detected by a database execution engine. Next, the database execution engine performs a determination step to determine which OTF enhancement levels to apply to the detected transaction. Then, the database execution engine applies one or more OTF enhancement levels to the transaction based on the determination step. Next, the database execution engine causes the transaction to be processed with the applied one or more OTF enhancement levels. Then, the database execution engine returns a result of the transaction processing to a computing device.
Claims20
A system comprising:
- at least one processor;
- and
- at least one memory storing instructions that, when executed by the at least one processor, cause operations comprising:
- detecting a transaction targeting an object store employing an open table format (OTF);
- determining which one or more OTF enhancements levels of a plurality of OTF enhancement levels to apply to the transaction, wherein the plurality of OTE enhancement levels comprise a first OFF enhancement level, a second OFF enhancement level, and a third OTF enhancement level, each of which comprises a unique set of OFF enhancements;
- applying the one or more OTF enhancement levels to the transaction based on the determining;
- causing the transaction to be processed with the applied one or more OTF enhancement levels;
- and
- returning a result of the transaction processing to a computing device.
A computer-implemented method comprising:
- detecting a transaction targeting an object store employing an open table format (OTF);
- determining which one or more OTF enhancements levels of a plurality of OTF enhancement levels to apply to the transaction, wherein the plurality of OTF enhancement levels comprise a first OFF enhancement level, a second OFF enhancement level, and a third OFF enhancement level, each of which comprises a unique set of OTF enhancements;
- applying the one or more OTF enhancement levels to the transaction based on the determining;
- causing the transaction to be processed with the applied one or more OTF enhancement levels;
- and
- returning a result of the transaction processing to a computing device.
A non-transitory computer readable storage medium storing instructions, which when executed by at least one data processor, result in operations comprising:
- detecting a transaction targeting an object store employing an open table format (OTF);
- determining which one or more OTF enhancements levels of a plurality of OTF enhancement levels to apply to the transaction, wherein the plurality of OTF enhancement levels comprise a first OFF enhancement level, a second OTF enhancement level, and a third OFF enhancement level, each of which comprises a unique set of OTF enhancements;
- applying the one or more OTF enhancement levels to the transaction based on the determining;
- causing the transaction to be processed with the applied one or more OTF enhancement levels;
- and
- returning a result of the transaction processing to a computing device.
Dependencies are inferred from the claim text.