Schedule
Class slides are available here on the intranet.
|
Date |
Topics |
Related Material |
Text
Book Chapters |
Lecture Notes |
Homework/Quiz/Exam |
|
Jul
26 |
Course introduction |
|
|||
|
Jul 27 |
Evolution of DBMS, Layered view of DBMS |
History of computing blog What goes around comes around |
Ramakrishnan: 1 |
||
|
|
Introduction to ER model | International conference on conceptual modeling |
Ramakrishnan: 2 |
||
|
Aug 2 |
Extended ER features | ER is UML |
|
||
|
Aug 3 |
Introduction to relational model | Codd's 12 rules |
Ramakrishnan: 3 |
||
|
Aug 8 |
No class. Instructor on travel. Make up class
on Aug 11. |
||||
|
Aug 9 |
Relational algebra |
Ramakrishnan: 4 |
|||
|
Aug 10 |
ER to relational conversion | N-ary relationships: What a mess |
Ramakrishnan: 3 |
||
|
Aug 11 (11 am to |
Introduction to SQL | Alternatives to SQL |
Ramakrishnan: 5 |
|
|
|
|
No class. Independence day. Make up class on Aug 18. |
||||
|
Aug 16 |
Relational algebra: practice problems |
|
|
||
|
Aug 17 |
Relational algebra: practice problems | Ramakrishnan: 4 | |||
|
Aug 18 (11 am to |
SQL continued |
Ramakrishnan: 5 |
|||
|
Aug 22 |
SQL continued | ||||
|
Aug 23 |
Introduction to normal forms |
Ramakrishnan: 19 |
|||
|
Aug 24 |
Schema refinement | ||||
|
Aug 25 (11 am to 11:55 am) |
Extra problem solving session | ||||
|
Aug 29 |
Schema normalization | ||||
|
Aug 30 |
Schema normalization | ||||
|
|
No class. Idu'l Fitr. Make up class on Sep 1. |
||||
|
Sep 1 (11 am to |
Schema normalization | ||||
|
Sep 5 |
Schema normalization | ||||
|
Sep 6 |
XML |
|
|||
|
Sep 7 |
XML |
|
|||
|
Sep 12 |
Review session | ||||
|
Sep 13 |
Review session | ||||
|
Sep 14 |
Doubt session |
|
|||
|
Sep 19-23 |
No class. Mid semester exam week. CS344 Exam on Monday, 19 September, 2 pm to 4 pm |
||||
|
Sep 26 |
Mid semester exam paper discussion |
Anand Kulkarni and Sunil Sherif |
|||
|
Sep 27 |
Introduction to physical layer | ||||
|
Sep 28 |
Introduction to file organization and indexing methods | ||||
|
Oct 3-6 |
No class. Dussehra vacation. |
||||
|
Oct 10 |
Indexing continued | ||||
|
Oct 11 |
Indexing continued | ||||
|
Oct 12 |
Bitmap indexing | ||||
| Oct 13 |
Quiz 3 (CSE seminar room, 11 am to 11:30 am) |
||||
|
Oct 17 |
Introduction to query processing | ||||
|
Oct 18 |
Query processing continued | ||||
|
Oct 19 |
Writing your own DBMS | ||||
| Oct 22 | Home work 3 (Lecture hall complex, 2 pm to 6 pm) | ||||
|
Oct 24 |
No class. Instructor on leave. |
|
|||
|
Oct 25 |
No class. Instructor on leave. |
|
|||
|
Oct 26-27 |
No class. Diwali vacation. |
||||
|
Oct 28 (10 am to 10:55 am) |
Hardware Architecture specific challenges and optimizations for DBMS | Tanvi Rai and Nikita Garg | |||
|
Oct 31 |
Query optimization | ||||
|
Nov 1 |
Transaction concurrency control | ||||
|
Nov 2 |
Transaction concurrency control continued | ||||
| Nov 5 |
Home work 4 (Lecture hall complex, 2 pm to 6 pm) |
||||
|
Nov 7 |
No class. Idu'l Zuha vacation. |
||||
|
Nov 8 |
No class. Institute closed. |
|
|||
|
Nov 9 |
Recovery algorithms | ||||
| Nov 12 | Serializability | Ali Hussain Kadar and Sahil Agarwal | |||
|
Nov 14 |
Serializability continued | ||||
|
Nov 15 |
Open issues in DBMS |
Gunjan Kumar and Pasunuri Rahul |
|||
|
Nov 16 |
Review and doubt session | Shailendra Jain and Anubhav Jeph | |||
| Nov 17 |
Quiz 4
(CSE seminar room, 10:30 am to 11:00 am). |
||||
|
Nov 21-26 |
No class. Final exam week. CS344 exam on Monday, 21 November, 1 pm to 4 pm |
||||
| Nov 24 | Evaluated answer books available for student review (5 pm to 8pm). Final grades will be submitted to the academic section on November 25 morning. | ||||
Template adapted with changes from Dr. Kemafor Ogan, North Carolina State University, Raleigh,
NC, USA.