Discuss properties of a transaction and how they relate to recovery sub-system: [Essay Example], 668 words GradesFixer
exit-popup-close

Haven't found the right essay?

Get an expert to write your essay!

exit-popup-print

Professional writers and researchers

exit-popup-quotes

Sources and citation are provided

exit-popup-clock

3 hour delivery

exit-popup-persone
close
This essay has been submitted by a student. This is not an example of the work written by professional essay writers.

Discuss Properties of a Transaction and How They Relate to Recovery Sub-system

Download Print

Pssst… we can write an original essay just for you.

Any subject. Any type of essay.

We’ll even meet a 3-hour deadline.

Get your price

121 writers online

blank-ico
Download PDF

Atomicity

The atomicity property requires that all operations of a transaction should be completed if not, the transaction will be terminated. A transaction is considered as one. Therefore, it must execute and complete each operation in its logic before it commits changes. The atomicity property of a transaction is ensured by the transaction recovery subsystem of a DBMS. If a transaction fails to complete for some reason such as a system crash during a transaction execution, the recovery techniques undo any effects of the transaction on the database (Singh, S., 2010)

When a database recovers from a crash, it should:

  • Check the states of all the transactions which were being executed
  • Check whether the transaction can be completed during that moment or if it requires to be rolled back
  • If a transaction is in the middle of a certain operation, the DBMS must ensure the atomicity of the transaction
  • • Ensure that no transaction leaves the DBMS in an inconsistent state.

There are two types of techniques, which can help a DBMS in recovering as well as maintaining the atomicity of a transaction:

  • Maintaining the logs of each transaction and writing them onto some stable storage before modifying the database.
  • Maintaining shadow paging, where the changes are done on a volatile memory, and later, the actual database is updated.

Consistency

Execution of a transaction must leave a database in either its prior stable state or a new stable state that reflects the new updates made by the transaction. If the transaction fails, the database must be returned to the state it was in prior to the execution of the failed transaction. If the transaction commits, the database must reflect the new changes. Therefore, all resources are always in a consistent state. The consistency of a DBMS is the responsibility of both the DBMS and the application developers. The DBMS can ensure consistency by putting into effect all the constraints that have been particularly on the database schema such as integrity and enterprise constraints. The log component of the recovery sub-system stores the information needed to undo the updates performed by a transaction in case it must be rolled back, either to an internal save point or to the beginning. (Liu, L., M. Tamer Ozsu, 2009)

Isolation

Isolation property of a transaction means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed. Therefore, this property isolates transactions from one another. If a transaction is using a particular data item, that data cannot be accessed by another transaction.

The isolation property is enforced by the concurrency control subsystem of the DBMS which is meant to coordinate simultaneous transactions while preserving data integrity. At the end of a transaction, either the transaction will complete successfully or not. If the transaction completed successfully, the state of the database will have changed, and the system log will have a record of the activities done. If the transaction will have failed, the database will not have changed and therefore the recovery-subsystem will use the system log to roll back and recover from any changes attempted by the transaction.

Durability

The durability property of a transaction shows the performance of a database. Changes made by a transaction are permanent. They cannot be lost by a faulty transaction nor system failure. When a transaction is completed, the database reaches a consistent state and that state cannot be lost, even if a system failure occurs. The recovery sub-system stores the content within the DBMS and ensures that the data cannot obscure.

Concurrency Control

Deadlock – A system is deadlocked if there is a set of transactions such that every transaction in the set is waiting for another transaction in the set.
Neither transaction can continue because each transaction in the set is on a waiting sequence, waiting for one of the other transactions in the set to release the lock on an item.

Remember: This is just a sample from a fellow student.

Your time is important. Let us write you an essay from scratch

100% plagiarism free

Sources and citations are provided

Find Free Essays

We provide you with original essay samples, perfect formatting and styling

Cite this Essay

To export a reference to this article please select a referencing style below:

GradesFixer. (2018). Discuss properties of a transaction and how they relate to recovery sub-system. Retrived from https://gradesfixer.com/free-essay-examples/discuss-properties-of-a-transaction-and-how-they-relate-to-recovery-sub-system/
GradesFixer. "Discuss properties of a transaction and how they relate to recovery sub-system." GradesFixer, 08 Oct. 2018, https://gradesfixer.com/free-essay-examples/discuss-properties-of-a-transaction-and-how-they-relate-to-recovery-sub-system/
GradesFixer, 2018. Discuss properties of a transaction and how they relate to recovery sub-system. [online] Available at: <https://gradesfixer.com/free-essay-examples/discuss-properties-of-a-transaction-and-how-they-relate-to-recovery-sub-system/> [Accessed 19 September 2020].
GradesFixer. Discuss properties of a transaction and how they relate to recovery sub-system [Internet]. GradesFixer; 2018 [cited 2018 October 08]. Available from: https://gradesfixer.com/free-essay-examples/discuss-properties-of-a-transaction-and-how-they-relate-to-recovery-sub-system/
copy to clipboard
close

Sorry, copying is not allowed on our website. If you’d like this or any other sample, we’ll happily email it to you.

    By clicking “Send”, you agree to our Terms of service and Privacy statement. We will occasionally send you account related emails.

    close

    Attention! this essay is not unique. You can get 100% plagiarism FREE essay in 30sec

    Recieve 100% plagiarism-Free paper just for 4.99$ on email
    get unique paper
    *Public papers are open and may contain not unique content
    download public sample
    close

    Sorry, we cannot unicalize this essay. You can order Unique paper and our professionals Rewrite it for you

    close

    Thanks!

    Your essay sample has been sent.

    Want us to write one just for you? We can custom edit this essay into an original, 100% plagiarism free essay.

    thanks-icon Order now
    boy

    Hi there!

    Are you interested in getting a customized paper?

    Check it out!
    Having trouble finding the perfect essay? We’ve got you covered. Hire a writer

    GradesFixer.com uses cookies. By continuing we’ll assume you board with our cookie policy.