RDBMS_Day6 - RDBMS - Day6 1 Agenda Motivation Transaction...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
RDBMS - Day6
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ER/CORP/CRS/DB07/003 Version No: 2.0 2 Copyright © 2004, Infosys Technologies Ltd Agenda Motivation Transaction Types of Transaction Systems Transaction Properties Requirements for an OLTP system – Integrity – Concurrency Locking Granularity of Locking Intent Locking Deadlock
Background image of page 2
ER/CORP/CRS/DB07/003 Version No: 2.0 3 Copyright © 2004, Infosys Technologies Ltd Motivation The biggest responsibility of the modern day information system is To simulate the manual system, To record every transaction that the organization undertakes, Capture the day-to-day activities in the life cycle of an enterprise and Help the organization to make quick and correct decisions based on the data. Protect the data from unauthorized access. Recovering the data in case of failures.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ER/CORP/CRS/DB07/003 Version No: 2.0 4 Copyright © 2004, Infosys Technologies Ltd Transaction Logical unit of program execution that takes a database from one consistent state to another consistent state
Background image of page 4
ER/CORP/CRS/DB07/003 Version No: 2.0 5 Copyright © 2004, Infosys Technologies Ltd State diagram of a Transaction Active Partially completed Failed Aborte d Committed While executing After the final statement has been executed When normal execution can’t proceed After rolling back and restoration to previous state Afte r successful completion BEGIN
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ER/CORP/CRS/DB07/003 Version No: 2.0 6 Copyright © 2004, Infosys Technologies Ltd Transaction Systems Batch Transaction Processing System On-Line Transaction Processing System Real time Transaction Processing System
Background image of page 6
ER/CORP/CRS/DB07/003 Version No: 2.0 7 Copyright © 2004, Infosys Technologies Ltd Transaction Properties Atomicity Consistency •I s o l a t i o n Durability Atomicity- Transaction management •DBMS keeps track of the old value of a data on which the transaction acts so that, if there is a failure, the old value of the data is restored as though no transaction acted on it ` Consistency-Application programmer •To ensure that the database remains consistent after execution of the transaction Isolation-Concurrency control To ensure concurrent execution of transactions results in a state equivalent to that obtained by sequential execution Durability-Recovery management •To ensure that after successful transaction completion, all updates persist irrespective of system failures
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ER/CORP/CRS/DB07/003 Version No: 2.0 8 Copyright © 2004, Infosys Technologies Ltd Requirements for an OLTP system Integrity Concurrency
Background image of page 8
Integrity
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ER/CORP/CRS/DB07/003 Version No: 2.0 10 Copyright © 2004, Infosys Technologies Ltd Integrity – Refers to : Correctness and completeness of data Validity of individual items Preservation of interrelationships in the DB – Data integrity constraints: Required data Domain integrity Entity integrity Referential integrity To preserve correctness of data, any RDBMS imposes data integrity constraints. These constraints restrict the data values that can be inserted / modified. The constraints commonly found in RDBMSs
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 31

RDBMS_Day6 - RDBMS - Day6 1 Agenda Motivation Transaction...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online