the sign up sheet for demo2

Those of you who haven't signed up for a slot pls come to the TA office, there is a sign up sheet on the door. Each group have up to 30 mins to do the demo. Take the available slots as soon as possible. I am surprised no one shows up for today's  slots. That means there might not be enough slots for those of you haven't present.
Zhouhan

Demo slots for project 2

You can find me during 10-12, 3-5, May 7th and 3-5 May 8th in the TA office area.

562 demos

ALL team members are required to attend the demo of their project. They should be ready to answer questions about the project, in particular about the contribution of each team member.

--jc

office hour change and demo slots for project2

I will change my office hour to wed from 3pm to 5pm.
My demo slots are on the afternoon of May 7th start from 1pm and in the morning of May 8th start from 9am to 12pm, and on May 9th start from 2pm, the place is where I hold office hour.
Zhouhan

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

Surya Kumar and Vignesh Jeyaprakash are looking for a teammate

If any of you is interested, please contact them: suryakum@buffalo.edu

Please post project #1 questions as comments here