Explain ACID rule of thumb for transactions


ACID (an acronymn for Atomicity Consistency Isolation Durability) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a reliable database all this four attributes should be achieved.


Transaction must be 
Atomic - it is one unit of work and does not dependent on previous and following transactions.
Consistent - data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t.
Isolated - no transaction sees the intermediate results of the current transaction.
Durable - the values persist if the data had been committed even if the system crashes right after.


Comments

Post a Comment

Popular posts from this blog

EBITDA

EBITDA - Earnings Before Interest, Taxes, Depreciation, and Amortisation. Interest: the company would have borrowed money. This is the amount it needs to pay back. Taxes: the company owes the government some taxes. Depreciation: the company owns assets. These would differ from industry to industry. But the assets lose value over time. Like say a company car – it would lose its value with time. Companies have machinery, vehicles, computers, and even furniture that lose value with time. Amortization: this refers to the cost of intangible assets like patents, copyrights, etc.
Read more

How to create a bash profile

A typical install of OS X won't create a .bash_profile for you. When you want to run functions from your command line, this is a must have. Start Terminal Type "cd ~/" to go to your home folder Type "touch .bash_profile" to create your new file. Open the file " open -e .bash_profile" . it will open in TextEdit Type ". .bash_profile" or "source ~/.bash_profile" to reload .bash_profile and update any functions you add. You can add functions as below: ANDROID_NDK=/Applications/android-ndk PATH=$ANDROID_NDK:/Application/apache-ant/bin:/Applications/android-sdk/tools:/Applications/android-sdk/platform-tools:~/Library/Application\ Support/Titanium/mobilesdk/osx/2.0.1.GA2:$PATH alias ddms="/Applications/android-sdk/tools/ddms" alias titanium="/Users/jakir.hussain/Library/Application\ Support/Titanium/mobilesdk/osx/2.0.1.GA2/titanium.py"
Read more

__doPostBack Function

Introduction It is quite amazing to note that only two of the ASP.NET web server controls cause a postback. All the other controls use the JavaScript __doPostBack function to trigger the postback. In this article you will learn about the __doPostBack function and how it works. _doPostBack Function The best way to understand the working of the __doPostBack function is to dissect the function into small pieces and explore each piece one at a time. Let us take a look at the function. Listing 1 - _The __doPostBack function function __doPostBack(eventTarget, eventArgument) { if (!theForm.onsubmit || (theForm.onsubmit() != false)) { theForm.__EVENTTARGET.value = eventTarget; theForm.__EVENTARGUMENT.value = eventArgument; theForm.submit(); } } Analysis The __doPostBack function takes two arguments, eventTarget and eventArgument. The eventTarget contains the ID of the control that causes the postback and the eventArgument contains any additional data associated with the control. Note that...
Read more