Skillcert 4 Flashcards
What is s transactions
hat encapsulate specific events that the organization wants to track
Yes or not
yes
What is Online Transactional Processing (OLTP)
The work performed by transactional systems
Yes or not
Yes
What are ACID Semantics
Atomicity
consistency
Isolation
accountability
Yes or no
NO
Atomicity
consistency
Isolation
Durability
Atomicity
each transaction is treated as a single unit, which succeeds completely or fails completely. For example, a transaction that involved debiting funds from one account and crediting the same amount to another account must complete both actions. If either action can’t be completed, then the other action must fail.
Yes or not
Yes
Consistency
transactions can only take the data in the database from one valid state to another. To continue the debit and credit example above, the completed state of the transaction must reflect the transfer of funds from one account to the other.
Yes or not
Yes
Isolation
oncurrent transactions cannot interfere with one another, and must result in a consistent database state. For example, while the transaction to transfer funds from one account to another is in-process, another transaction that checks the balance of these accounts must return consistent results - the balance-checking transaction can’t retrieve a value for one account that reflects the balance before the transfer, and a value for the other account that reflects the balance after the transfer.