Thursday, June 21, 2018

Transaction Management

Oh..I transferred funds from my savings account to checking account. But transaction seems to be not completed. what happened?

all-or-none-----ATOMICITY
it is mandatory that funds transfer should preserve the database CONSISTENCY
After successful execution of funds transfer, new balances should persist in my savings and checking account (despite of system failure) - DURABILITY

Collection of operations that performs a single logical function in a database application- TRANSACTION
Ensure atomicity or durability - RECOVERY MANAGER
Detect system failures and restore the database to the state in which it was before failure - FAILURE RECOVERY
Control interaction among concurrent transactions - CONCURRENCY CONTROL MANAGER
CONCURRENCY CONTROL MANAGER + TRANSACTION MANAGER


No comments:

Post a Comment

GEN AI

  Stay Tuned....