Yahoo India Web Search

Search results

1. www.geeksforgeeks.org › transaction-in-dbmsTransaction in DBMS - GeeksforGeeks

   www.geeksforgeeks.org › transaction-in-dbms

   • Cached

   Oct 11, 2023 · Learn what a transaction is in DBMS, its operations, states, and properties. A transaction is a set of logically related operations that access and modify the database data with consistency and integrity.

   • Video Duration: 35 min

2. www.javatpoint.com › transactions-in-dbmsTransactions in DBMS - javatpoint

   www.javatpoint.com › transactions-in-dbms

   • Cached

   Learn what transactions are and how they are performed in DBMS with examples and steps. Understand the properties and states of transactions and the difference between DBMS and files system.

3. www.geeksforgeeks.org › concurrency-control-in-dbmsConcurrency Control in DBMS - GeeksforGeeks

   www.geeksforgeeks.org › concurrency-control-in-dbms

   • Cached

   Mar 12, 2024 · Learn how to ensure data consistency and avoid data inconsistency in DBMS with concurrency control. Understand the concepts of transactions, properties of transactions, and concurrency control protocols.

   • Video Duration: 35 min

4. www.w3schools.in › dbms › transactionTransaction in DBMS - W3Schools

   www.w3schools.in › dbms › transaction

   • Cached

   Learn what a transaction is and how it is performed in a database management system (DBMS). Understand the ACID properties of transactions and their implications for database reliability and consistency.

5. www.geeksforgeeks.org › transaction-states-in-dbmsTransaction States in DBMS - GeeksforGeeks

   www.geeksforgeeks.org › transaction-states-in-dbms

   • Cached

   • Active State – When the instructions of the transaction are running then the transaction is in active state. If all the ‘read and write’ operations are performed without any error then it goes to the “partially committed state”; if any instruction fails, it goes to the “failed state”.
   • Partially Committed – After completion of all the read and write operation the changes are made in main memory or local buffer. If the changes are made permanent on the DataBase then the state will change to “committed state” and in case of failure it will go to the “failed state”.
   • Failed State – When any instruction of the transaction fails, it goes to the “failed state” or if failure occurs in making a permanent change of data on Data Base.
   • Aborted State – After having any type of failure the transaction goes from “failed state” to “aborted state” and since in previous states, the changes are only made to local buffer or main memory and hence these changes are deleted or rolled-back.

6. www.javatpoint.com › dbms-transaction-processingDBMS Transaction Processing Concept - javatpoint

   www.javatpoint.com › dbms-transaction-processing

   • Cached

   Following are the main operations of transaction: Read (X): Read operation is used to read the value of X from the database and stores it in a buffer in main memory. Write (X): Write operation is used to write the value back to the database from the buffer.

7. People also ask

   What is transaction in DBMS?

   • Answer: In DBMS, a transaction is a set of logical operations performed to access and modify the contents of the database as per the user’s request. Q.2: What is meant by ACID properties in transactions?

   Transaction in DBMS - GeeksforGeeks

   www.geeksforgeeks.org/transaction-in-dbms/

   See all results for this question

   What are the different states of a transaction concept in DBMS?

   • The various states of a transaction concept in DBMS are listed below: A transaction enters into an active state when the execution process begins. During this state read or write operations can be performed. A transaction goes into the partially committed state after the end of a transaction.

   Transaction Management in DBMS: What are ACID Properties? - Guru99

   www.guru99.com/dbms-transaction-management.html

   See all results for this question

   What is a single logical transaction in DBMS?

   • All types of database access operation which are held between the beginning and end transaction statements are considered as a single logical transaction in DBMS. During the transaction the database is inconsistent. Only once the database is committed the state is changed from one consistent state to another. What is a Database Transaction?

   Transaction Management in DBMS: What are ACID Properties? - Guru99

   www.guru99.com/dbms-transaction-management.html

   See all results for this question

   What is a read-only transaction in DBMS?

   • The transaction concept in DBMS is executed as a single unit. If the database operations do not update the database but only retrieve data, this type of transaction is called a read-only transaction. If the database were in an inconsistent state before a transaction, it would remain in the inconsistent state after the transaction.

   Transaction Management in DBMS: What are ACID Properties? - Guru99

   www.guru99.com/dbms-transaction-management.html

   See all results for this question

8. www.guru99.com › dbms-transaction-managementTransaction Management in DBMS: What are ACID Properties?

   www.guru99.com › dbms-transaction-management

   • Cached

   Jun 28, 2024 · Learn what a database transaction is, how it is executed as a single unit, and what are the ACID properties that ensure its integrity. Explore the different types of transactions based on application areas, timing, actions, and structure, and what is a schedule and serializability.