
Discuss the pre-requisites of ACID Test for any Transaction Processing System (TPS)
Discuss the pre-requisites of ACID Test for any Transaction Processing System (TPS)
Punch your phone number in the box below
I’II send an OTP on it.
I won’t confide your phone with anyone.
I appreciate your effort.
May I request you to select one of the reasons for purging from below.
Disrespectful or rude towards a person or a group.
Promotes an undisclosed link or product or service.
Not seeking genuine answers .
Vulgar, Obscene, abusive etc..
Not a post on law or business.
Copied from other website or source and pasted here.
Has bad format, grammar, spelling so requires moderatation.
Thank you,
Yours sincerely,
Aaradhika, Thakurani's bestie
I appreciate your effort.
May I request you to select one of the reasons for purging from below.
Disrespectful or rude towards a person or a group.
Promotes an undisclosed link or product or service.
Not seeking genuine answers .
Vulgar, Obscene, abusive etc..
Not a post on law or business.
Copied from other website or source and pasted here.
Has bad format, grammar, spelling so requires moderatation.
Thank you,
Yours sincerely,
Aaradhika, Thakurani's bestie
Discuss the pre-requisites of ACID Test for any Transaction Processing System (TPS)
Discuss the pre-requisites of ACID Test for any Transaction Processing System (TPS)
These are the essential requirements that justify a Transaction Processing System.
Atomicity (In full or Not at all)
This means that either a transaction is completed and recorded in full, or not completed hence not recorded at all. TPS ensures that transactions take place in their entirety.
Example: While withdrawing cash from an ATM machine, two things can happen. First, the transaction may not be complete due to wrong pin, insufficient funds or wrong account selection. Here, the transaction is not complete hence it is not recorded in the system.
Or, the transaction will be complete. The ATM will dispense the correct amount of cash, and the proper account of the user is debited with the amount withdrawn and thus, properly recorded by the system.
Consistency (Rules)
The system consistently follows the rules which are related to a transaction. All of these rules are checked properly by the system before the transaction is completed.
Examples include: Rules like Daily withdrawal limit, Actual account Balance, Correct PIN, etc should be followed to complete a transaction at an ATM machine.
Isolation (Simultaneously & Immediately)
If a transaction is completed, all the relevant entries related to the transaction are automatically processed.
Eg: When the ATM dispenses cash, the relevant user account is simultaneously and immediately debited.
Durability (once done can't be undone)
A TPS system is such that once a transaction is complete, it can not be undone. A user can not undo the transaction after the ATM has dispensed the cash.
Durability also means that once the transaction is completed, a log is generated by the system so that in the event of system crashes, all the entries made by the system can be retrieved from the log.
You marked successfully unsatisfactory answer
My Dear ,
I thank you for marking the answer as satisfactory.
I have noted.
It will be very nice and helpful to our other members (and the answerer too) if you mark your satisfaction level on the grade scale below.
Please feel free to mark any point. I don't share it with anyone. I use it for doing my internal calculations only. I use these calculations to evaluate the service performance of the relevant virtuoso.
Here is the grade scale:
Virtuoso could have given a better solution.
I am satisfied with virtuoso's answer.
An excellent answer I am impressed.
I will ask my next question to this virtuoso only.
Thank you,
Yours sincerely,
Anu, Thakurani's bestie
Check your phone. I have messaged an OTP. It is a 6 digit number. Feed it in the box below
Do you want me to resend the OTP? Yes resend itCheck your phone. I have messaged an OTP. It is a 6 digit number. Feed it in the box below
Do you want me to resend the OTP? Yes resend itCheck your phone. I have messaged an OTP. It is a 5 digit number. Feed it in the box below
Do you want me to resend the OTP? Yes resend itThanks, for confirming your phone number.
You can change it in your profile.Are you a tax professional?
If yes, then you can earn
money through me.
download the mobile app
You have successfully created your diary. You can access it from 'Store/Your Stuff' section.
OK