CSEN 604 Data Bases II

Course Updates

Expired Announcements

B+ Trees

For an explanation of B+ Trees, I recommend checking educational youtube channels namely, Douglas Fisher: tinyurl.com/n2soy26

QUIZ 1

Quiz 1 will take place in next week's (28/02 - 05/03) tutorials. Quiz 1 will cover Lectures 1, 2, and 3

ASSIGNMENT TEAMS

Submit your teams at: http://ezy.ninja/teams

Quiz 2

1) Quiz 2 will be held coming week during lecture. 2) BI lecture will be held in regular time on Sunday 2nd (H6) and CS on Monday 1st (H8). 3) No cross attendance is allowed. So, BI must attend with BI and CS with CS. 4) Topic of quiz is query estimation and optimization for logical and physical plans.

Reminder of today lecture for BI...

Will be in H8 fifth slot. Quiz in first 20 minutes.

A1 extended

due date moved from March 12th to March 24th @ 11:50PM.

Course rubric...

For those still asking about it: exam: 40%, midterm: 25%, quiz: 15%, assignments: 20% Will take best 2 of 3 quizzes. No best in assignments.

Exam content for each group...

All of the content taught to each group is included in exam. Thus; - For Berlin students all lectures from 1 to 13 are included in exam - For MET CSEN students, lectures from 1 to 12 are included in exam. - For BI students, lectures from 1 to 11 (till before enforcing serializabilty - slide 42) is included in exam.

A2 deadline...

moved to May 3rd 11:50PM. This is the only extension that will be given.

Exam & office hours...

- I will be conducting office hours from 1PM to 5PM on Wednesday May 20th for material related questions. - CS exam has 6 questions as follows: Index Structures /25, Result Size Estimation /12, IO Cost Estimation /16, Concurrency Control /16, Logs and Recovery /20, and SQL Transaction Modes /11 - BI exam has 6 questions as follows: Index Structures /25, Result Size Estimation /12, IO Cost Estimation 16, Relational Algebra Optimization 16, Logs and Recovery /20, Short Questions /11 - Sample exam from last year + solution posted. - No aid sheet will be provided in your exam. - Sample A2 and quiz 3 answers are already available in materials section Dr. Wael.

Quiz for BI...

This announcement is for BI students only. Your lecture will be in the new regular time: Wednesday 5th slot. Quiz will be conducted in lecture. Location will be announced later in the week.

Midterm...

Midterm covers material from lecture 1 to lecture 5. For lecture 5, only questions about concepts discussed in lecture will be included in the midterm. Sample midterm and solution posted in materials section.

A1 clarification...

1) You are not required to use a parser in A1. Implement the methods in the main class only. Testing will be conducted on those methods so keep the signature unchanged. 2) Do not worry about duplicate handling. 3) You will need to search linearly in the pages of a table if the query involves a column that is not indexed. 4) You should not load all pages at start up. Only indices should be loaded at start up.

Quiz 2...

1) Quiz 2 will be held coming week during lecture. 2) BI lecture will be held in regular time on Sunday 2nd (H6) and CS on Monday 1st (H8). 3) No cross attendance is allowed. So, BI must attend with BI and CS with CS. 4) Topic of quiz is query estimation and optimization for logical and physical plans.

Subsitute lecture for BI...

I will be giving a second substitute lecture for BI about multidimensional indices on Sunday March 8th 5th slot. Location will be announced later.

A1 deadline extended

to Fri. 27th. @ 11:50PM No more extensions will be given.

ACM Session

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

RenewSession