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 is upsizing?
Convert the molecular structure of the hydrocarbon c5h12 into its straight-chain condensed structural formula?
How clients handle the DNS – requests to the failed servers?
What is a dipole moment?
What Network traffic is generated if one call connect on a socket of type SOCK – DGRAM?
What is an oxidizing agent?
Think about the hardware limit on system calls. How can a system designer add additional system call without changing the hardware?
Where is tin obtained?
Which dominates the gasses in the earths atmosphere, making up some 78% of the air by volume?
What is the branch of chemistry that deals with the relationship between electricity and chemical reactions?
Explain how the use of shutdown can improve client performance.
What are all the base services provided by the os in client server environment?
What types of insulators are there?
Convert 673 kelvin into degrees centigrade?
What is the atomic number and what does it tell you about the number of protons in an atom?