CSEN 604 Data Bases II

Course Updates

Expired Announcements

Teams Submission

Please note that the deadline for submitting your teams is Thursday the 27th of February. You will submit them on the met website as a .txt file containing the names of each team member, Id and tutorial.

JDBM open source

Here is the link for the JDBM library you are going to be using in the assignment. Please note that you are only to use the BTree implementation in the library and nothing more that can help with your data storing. http://jdbm.sourceforge.net/

B+ Tree Saving

Please Note that you can use the commit method to save your B+ Tree WITHOUT using anything related to your pages.

A1 due date postponed

To Friday March 21th 11:50PM

Team Number

When submitting your assignment please make sure it is named after your team number, so if you are team13 then your assignment should be named Team13-A1. Good Luck!

Next Week

Please note that there will be no lecture for CS ONLY next week. BI however will have their lecture normally.

Assignment 2 postponed

The deadline for Assignment two has been postponed to Friday the 2nd of May.

Assignment 2 Submission guidelines

You will be submitting a .zip folder named DB_A2 that will have the following files: 1. .txt file that have your team names, group number and Ids 2. A pdf file with all your answers. 3. The script you used to generate the tables for question 3. 4. The tables your generated for question 3 as a .csv files.

Quiz 2

Quiz two will take place next week starting 4th of May during your lecture.

Quiz 3

For those who still didn't take quiz 3, it will be held tomorrow at 2:00 pm SHARP in C6.203.

Exam topics...

Exam has 7 questions as follows: Index Structures (15/100), Result Size Estimation (20/100), I/O Cost Estimation (8/100), Concurrency Control (20/100), Logs & Recovery (20/100), SQL Transactions (10/100), SQL Authorization (7/100)

Course reference

Posted here: https://www.dropbox.com/s/fqv14g1zqhhl6k5/Chaps14-19.pdf

A3 due date postponed...

to June 4th.

Exam aid sheet

posted in materials section.


A3 mark will be used to replace your worst quiz mark. FYI, for assignments and quizzes, we are going to chose best 2 out of 3.

DB Exam...

Exam is comprehensive (includes all material before and after midterm). There will be separate versions for CS and BI - so make sure to take the correct version for you. Exam is closed book, so you are not allowed to bring any form of aid sheet with you. An aid sheet will be provided in the last page of the exam paper. It will contain some but not all important information that you might need to use to answer the questions.

Course items weights...

Exam: 40%, midterm: 25%, Quiz: 15% (best 2 of 3), Assignments: 20% (best 2 of 3).

A3 posted...

due date: may 22nd.

ACM Session

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