...

If I have seen further, it is by standing on ye shoulders of Giants

Isaac Newton

Motivation

One of the major significant features of Apache Ignite 3, as a distributed database, is the ability to execute multiple table operations as a single atomic operation, known as a transaction. We need to design a modern and robust distributed transaction protocol, taking into account considering current best practices. Compared to the previous release, we aim to support transactional SQL from the beginning and remove limitations like the limited size of a transaction.

Definitions

In this section, I'll give some definitions encountered through the text. It can be used to quickly find a definition of a specific term quickly.

Record (aka Row, Tuple, Relation) -a collection of attribute-value pairs.

...

Atomicity - a transaction property which that declares : either that all actions are carried out, or none are.

Consistency - a property which that moves a database from one consistent state to another after finish. A meaning Meaning of the consistent state is defined by a user.

...

Durability - a transaction property which that guarantees that the database state remains unchanged after a transaction is committed, despite any failures.

...