The invention provides a cross-domain transaction
concurrency control method based on a lake and warehouse fusion architecture, and relates to the technical field of transaction
concurrency control. Each transaction is sent to a lake and warehouse
server, and a global unique mark TID is allocated to each transaction based on a local
clock; according to the cross-domain transaction
concurrency control method based on the lake and warehouse fusion architecture, all transactions of all lake and warehouse servers in the
current time period are sorted to obtain a global sequence, then conflict detection and transaction execution are carried out, and then submission
verification is carried out to obtain a global snapshot table. Local lake and warehouse transactions do not need
wide area network round-trip communication, cross-lake and warehouse transactions only need one round of
wide area network round-trip communication, and the overall communication
delay is reduced by one round. And meanwhile, the transaction division execution based on the time interval also enables the
delay of the transaction to be shared by each transaction within one epoch, so that the average
delay of the transaction is reduced. And the optimistic asynchronous execution and speculation reading strategies are used, so that the data
visibility in the same epoch is improved.