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

1. Merits of using a DBMS over a file processing system  >>
2. Data Models and Supplimental Reading on them >>
3. Codd's Rules >>
4. Concurrency Story >>
5. Deadlock (Detection, Prevention and Recovery) >>
6. Timestamp and multiversion schemes of concurrency control >>
7. Recovery Systems (Log based, Deferred Update Method, Immediate Update Method, Checkpoints) >>
8. Optimistic Scheduling >>
9. Distributed Database Systems >>
10. Logical Databases, Data Warehousing, Data Mining,  OLAP and OLTP >>
11. Query Processing and Optimization >>
12. Past assignments:  1 and 2, 3 and 4, 5 and 6

1. Ramakrishna & Geherke - Specially for Relational Algebra, Calculi and QBE
2. Bipin C Desai - QBE
3. Silberschatz, Korth, Sudarshan - almost all other
4. 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.

1. Normalization
2. Relational Algebra
3. TD Calculi