CS357: Database Systems
Homework Assignment 0 -- Using SimpleDB


Given: Monday, 7 January
Due Date: As Soon as Possible


Every assignment this semester will involve running the SimpleDB database system.  It is therefore essential that you get SimpleDB installed and become comfortable with its use.  Instructions for performing the following tasks can be found in Section 7.3.2, 7.4.1, and 7.6 of the text (or refer to the SimpleDB web page).

1.  Download SimpleDB and install it on your machine.  You should use Java 1.6 if you can.  If you only have Java 1.5 available (e.g. if you are using an Apple computer) then you need to make some minor changes to the code:

2.  Run the SimpleDB server from your machine.  Then run the demo client programs.  (Make sure you run the CreateStudentDB client first.)

3.  If you  know SQL, try running the SQL interpreter client demo. You can figure out the names of the tables and their fields by looking at Figure 1-1 of the text.  Enter some SQL statements and see what happens.  Pay attention to Section 7.6 of the text, which describes the subset of SQL supported by SimpleDB.  What happens when you try to execute an SQL statement that SimpleDB doesn't support?


DO NOT HAND ANYTHING IN.