- For Tuesday December 14th
Read Jim Gray's article. Come to class prepared to discuss it.
Read chapter 22, pages 725 through 765, in DBS.
Exercise 22.1 in chapter 22 of DBS.
Our next and last class is on Tuesday at 1p.
- For Sunday December 12th
Projects due, here's what you need to do:
- Put a tarball with the code, documentation, ERD, and Readme
in ~charliep/courses/homework/dbs-project.
- The Readme should include a file roster and instructions
for using the working setup of your project that you have
provided for me to review. I'll need whatever is appropriate for
your project, a URL, u/p, etc.
- Put a paper copy of the updated documentation (and the
previous marked-up versions) in the slot in the wooden box next
to the pencil sharpener.
- For Monday December 6th
Read chapter 16, pages 519 through 544. Exercises 16.1 and 16.2.
- For Sunday December 5th
First code, documentation, and ERD snapshot due. Please put a tarball
in ~charliep/courses/homework/dbs-project before midnight.
- For Thursday December 2nd
Exercises 12.1, 12.2, and 12.3 in chapter 12 of DBS.
- For Monday November 29th
Read chapter 12, pages 393 through 417 in DBS.
Turn in the third draft of your project document, and the marked-up
copies of your first and second drafts.
- For Monday November 22nd
Indexing lab due. The details are
here.
- For Thursday November 18th
Come to class with questions about the indexing lab (see above) and
storage and indexing generally.
- For Monday November 15th
Turn in the second draft of your project document, and the marked-up
copy of your first draft.
Exercises 8.3, 8.5, and 8.6 in chapter 8 of DBS.
- For Thursday November 11th
Read the rest of chapter 8 in DBS. Use the review questions to check your
comprehension.
Exercises 8.1 and 8.2 in chapter 8 of DBS.
Write-up the first draft of your project document. For people
doing application development (everyone but Dave) this should have a
description of each of the following:
- The general problem area.
- The data model, as an ERD (hand drawn is fine)
- Each of the transactions (e.g. add a customer,
remove a customer, update a customer, add a video, remove a video,
check out a video to a customer, return a video, etc.)
- What you will need to do to test your system
to ensure that it works correctly.
For kernel projects (Dave) you should describe each of the following:
- The bug(s) or feature you plan to pursue.
- What you think will be involved (think data structures and
algorithms).
- What you will need to do to test your changes to ensure that
they work correctly.
- For Thursday November 4th
Read chapter 8, pages 273 through the middle of 291, in DBS.
Write-up a paragraph describing the project you have in mind for this class. If you are thinking of more than one do a paragraph for each.
- For Monday November 1st
Write a simple Perl program that uses DBI/DBD to access your Postgres instance on an ACL machine. The code should an insert, update, delete, and select (of more than one row). Turn-in a printout of the code and a printout of a screen shot when you run it. As usual bonus points for 2-up, 2-sided printing (use the lounge printer).
- For Thursday October 28th
Exercises 7.1 and 7.2. You don't need to turn-in the output from 7.2.4.
- For Monday October 25th
Exercise 6.1
Read chapter 7 in DBMS.
- For Thursday October 21st
Read chapter 6 in DBMS.
- For Monday October 18th
Exercise 5.8, on paper. Postgres does not directly support assertions.
- For Thursday October 14th
Finish reading chapter 5 in DBMS.
Exercises 5.2 (if you didn't finish it already), 5.5, and 5.9.
- For Monday October 11th
Finish reading chapter 5 in DBMS, pages 165 through 174.
Exercise 5.2. You can find a script to create and populate the schema
here.
- For Monday October 4th
Read chapter 5, pages 144 through 165, in DBMS.
Exercise 5.1. You can find a script to create and populate the schema
here.
- For Thursday September 30th
Read chapter 5 in DBMS, pages 130 through 144.
Work through some of the queries (without looking at the books solutions!)
from chapter 5 using your Postgres instance. You can find a script that will
create and populate the tables you need here.
- For Monday September 27th
The Notown Records project, details for the assignment can be found here.
Finish reading chapter 4 (starting from page 116) in DBMS.
Exercises 4.3 and 4.4 (4.3 using only the tuple-relational calculus)
- For Thursday September 23rd
Exercises 4.1, 4.2, and 4.3 (algebra only) from chapter 4 of DBMS.
- For Monday September 20th
Read chapter 4 in DBMS, pages 100 through 116.
- For Thursday September 16th
Exercises 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, and 3.13. 3.13 should be done on
paper (the ERD) and within your Postgres database (using SQL). Turn in the
paper ERD and a print-out of your create statements (tables, views, constraints,
etc.) The easiest way to do this is to store all the commands in a script
like so:
drop table student;
create table student (name varchar(15));
drop table professor;
create table professor (name varchar(15));
Which you can then run from the command line during development and testing.
When you are done you can print it and turn it in. The same script can contain
the insert statements for populating the tables for testing, etc.
- For Monday September 13th
Read chapter 3 in DBMS, pages 57 through 81 and 86 through 92. Make sure
you can answer all of the pertinent review questions.
- For Thursday September 9th
Exercises 2.1, 2.2, 2.5, and 2.6 from chapter 2 of DBMS.
- For Monday September 6th
Read chapter 2 in DBMS, pages 25 through 51. Make sure you can answer all of
the review questions.
- For Thursday September 2nd
Exercises 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, and 1.9 from chapter 1 of DBMS.
- For Monday August 30th
Read chapter 1 in DBMS, pages 3 through 23. Make sure you can answer all of
the review questions.