Data integrity is a core feature of a database. The promise: It doesn’t only allow structured queries (> SQL) but also represents a logically consistent data-state at any given point in time. Transactions help to bundle changes into atomic operations (though they might take hours to complete). On commit, a range of conditions can be checked to guarantee the integrity of the internal structure.