Difference between Deferred update and Immediate update Last Updated : 05 May, 2023 Comments Improve Suggest changes Like Article Like Report 1. Deferred Update: It is a technique for the maintenance of the transaction log files of the DBMS. It is also called NO-UNDO/REDO technique. It is used for the recovery of transaction failures that occur due to power, memory, or OS failures. Whenever any transaction is executed, the updates are not made immediately to the database. They are first recorded on the log file and then those changes are applied once the commit is done. This is called the "Re-doing" process. Once the rollback is done none of the changes are applied to the database and the changes in the log file are also discarded. If the commit is done before crashing the system, then after restarting the system the changes that have been recorded in the log file are thus applied to the database. 2. Immediate Update: It is a technique for the maintenance of the transaction log files of the DBMS. It is also called UNDO/REDO technique. It is used for the recovery of transaction failures that occur due to power, memory, or OS failures. Whenever any transaction is executed, the updates are made directly to the database and the log file is also maintained which contains both old and new values. Once the commit is done, all the changes get stored permanently in the database, and records in the log file are thus discarded. Once rollback is done the old values get restored in the database and all the changes made to the database are also discarded. This is called the "Un-doing" process. If the commit is done before crashing the system, then after restarting the system the changes are stored permanently in the database. Difference between Deferred update and Immediate update: Deferred UpdateImmediate UpdateIn a deferred update, the changes are not applied immediately to the database.In an immediate update, the changes are applied directly to the database.The log file contains all the changes that are to be applied to the database.The log file contains both old as well as new values.In this method once rollback is done all the records of log file are discarded and no changes are applied to the database.In this method once rollback is done the old values are restored to the database using the records of the log file.Concepts of buffering and caching are used in deferred update method.Concept of shadow paging is used in immediate update method.The major disadvantage of this method is that it requires a lot of time for recovery in case of system failure.The major disadvantage of this method is that there are frequent I/O operations while the transaction is active.In this method of recovery, firstly the changes carried out by a transaction on the data are done in the log file and then applied to the database on commit. Here, the maintained record gets discarded on rollback and thus, not applied to the database. In this method of recovery, the database gets directly updated after the changes made by the transaction and the log file keeps the old and new values. In the case of rollback, these records are used to restore old values.FeatureDeferred Update Immediate Update Update timing Updates occur after instruction execution Updates occur during instruction execution Processor speed May be faster: update occurs after instruction execution, allowing for multiple updates to be performed at once May be slower: update occurs during instruction execution, potentially causing the processor to stallComplexity More complex: requires additional instructions or mechanisms to handle updates after instruction execution Less complex: updates occur immediately during instruction execution ConsistencyMay result in temporary inconsistency between data in registers and memory Data in registers and memory are always consistent Flexibility May be more flexible: allows for more complex data manipulations and algorithms Less flexible: immediate updates can limit the range of data manipulations and algorithms that can be performed Comment More infoAdvertise with us Next Article Difference between Deferred update and Immediate update S sakshi17bcs1162 Follow Improve Article Tags : DBMS Difference Between Similar Reads Difference between Early and Delayed Token Release Prerequisite - Token Ring 1. Early Token Release : Sender does not wait for the data packet to complete revolution before releasing the token. Token is released as soon as the data is transmitted. Multiple packets present in the ring. Less reliable than Delayed Token Release. 2. Delayed Token Releas 2 min read Difference between ALTER and UPDATE Command in SQL 1. ALTER Command: ALTER SQL command is a DDL (Data Definition Language) statement. ALTER is used to update the structure of the table in the database (like add, delete, modify the attributes of the tables in the database). Syntax: // add a column to the existing table ALTER TABLE tableName ADD colum 3 min read Difference Between Differential and Derivative Differential and Derivative both are related but they are not the same. The main difference between differential and derivative is that a differential is an infinitesimal change in a variable, while a derivative is a measure of how much the function changes for its input.In this article, we will exp 5 min read Difference Between Sprint, Iteration, and Increment? There are different terminologies used in Agile methodology in a product lifecycle, out of which the evaluation period and duration overall play an important role. This is where Sprint, Iteration, and Increment come into the picture. Development cycles help us to understand what needs fixing before 6 min read Difference between Interrupt and Polling As modern computer systems grow increasingly complex, efficient communication between the CPU and peripheral devices becomes more critical. Devices like keyboards, mouse, printers, and network interfaces require timely interaction with the CPU to ensure smooth operation and user experience. Interrup 3 min read Difference Between Trigger and Procedure in DBMS In Relational Database Management Systems (RDBMS), triggers and procedures are two important elements necessary for data manipulation. Still, there are vast differences between them, although many individuals cannot tell the difference because their uses are quite similar. On the other hand, trigger 5 min read Difference between DDL and TCL Prerequisite – SQL Commands 1 Data Definition Language (DDL) is a set of SQL (Structured Query Language) commands used to create, modify, and delete database objects such as tables, indexes, views, and constraints. DDL statements are used to define the schema or structure of a database, including it 2 min read Difference Between Instant and Instance The terms "instant" and "instance" may appear similar but have distinct meanings and usage. "Instant" is an adjective that refers to a precise moment in time, while "instance" refers to a particular occurrence or example of something.Definition of "Instant""Instant" is an adjective that refers to a 3 min read What is the Difference Between AODV and DSR? Pre-requisites: AODV, DSR Mobile Computing is defined as a computing environment which is mobile and moves along with the user. In this article we will see the difference between AODV and DSR.AODV (Ad-hoc On-Demand Distance Vector)It is a reactive protocol that creates routes between nodes only when 3 min read Difference Between Online and Real-Time Systems In this technology world, we all are using online systems as well as real-time systems, both of these systems are in use for different tasks but sometimes people are confused between the two so let's understand these in detail and also have a look at the advantages and their limitations.What is Onli 5 min read Like