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

New handouts: preference queries

This material will be essential for your project #2.

--jc

Raghav and Sakthi Sundar are looking for a teammate

If any of you are interested, please contact them: raghavay@buffalo.edu or sakthisu@buffalo.edu

Erdong Fang is looking for teammates

If any of you needs a teammate, please contact Erdong: erdongfa@buffalo.edu

Last day to resign courses: March 30.

Shravya Bethi is looking for teammates

Shravya Bethi hasn't found a group yet.
If any of you need a teammate, please contact Shravya: shravyab@buffalo.edu


Thanks.

Project #1 materials

Instructions, formats and test cases have been posted on the course web page.

Please post the questions on this blog.

--jc

grading

If you have question about homework prolem 1 and 2, you can come to suxin's office hour( Mon 1-3pm, Thur 3:30 -5:30 pm), if you have any question about homework 3 to 5, you can come to my office hour(Thur 12-2pm).
Zhouhan

fake ids have been sent to you

Hi,
Suxin and I have sent your fake id to your ubmail address. If you haven't received the id, email me or suxin. The grades will be published with your fake id on blog in the near future. You will need to use your id to check your grades.
Zhouhan

Project #1 posted on the course web page

New handouts

on the course web page: Query Processing.

--jc

New items on the course web page

(1) Test #1 reading list

(2) Solutions to homework #1 problems

--jc

HW1 problem1.2 correction

Regarding the problem 1.2, this problem should select the students who have taken both cse531 and cse562 and get better grade in 562 and the students who have taken one of these two courses or who have taken none of them. My previous understanding is wrong. Sorry about this.

Update to homework #1

Please see the course web page for an update to homework #1 (Problem 5).

--jc

About tora

Regarding tora, try follow the instructions on the link Prof. Chomocki provided. When you open the tora, try to create a new connection at  first. The connection provider is Oracle(TNS), user name is your ubit name, password is cse562r1, and choose the databse AOS.buffalo.edu. After you create a connection, use the sql editor to edit your sql, and you can access the tables via zhouhany.student, zhouhany.prereq, zhouhany.course, zhouhany.enroll.
Zhouhan

TOra

During today's lecture I mentioned TOra, a GUI for Oracle. The URL is:
https://wiki.cse.buffalo.edu/services/content/tora

New handouts: Indexing

Copies of slides and handouts on Indexing are available on the course web page.
--jc

Dataset for homework 1

We have set up a small database that you can test question 1 and 2 of homework on. You can get to the tables using the names zhouhany.student, zhouhany.enroll, zhouhany.course and zhouhany.prereq. If you cannot get to these tables, please contact any TA and we will re-grant you the privilege.

office hour

We will hold office hours at Davis 302 at following time slots:

Mon 2pm-3pm

Thur 12pm-2pm

Fri 2pm-3pm

Copies of slides

In addition to the handouts, I have posted copies of slides on the course webpage.

--jc

Placement test

PLACEMENT TEST IN THE FIRST CLASS, January 17.

The test is supposed to check your Java programming skills,