Transection Processing System

1
Dev Bhoomi Group of Institutions
Saharanpur

• Class MCA 2nd (2013 - 2015)
• Topics Transection System Concepts .

By Mr Saurabh Chauhan , Mr Mohit Sharma
Mr Jitendra Thakur .
2
WELCOME

• TRANSECTION SYSTEM CONCEPTS

3
CONTENTS

• Introduction
• Operation of transaction
• Properties of transaction
• Transaction system state
• Explanation
• Transaction process system
• Recovery from Transaction Failure
• Types of failure
• Recovery Method
• Example
• Recoverably Schedule
• Example
• Thank you

4
INTRODUCTION

• Collection of operation that from a single
  logical unit of work is called transection
• A transection is a unit of program execution that
  access and possibly obtain various data item

5
OPERATION

• Main operation of transection
• Read (X) -which transfer the data item X from
  the data base to a logical buffer belonging to a
  transection that execute the read operation
• Write (x) -which transfer the data item from the
  logical buffer of the transection that executed
  if write back to the data base

6
PROPERTIES OF TRANSECTION

• Transection have 4 properties likely
• ACID TEST
• Atomicity
• Consistency
• Isolation
• Durability

7
TRANSECTION SYSTEM STATE
8
Explanation

• Active its the initial state ,the transection
  stay in this state while its executed .
• Partially(not permanent save ) committed after
  the final statement has been executed .
• Aborted after the transection has been role
  back and the data base has been restored .
• Committed a transection that complete its
  execution successfully is said to be committed .
• Failed after the discovery that normal
  execution can be longer processed .

9
TRANSECTION PROCESS SYSTEM

• TPS are the system which include large size data
  base and allow many users to use same data base
  concurrently
• Example 1-railway reservation system
• 2-credit card system
• Other similar system is called TPS .

10
RECOVERY FROM TRANSACTION FAILURE

• Computer like any other device to subject to
  failure include power failure disk crash software
  error etc
• In this case the database patterning the database
  is lost

11
TYPES OF FAILURE

• Lose of volatize storage log based recovery ,
  buffered management , check points and pshadaw
  paging techniques.
• Non volatize storage lose hard disk ,magnetic
  disk and tape ,if a failure occur the data is
  used in restoring concept in the data base

12
RECOVERY METHOD

• Cascading recovery (roll back )- a single
  transaction failure follow a series of
  transaction roll back is called cascading roll
  back .
• If T1 is failure then the all series of
  transaction will be failed because hare in this
  ex T3 is depend on T2 and T2 depend on T1.

13
EXAMPLE
Depend
Depend

• T1 T2 T3
• Read (x)
• Read(y)
• Zxy
• Write(z)
• --------------------------------------------------
  ------------
• Read (z)
• Write(z)
• ---------------------------------
• Read(z)

14
RECOVERABLY SCHEDULE

• In this schedule T3 transaction perform only one
  transaction read(z)
• T3 is not dependent to transaction T1 and T2
• All transaction work as a separately .
• Not depend with each others.
• Consider following example .

15
EXAMPLE
Independent

• T1 T2 T3
• Read(x)
• Write(x)
• --------------------------------------------------
  --------------
• Read(x)
• ---------------------------------------------
  Read(x)
• (committed)

Independent
16
(No Transcript)