What are the various states of transaction process, Database Management System

Assignment Help:

What are the various states through which a transaction passes through in its lifetime?  Briefly discuss all the events that causes transition from one state to another.  

Ans:   A transaction can be referred to be an atomic operation by the user, but in fact it goes through a number of states during its lifetime as given as follows: 

a. Active, the initial state; the transaction stays in this state when it is executing

b. Partially Committed, later than the initial statement has been executed

c. Failed, later than the discovery that normal execution can no longer proceed

d. Aborted, later than the transaction has been rolled back and the database has been restored to its state prior to the beginning of the transaction

e. Committed, after successful completion.

2156_What are the various states of Transaction Process.png

It is supposed that before a transaction starts, the database is in a consistent state. A transaction starts while the first statement of the transaction is executed; it becomes active. Afterward any outcome, the database will be referred in consistent state.


Related Discussions:- What are the various states of transaction process

What is a candidate key, What is a candidate key? Minimal super keys ar...

What is a candidate key? Minimal super keys are known as candidate keys.

MULTI-LIST FILE ORGANIZATION, sir, could anybody help me in getting complet...

sir, could anybody help me in getting complete information about the mentioned topic

Develop a team database, I need a professional to prepare a database to co...

I need a professional to prepare a database to collect and store basic information. The information can be basic info such as contact details etc. One requirement i have is f

Sql, Events4Fun is an event management company in Europe with branches in S...

Events4Fun is an event management company in Europe with branches in South America as well. The company is well-known for its efficiency, good-quality services, and affordable char

Assignment topic, assume we have the following apllicationthat model sccer ...

assume we have the following apllicationthat model sccer team the games they play and the players inv each teamin the design we want to capture

Data mining, 1.Why we need data mining? Give an example to illustrate your ...

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

Describe the basic steps involved in recovery, Question: One of the tas...

Question: One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known

Organize the clients from email marketing, Function requirement as given: ...

Function requirement as given: 1> manage fans and likes and followings those information from facebook. twitter. google+ and linkedin etc 2> Organize the clients from email m

Search the name department number and salary of employees , Example : Searc...

Example : Search the name, department number and salary of employees drawing minimum salary in that department. SELECT ENAME, SAL, DEPTNO  FROM EMP WHERE SAL IN (SELECT MI

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd