Transaction Management and Database Systems

Overview

The purpose of this report is to examine the idea of transaction management and how it relates to two different database systems that I have chosen for the purpose of the project and for may research. I am also looking at the different elements with regard to transaction management and how each of them work and what they are for in the overall scheme that is transaction management.

I will go through the definition of transaction the meaning of transaction how it functions the limitations and restrictions on the access to the user. I delve into the four properties of transactions Atomicity consistency isolation and durability.

We discuss the transaction states and go through all six states partially committed failed rollback aborted committed and terminated.

I will also cover things concurrent execution and serizabilty and then I will detail a brief history of the two databases I have chosen then do an analysis of how Concurrency and Recovery has being implemented by both of these Databases with conclusion at the end with bibliography

Transaction

A transaction is an event that happens within a database and general it enters values or exports them from a database. When we look at a transaction from the point of an operating system than transaction is analogous to processes.

All though there are two classes in a transaction of entering and reading data there are differences between them. When the user reads the information they cannot change the information nor alter it in anyway. But it is a different case when you are entering the information then the exact opposite you alter any table or data.

The Four Properties of Transactions

The four properties of transaction are acid that is atomicity consisten...

... middle of paper ...

...and stored and recorded for the person that is storing in it for whatever reason. Which is an improvement because I knew that databases were important but I didn’t properly understand how much work went in to performing one action in a system from entry to the final stage of the information be stored in a violent medium and then transfer to a more stable server And how databases are usually thought of as not important part of how a system works. But they are and it is

Proven every time you use a website or shop, perform banking and access photos or videos stored on your phone all of these things electronically.

So in closing I would like to say that I’ve learned a lot from this report and gained a profound new understanding of how much databases are connected to daily running of the sites, services, and ordinary things that we take for granted in our daily life.