What is system log, Database Management System

Assignment Help:

What is system log?  What are the entries?      

Ans:  The system log that is generally written on stable storage contains the redundant data required to recover from volatile storage failures and as well from errors discovered by the transaction or the database system. System log is as well known as log and has sometimes been called the DBMS journal. It consists of the following entries (also known as log records):

a. [start_transaction, T]: Points out that transaction T has started execution.

b. [write_item, T, X, old_value, new_value]: Points out that transaction T has changed the value of database item X from old_value to new_value.

c. [read_item, T, X]: Points out that transaction T has read the value of database item X.

d. [commit, T]: Points out that transaction T has completed successfully, and affirms that its effect can be committed (recorded permanently) to the database.

e. [abort, T]: Points out that transaction T has been aborted.


Related Discussions:- What is system log

How the one-to-one associations have to be implemented, Discuss how the one...

Discuss how the one-to-one associations have to be implemented. Some of properties of associations can be implemented directly by providing suitable declarations of the data me

Illustration of implementation of inheritance, Illustration of implementati...

Illustration of implementation of inheritance Let us take the illustration of implementation of inheritance. Suppose that we are about to implement the Stack class and by now w

Organic compounds, #question.explain diversity and magnitude of organic com...

#question.explain diversity and magnitude of organic compounds and general properties?

Give an example of operations from the state actions, Give an example of op...

Give an example of operations from the State Actions and Activities. For instance, in bank the activity verify account code and verify password

Pl/SQL, I need solution of the question posted at http://www.expertsmind.c...

I need solution of the question posted at http://www.expertsmind.com/questions/sql-query-for-testing-triggers-and-stored-procedures-30140149.aspx

Relationship between security and integrity, Relationship between Security ...

Relationship between Security and Integrity: Database security usually refers to access, while database integrity refers to avoidance of accidental loss of consistency. But usually

Nested relational model, what is Nested relational model? Explain with exam...

what is Nested relational model? Explain with examples.

Hangman, a method named WonGame that checks each letter in the word is matc...

a method named WonGame that checks each letter in the word is matched by its label

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd