Office Hour Change

Dear all,


I have to change my office hours next week from Apr 30, Monday 1-3 pm to May 1, Tuesday 1-3 pm because of a schedule conflict. I'm sorry for the inconvenience.

Regards,
Suxin

Exam #2: extra credit

Hint: You need to handle overflow/underflow in such a way that 2/3 minimum occupancy is preserved. This means splitting 2 nodes into 3 on overflow (when a neighbor is full) and merging 3 nodes into 2
on underflow (when both neighbors are at their minimum). Special nodes arise in the exceptional cases when split/merge cannot be applied and have to be handled separately.

This is different than in B+trees.

--jc

Report guidelines

Posted on the course web page.

--jc

Scoring functions have to be linear

As pointed out by one of the students, the scoring functions need to be defined by linear arithmetic expressions to guarantee monotonicity.
So they are of the form

c1* A1+....cn*An

where c1,...cn are positive integer coefficients.

A*B where A and B are attributes is not part of the query language.

--jc

Project #2 extra credit dataset

Please consult the course webpage for a real-world (NBA) dataset that you can use in your experiments.
The instructions are also there.

--jc

Project 2 example

http://www.cse.buffalo.edu/~chomicki/562/project2-example.pdf

the office hour today

Hi, I switch my office hour today to 3:30 to 5:30pm, it is just for today. Sorry for the inconvenience.
Zhouhan

New items on the course web page

1. updated project #2 description
2. Transactions slides/handouts

Please post project #2 questions as comments here

the penalty of late submission

As some of you might concern, the penalty of late submission is as follow:
Late submissions will be scored using a graded approach:
Less than 1 day late: reduce the score by 15%
For each additional day, up to 3 days: reduce the score by further 15%
More than 3 days late: not accepted.


It's a good idea if you submit the unfinished version in time and then submit another version. We will give you the maximum grade for the first one and then add credits for second one with the penalty.


Zhouhan

Database design

New slides and handouts have been posted on the course web page.

--jc

submission of project1

In your submission folder pls only include your database package, and name your folder by the ubit names of all members in your team. you may also include a readme file in your submission folder, but it is not required. Then you use the submit_cse562 filename command to submit your project as you did for homework 1. Don't include the junit test code in your submission.
Zhouhan

No office hours today

I will be out of town for the rest of the week.

--jc

Practice problems for test #2

I have made up some practice problems:
http://www.cse.buffalo.edu/~chomicki/562/problems2.pdf

Please let me know if you notice any errors.

There are also many - solved and unsolved - problems in the textbook.

--jc