Monday,
Dec. 15, 11:00am: Here
are the averages for all the problem sets:
PS1: 43.4/50
(87%)
PS2: 90.9/100
(91%) PS3:
36.0/40 (90%)
PS4: 36.3/40
(91%) PS5:
61.8/70 (88%) PS6: 38.1/45 (85%)
Sunday, Dec. 7, 5:pm: Solutions
forProblem Set 6 (pdf)
have been updated. I forgot to address the minimum buffer
requirements (3 buffers) for Problem 1, Part b.
Friday, Dec. 5, 12:30 pm:
The second exam will be distributed Wednesday (Dec. 10) after
class and will be due on Friday (Dec. 12) at 5:00 pm. It will
emphasize the material of weeks 6 through 10: information retrieval through transactions. The rules of
referencing materials will be the same as for exam 1. The online
readings posted for class 10/22 (inverted indexes) and class
11/24 (indexing for XML) will be allowed.
You may find the second exam of
COS 425 in fall06 (pdf)
helpful in preparing for our second exam. Most of the
material that our exam is covering was covered on this old exam at the
same level. However, transactions
were not covered on the second exam in COS 425, fall06 but will be
covered in your exam at the level of the class slides for Nov. 26.
Wednesday, Dec. 3, 11:20am: Solutions
for Problem Set 5 are now
available in 3 parts: solutions
to Problems 1 and 3, solution
to Problem 2 (pdf), and solution
to Problem 4 (pdf).
Thursday, Nov. 20, 9:00pm: Problem
set 6 is now available.
Wednesday, Nov. 19. 4:45PM: My
office hours tomorrow and next Thursday (of course, it's Thanksgiving
Day) are canceled. I will hold office hours next Monday, Nov. 24
and Monday, Dec. 1 from 10am to 11am. Thursday office hours
resume on Dec. 4.
Monday, Nov. 17, 12:05 PM:
Errata: the links
to the Announcements, Schedule and Readings and Project pages within the text of
the General Information page
are wrong. Since everyone is submitting the right problem sets, I
believe you are all seeing the correct Schedule and Readings page.
However differences in the Project
Page could be missed. Please be sure you are using the Project Page showing "Computer
Science 597A" and "Fall 2008".
By 5:00 pm Thursday, Nov. 20,
2008 sign up for the day you will present. Instructions are in
the information page.
By 11:55pm on Monday, Nov 24,
2008 send email to me (Professor LaPaugh) giving the citation for and a
link to the paper (or papers) you wish to present. See
details in the information page.
Thursday, Nov. 13, 11:35 PM: Problem
set 5 is now available.
Sunday, Nov. 9 7:00 pm: Errata
for Slide 11 of the slides on constraints
& decomposition: "BCNF" should read"3NF". This is
any obvious typo, but a corrected pdf version of the notes has now
replaced the original (under Oct. 8).
Thursday, Nov. 6:
5:40pm: These
are the reference
materials allowed while taking the first exam:
·class
notes posted on the “Schedule and Readings” page of the
Web site for the course.(Check the
“Schedule and Readings” page for
updates.) ·the
problem set solutions posted on the course Web site, ·your
personal notes and graded problem set submissions, ·the course
textbook: Abraham
Silberschatz, Henry Korth, and S. Sudarshan, Database
System
Concepts, Fifth Edition, McGraw-Hill, 2006. ·the
slides at the textbook web site: http://www.db-book.com/ ·the
errata at the textbook web site: http://www.db-book.com/
No other materials are
allowed. Also,
you are NOT allowed to use online
database interfaces.
3:30 pm: Solutions
for Problem Set 4 are now available. Note that the solutions
contain links to two pdf files showing XQuery Sandbox results.
Wednesday, Nov. 5, 2008, 11:40
am: The first exam will be distributed Monday (Nov.
10) after class and will be due on Wednesday (Nov 12) at the beginning
of class. It will cover the material through topic "XML and the
tree model". You may find the first exam of COS 425 in fall06 (pdf)
helpful in preparing for this exam. Most of the
material that your exam is covering was covered on this old exam at the
same level. A notable exception is functional dependencies,
normal forms, and relation decomposition, which were not covered in COS
425.
Friday, Oct. 31, 2008, 3:19pm: Solutions
for Problem Set 3 are now available.
Thursday, Oct. 23, 9:00am: Today's
office hours are moved to noon-2pm.
Tuesday, Oct. 21, 1:05pm: The
project information page has now been
updated to include details, including sample project
topics. Note that two informal one-on-one discussions with
Professor LaPaugh are required:
During the week of Dec.
1, 2008 meet for 15-20 minutes to
discuss project progress and issues.
After your project report is
submitted andbefore Wed. Jan. 14, 2009, meet for 15-30
minutes for a project demonstration
(where applicable) and discussion.
Monday, Oct. 20, 8:00pm: XML
examples used today are posted on the schedule page under "XML and the
tree model" (10/13 and 10/15).
Friday, Oct. 17, 9:25pm: Problem
Set 4 is now available.
Thursday, Oct. 16, 5:40pm: Summary
of work schedule for the rest of the semester:
PS 4 due Fri 10/24
break week 10/27 - 10/31
proposal due Fri 11/7: this is a one-paragraph email.
Details will be posted.
Test 1 out Mon 11/10; due Wed 11/12
PS 5 due Wed 11/19
PS 6 due Wed 11/26
Thanksgiving 11/27
Students present 12/1, 12/3, 12/8, 12/10 Need to choose
paper and day. Details to come.
Note that two informal one-on-one discussions with
Professor LaPaugh are required: