What is the need of a log in a dbms, Database Management System

Assignment Help:

What is the need of a log in a DBMS? Briefly describe the various types of records that are normally present in a log.          

 Ans:  The system log, which is generally written on stable storage, consists of 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 he DBMS journal. It consists of the following entries (as well 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 the effect of it can be committed (recorded permanently) to the database.

d. [abort, T]: points out that transaction T has been aborted.


Related Discussions:- What is the need of a log in a dbms

Thid, describe objectivde of file organisation

describe objectivde of file organisation

Create table, What are the advantages of creating a table from existing tab...

What are the advantages of creating a table from existing table?

Properties of a transaction , Properties of a Transaction        A tra...

Properties of a Transaction        A transaction has four main properties. These are: Atomicity Consistency Isolation or Independence Durability or Permanen

Improved reliability, Improved Reliability: In a centralised DBMS, a server...

Improved Reliability: In a centralised DBMS, a server failure stops the operations of the DBMS. Though, a failure at single site of a DDBMS, or a failure of a communication link cr

What is conceptual schema, What is Conceptual Schema? Conceptual Schema...

What is Conceptual Schema? Conceptual Schema - Conceptual schema elaborates the structure of the overall database for a community of users. It hides the details of physical sto

Differentiate between a subquery and a join, Differentiate between a subque...

Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t

EER models, Ask question #MinimThe Georgia Tech Library (GTL) has approxima...

Ask question #MinimThe Georgia Tech Library (GTL) has approximately 16,000 members, 100,000 titles, and 250,000 volumes (an average of 2.5 copies per book). About 10 percent of the

What is rdbms, What is RDBMS? Relational Data Base Management Systems (...

What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be formed and

Creating database for library, i need help with creating database system fo...

i need help with creating database system for a library

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