CSEN 604 Data Bases II

Course Updates

Expired Announcements

Update method example

Please check the file update.java, it contains an example for the update method

BI teams form

Updated teams Form for BI teams of 3. https://docs.google.com/forms/d/1XLipkLSDk4_Hpr-IjmknNxFN1L0xr43GXwRr-gnoaUI/viewform

Teams submission

Please go to this link and fill the form to submit your teams. ONLY ONE team member should submit the form. Kindly note that the teams are final and can not be changed. https://docs.google.com/forms/d/1v0Y-EEKKuXG2P89kzxuNEvrkWGzgxfDAzjwLOC6bqqA/viewform

Karam's Office Hours

For this week, Karam's office are moved to Thursday.

Office Hours

Karam: Tuesday 2nd & 5th, Karim: Saturday 5th

Midterm content

from lecture 1 to lecture 5 (MultiDim Index + Query Plan) inclusive. Practice assignment for these lectures are considered part of the included material as well.

Clarifications on A1

You are not required to consider duplicates. You are not required to store B+ tree nodes on disk.

Quiz 3

will run in tutorials during the week of April 23d. Quiz on Undo logs.

Quiz 2

on Sat. April 9th last 15 minutes of lecture.

A2 postponed

to April 22nd 11:50PM

Quiz 2 content...

Covers lectures W6: Query Plan, W7: Query Estimation I, and W8: Query Estimation II and practice assignments 4, 5 and 6.

Midterm question 4

I got several complains in relation to material coverage of question 4. To clarify: parts A and C were briefly introduced in lecture 5 part B as far as I can recall. Part B were asking to using an iterator which was primarily the focus of lecture 5B. However, I will take your concerns into consideration and will make the whole question a bonus and distribute its marks on other questions in a way that is most favorite to your overall scores.

A1 milestone 4 deadline

postponed to 18th of March.


Bring calculators with you to midterm.

Textbook link and Quiz content

Because you all tried to download the texbook file within a short period, the dropbox link is temporarily down. Here is a backup: https://drive.google.com/file/d/0B03SaNyIsL_2U2pmMjVrMDl4MWs/view?usp=sharing Regarding quiz, you could get practical questions related to practice assignments 4 to 6 and conceptual questions from lectures 6 to 8. So, the material you did not take its tutorial yet, you won't be asked to solve practical problems on.

Exam info..

CS Exam details: Index Structures: 18/100, Database Algorithms: 20/100, Query Optimization 22/100, Concurrency Control 10/100, Logs and Recovery 10/100 and Transactions 20/100. BI Exam details: Index Structures: 18/100, Database Algorithms: 20/100, Query Optimization 22/100, SQL Authorization 10/100, Logs and Recovery 10/100 and Transactions 20/100.

Saturday lecture slot change

Saturday's, April 16th, lecture is shifted to 5th slot in H13 due to a departmental event. This is a one time change.

A1 deadline

postponed to the 20th of March 11:50PM. This is the last extension you will have.

B+ tree

For the completion of assignment 1 purposes, you can use any open source B+ tree available online. Make sure to include it in your submission for A1 so that your TA can run and test the submission. Include a README with the assignment about how to run your program.

A2 posptoned

to April 18th - 11:50PM.

B+ tree implementation


Tutorials canceled

Tutorials are canceled this week.

ACM Session

Tuesday, February 16th, beginning 8:30 AM, an ACM session will be held in C7.303 to explain basic graph algorithms.