US 12,277,102 B2
Stream-based transaction processing
Norman May, Baden Wurttemberg (DE); Tiemo Bang, Bad Camberg (DE); and Carsten Binnig, Baden Wurttembreg (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Mar. 5, 2024, as Appl. No. 18/596,482.
Application 18/596,482 is a continuation of application No. 18/051,404, filed on Oct. 31, 2022, granted, now 11,947,517.
Prior Publication US 2024/0211460 A1, Jun. 27, 2024
Int. Cl. G06F 16/23 (2019.01); G06F 9/54 (2006.01); G06F 16/2455 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/2308 (2019.01) [G06F 9/546 (2013.01); G06F 16/24568 (2019.01); G06F 16/256 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
receiving an input comprising type information for a first transaction type and a second transaction type executable on a database, wherein the database comprises a plurality of job components, the plurality of job components configured to form an architecture of the database for executing transactions in parallel;
storing the type information on the database;
receiving a stream of transactions to execute on the database according to an order, wherein the stream of transactions comprises a first transaction of the first transaction type and a second transaction of the second transaction type, wherein the first transaction and the second transaction access at least one table in common in the database, and wherein the order indicates that the first transaction accesses the at least one table in common before the second transaction;
determining that a parallel execution of the first transaction and the second transaction results in a conflict for the at least one table in common; and
in response to the determining the conflict:
performing a first update of the architecture to produce a first updated architecture to execute the first transaction by configuring the plurality of job components based on the first transaction;
executing the first transaction according to the first updated architecture;
in response to completing execution of the first transaction, performing a second update of the first updated architecture to produce a second updated architecture to execute the second transaction by configuring the plurality of job components based on the second transaction; and
executing the second transaction according to the updated architecture.