Assignment - 1 Transaction Processing
Assignment - 2 Concurrency Control
Assignment - 3 Database Backup and Recovery
Assignment - 4 Database Security
Assignment - 5 Introduction to Other Databases
Assignment - 6 Relational Algebra
Assignment - 7 Query Processing & Optimization
Popular Posts
-
Serial Schedule Non-Serial Schedule A serial schedule is a sequence of operat...
-
Dirty Read Unrepeatable Read A dirty read problem occurs when one transaction updates a ...
-
Log Based Recovery The most widely used structure for recording database modification is the log. The log is a sequence of log ...
-
Lost Update Uncommitted Data This problem is also known as “Multiple Update...
-
Shadow Paging This technique does not require LOG in single user environment In mult... -
Starvation Deadlock Starvation happens if same transaction is always choosen ...
-
Checkpoints When System failure occurs o We must consult log to determine those transaction that need to be redone and those tra... -
Deferred update Do not physically update the database on disk until after a transaction reaches its commit point; Then updates are r... -
Assignment – 7 Query Processing & optimization Submission Date 30-05-11 Q-1. Explain th...
-
Immediate update technique Database may be updated by some operations of a transaction before the transaction reaches its commit poi...