How Consistency Is Maintained During Transactions
None of the database changes made by a transaction are visible to other sessions until the transaction is committed. In a multi‑user environment, where many transactions may be executing simultaneously, this behavior maintains database consistency. For example, if two transactions are updating the same information in a table, the DBMS must ensure that one transaction's updates are complete before allowing the other to proceed.
Last modified date: 08/28/2024