Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
What is a checkpoint? List the operations to be performed by the system when a checkpoint is to be taken. What does the recovery system do if there is a crash?
There is large number of on-line database system exist so there could be hundreds of transactions handled per minute. The log for this kind of database consists of a very large volume of information. A scheme known as checkpoint is employed to limit the volume of log information that has to be handled and processed in the event of a system failure including the loss of volatile information. The checkpoint method is an extra component of the logging scheme.
A checkpoint operation, carried out periodically, copies log information onto stable storage and put the checkpoint marker at that time in the log. For every transaction active at checkpoint their identifiers and their database modification actions. Which at that time are reflected just only in the database buffers, will be propagated to the suitable storage.
Determine if there is a crash, it scans the log in a backward direction from the time of system crash. Basically, all the transaction is added to the undo list. Afterward, if it finds out that a transaction in the undo list has committed, that transaction is removed from the undo list and placed in the redo list. The redo list consists of all the transactions that have to be redone. All transactions which were committed before the checkpoint time require not be considered for the recovery operation. Hence, the overhead of the recovery from a system crash is reduced. Though, in a system that employs the transaction paradigm.
Checkpoint is a technique to minimize the search of the log and the amount of undo and redo needed recovering from a system failure along with loss of volatile storage.
Differance between procedural and non procedural DML? Procedural and non procedural DML Procedural DML exactly what data is require and how to obtain those data. Non procedural
After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab
What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,
QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c
List the string operations supported by SQL? 1) Pattern matching Operation 2) Concatenation 3) Extracting character strings 4) Converting among uppercase and lower cas
Lock Based Protocol A lock is nothing but a mechanism that tells the DBMS whether a particular data item is being used by any transaction for read/write purpose. As there are t
what is cascading? what is rollback cascading? please explain in detail
Software failures : In such cases, a software error abruptly stops the implementation of the current transaction (or all transactions), therefore leading to losing the state of pr
Data Replication "If a relation R has its copies kept at two or more sites, then it is considered replicated". But why do we replicate a relation? There are several advan
Discuss deferred update technique of recovery. What are the advantages? Ans: The deferred update methods do not physically update the database on disk till after a transact
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd