O'Reilly logo

Concepts of Database Management System by Shefali Naik

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required