![]() ![]() If all the operations are good, then it goes to a partially committed state, and if it fails, then it enters into a failed state. When the transaction is going well without any error, then this is called an active state. If, in any case, there is a failure before the commit command, then the system will be back into its previous state, and no changes will be there.ĭuring the complete process of a transaction, there are a lot of states which are described below: Active State:.In the end, we will use the commit command, which indicates that the transaction has been successful, and we can store the changes in secondary memory.Now we will read the data of the account2 and add Rs.500 to it.Now we will read the data of account1 and deduct the Rs.500 from the account1.All the account details are in secondary memory so that they will be brought into primary memory for the transaction.If we want to transfer Rs.500 from account1 to account2, then we will commit the transaction. ![]() Let suppose we have two accounts, account1, and account2, with an initial amount as 1000Rs. We can understand the above three states by an example. So, in the same way, we have three steps in the DBMS for a transaction which are the following: Inserting the ATM card into the machine.For example, we withdraw the cash from ATM is an example of a transaction, and it can be done in the following steps: To complete a transaction, we have to follow some steps which make a transaction successful. Logical work can be inserting a new value in the current database, deleting existing values, or updating the current values in the database.įor example, adding a new member to the database of a team is a transaction. TransactionĪny logical work or set of works that are done on the data of a database is known as a transaction. DBMS stands for Database Management System, which is a tool or software that is used for the creation, deletion, or manipulation of the current database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |