CHAPTER 8

Transaction Management in Database

CHAPTER OBJECTIVES
  • Defining transaction.
  • Understanding transaction properties.
  • Knowing different states of transactions.
  • Understanding concurrent execution of a transaction and problems which occur during concurrent execution.
  • Identifying problem of deadlock.
  • Learning backup and recovery procedure.
  • Understanding importance of security, integrity and authorization in database transaction.
8.1 INTRODUCTION

When the database contains large volume of data, which is shared among many users for reading and writing, it is very important that data is read and updated correctly during the transaction. Transaction should be completed successfully; otherwise, the database will contain inconsistent data.

Get Concepts of Database Management System now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.