Showing posts from June, 2010

SQL Concepts

Just to refresh my memory, I am going to jot down the following as part of my cheat sheet, so that one glanceover would refresh my memory:
Atomicity: This is the process by which any transaction performed on a DBMS, will not take place (or will be rolled back) in case a part of the transaction fails.
Consistency: Consistency implies that the state of the database would be constant at any period of time. During transactions, the db would move from one consistent phase to another consistent phase. (All the constraints and regulations of the database is maintained)
Isolation: Isolation indicates that every transaction is performed as a seperate action and will not be interdependent on one another. In case of any such dependencies then the transactions will take place in a sequential manner (based on FCFS or some priority based operation)
Durability: This indicates that the database will be robust and will not collapse at any period of time. At frequent time intervals snapshots of…