SQL: Programming Beginners Guide (Step-By-Step SQL, Programming Basics, SQL Programming, SQL Server, Structured Query Language, SQL Course, SQL Development) by Richard Dorsey

Author:Richard Dorsey [Dorsey, Richard]
Language: eng
Format: epub
Published: 2017-04-21T07:00:00+00:00

Transaction properties

The word that you want to remember when you are working with transactions is going to be ACID. This is because of the letters ACID all stand for one of the properties that you can use with SQL.

A: Atomicity: the operations that you place into your equation will give you a favorable result. However, if the equation fails, then the process you have put into place is going to be terminated and any operation done before this is going to be void as everything is going to return to its former state.

C: Consistency: any changes that are made are going to be watched to ensure they are being made correctly in order for that transaction to be considered successful.

I: Isolation: transactions do not have to run together, they can run seperately while remaining transparent from other transactions being made on that data base.

D: Durability: all your transactions should be successful in order to survive, this means that they need to be able to withstand any system failures that may occur.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.