Answer Posted / chinmaya dash
ACID PROPOTIES;-
ACID STANDS FOR-
1)ATOMICITY
2)CONSISTENCY
3)ISOLATION
4)DURABILITY
BEFORE GOING TO ACID PROPOTIES WE MUST KNOW ABOUT
TRANSACTION-
A LOGICAL UNIT OF A WORK IS KNOWN AS TRANSACTION.
WHEN WE TRANSFER ANY DATA FROM ONE PLACE TO ANOTHER PLACE
AT A INTERMIDIATARY STATE IT MAY FAILUARE ,WHICH DATA WE
SEND THAT DATA MAY LOOSE FOR EVER.SO TO AVOID THAT PROBLEM
ACID PROPOTIES IS NEEDED,In computer science, ACID
(atomicity, consistency, isolation, durability) is a set of
properties that guarantee that database transactions are
processed reliably.
ATOMICITY-;IT MEANS ALL OR NOTHING,ALL THE TRANSACTION
PROCESSING MUST BE PERFORMED,OTHERWISE IT WILL NOT
PERFORM.NEVER IT STAY IN INTERMEDIATARY STATE.
CONSISTENCY;-IT MEANS A VALID DATA SHOULD INPUT,IF WE DONOT
INPUT PROPER INPUT THEN WE WILL FIND WRONG OUTPUT.
ISOLATION;- NO'S OF DEVICE WANT TO ACCESS ON SAME DATA,IT
IS IMPOSSIBLE TO ACCESS ON SAME DATA,BY ISOLATION0, IT
DECIDE WHICH DEVICE ACCESS THAT DATA,AT THAT TIME ANOTHER
DEVICES MUST STILL IN THEIR CRITICAL SECTION.
DURABILITY-;WHEN WE PROCESS SOMETHING ,IF THAT TIME POWER
FAILURE THEN ALL DATA WILL BE LOST,SO WE NEED TO RECOVER
THAT DATA.THERE IS TRANSACTION LOG TABLE WHICH DECIDES WHAT
TRANSACTION DONE ON WHICH DATA.OTHERWISE IT IS CALLED
RECOVERY OF DATABASE.
| Is This Answer Correct ? | 29 Yes | 8 No |
Post New Answer View All Answers
What kind of bond does hcl have?
What is the ionic equation for hcl-naoh?
What is the chemical formula for dichromate?
What is acid property in client server environment?
Explain the Tunneling, Encapsulation, and Dialup Phone Line.
Many of the groups of elements in the periodic table have acquired common names. The elements in group ia, with the exception of hydrogen, are called what?
Which is polar hcl or hf?
Do you know what are the services provided by the operating system?
Under what condition will read from a terminal return the value 0?
What are the different client/server processing styles?
the property of water which permits an insect to walk on water?
What is the use of glacial acetic acid?
What is the ph of a solution with a hydronium ion concentration of 1 x 10-8 moles/dm3?
Why do some medications contain hcl?
What is ciprofloxacin hcl used for what type?