Transaction Properties : ACID

I've been trying to chakout the ACID, from quite a long time.. and postponing the same, every time i think of it... today, i decided to draft what i mean for ACID

As every one know, ACID means

  • Atomicity
  • Consistent
  • Isolated
  • Durability
This is common from high level understanding, what about in detail? In this post, i'm trying to post all my understanding about these 4 buzz words, correct me if i'm mistaken (or) miss spelled

Atomicity: this is in general talks about the changes or activities that are supposed to be happen in the given transaction. Inother words, all the changes that influence on the resource must happen on a single process or thread or operation, means on any kind of exception, the enitre thread has to be aborted. I recollect some statement from some of MSDN Magazine, "Every thing in the universe stops, the changes are made, and then every thing resumes"

Consistent: means the transaction should be on a crystal clear state of Yes or No, intoher words, Completed or Failed.. Hence the transaction will result in logical state instead of abiguity

Isolated: explains that, none other than the owner is allowed to peek into the process, while executing. Inother words, no other entity is able to see the intermediate state of the resource during the transaction

Durability: tells that, the result of any process should remain constant with the time, inother words, the results of a sucessful transaction are to be persisted

What do you say?

Comments

Post a Comment

Popular posts from this blog

Network Intrusion Detection using Supervised ML technique

Declaimer This is my initial version of the synopsis for PhD studies. There are plenty of things that i have to complete before i prepare the final version. Thus, this would be the alpha version. Due to the length of the blog post, will not be posting the entire draft. 1.Title of the thesis Network Intrusion Detection using Supervised Machine Learning Technique with Feature Selection 2.Introduction Intrusion Detection System, IDS, is a development which improve the network security and defending the information of the association. The IDS encourage the network chairman to recognize any malicious action on the network and alarms the executive to get the information made sure about by taking the appropriate activities against those attacks. An intrusion alludes to any unauthorized access or malicious usage of data assets. An intruder or an attacker is a true element that attempts to discover a way to increase unauthorized access to data, causes hurt or take part in different...
Read more

ASP.NET Page Life Cycle

Image
Most of the ASP.NET developers ignore the page life cycle. They dig only when it is a trouble shooting situation or fixing a bug or as part of a rescue mission. For all those developers, there is an article that explains in detail about ASP.NET v4 page life cycle. Click here to read more in detail. But a picture is worth more than 1000 words. So is this. Isn’t it??
Read more

Is Architecture = Design of the application

Image
Today morning, I’ve attended an interview with one of the prestigious companies of the world. It doesn’t matter what company is that, but all that matters is the significant means of the questions and the replies by me. I can’t post the entire dialogue questions here, but what I can point here is the gist of the interview. The position is for an architect, who would be working extensively for various stages of the project and should also play the managerial role. Isn’t it asking too much for a given role? Well, in Indian companies, there is no real means of Architect. He is just like any other Manager, but doing the technology stuff as well. Anyhow, that’s a different thread of discussion all together, but for the current purpose, let me concentrate on an idle situation, where an Architect is an Architect and manager is manager. The interviewer concentrating on the design guidelines and seeking answers for standard questions. Sometime back I’ve written about the common mistakes that ...
Read more