Last Update was on Tuesday 11 Apr 2017
.
Relational Database Management Systems
Modification Date :Sat May 5 2007.
Dear Students,I may update this page again but it depends a lot on availability of free time. If you need some clarification or need extra information then contact me either personally or through e-mail.
| Topics on RDBMS |
|---|
| Merits of using a DBMS over a file processing system |
| Data Models and Supplimental Reading on them |
| Codd's Rules |
| Concurrency Story |
| Deadlock (Detection, Prevention and Recovery) |
| Timestamp and multiversion schemes of concurrency control |
| Recovery Systems, Log based, Deferred Update Method, |
| Immediate Update Method, Checkpoints |
| Optimistic Scheduling |
| Distributed Database Systems |
| Logical Databases, Data Warehousing, Data Mining, OLAP and OLTP |
| Query Processing and Optimization |
| Past assignments |
| 1 and 2 |
| 3 and 4 |
| 5 and 6 |
| New DBMS Material |
| The Text books for RDBMS |
| Ramakrishna & Geherke - Specially for Relational Algebra, Calculi and QBE |
| Bipin C Desai - QBE |
| Silberschatz, Korth, Sudarshan - almost all other |
| Ramez Elmasri & Shamkant B Navathe - This is the prescribed book so don't neglect. Bit complicated to follow though, Well I am here to guide you. |
| Things which are not here |
| These things are covered in great detail in the class and I could not prepare digital copies of the notes, They may be available later depending on the free time available to me as there are technical things involved like symbols, I can't make it done by any other support staff. |
|