- Nathan Dunn, Huestis 305-C, phone 346-4592, email ndunn@cs.uoregon.edu.
- Dejing Fridays 2-3 or by appointment (I like to talk with students)
- Nathan Wednesdays 3-4.
- The homework will be a combination of written and programming work.
- The Final Project will be due in parts: Part 1 is due November 17 and Part 2 on December 9. We assume that you will work on it individually. If you wish to work in a group, please check with the instructor.
- Students in CIS 551 are expected to do something extra. Students in CIS 451 are encouraged to do it for extra credit.
| Homework Assignments | 40% |
| Test 1 (Nov 3) | 15% |
| Test 2 (Dec 8) | 15% |
| Final Project | 30% |
- (Required) Silberschatz, Korth and Sudarchan Database System Concepts, 5th Edition, McGraw-Hill, 2005. (Available in UO bookstore, 4th edition is ok. text website)
- Ramakrishnan and Gehrke Database Management Systems, 3rd Edition, McGraw-Hill, 2003. (A previous year′s text)
- Elmasri/Navathe, Fundamentals of Database Systems (Third Edition), Addison-Wesley, 2000.
- C. Date, An Introduction to Database Systems (7th edition), Benjamin/Cummings, 2000.
- C. Date with H. Darwen, A Guide to the SQL Standard, 4th Edition, Addison-Wesley, 1997.
- Alan Williamson, Java Servlets By Example, Manning, 1999.
| Week of | Chapter | Description and Slides | Events |
| Sept 26 | 1, 2 | intro, general concepts; relational model | |
| Oct 3 | 2, 3 | relational model (cont′d), SQL | |
| Oct 10 | 3,4,5 | SQL views, complex types, integrity, Datalog | |
| Oct 17 | 6, 7 | E-R model, normal forms | |
| Oct 24 | 7, 9 | normal forms (cont′d), midterm review, Object-based DB | |
| Oct 31 | 10 | XML | Test 1 Thursday, Nov 3 |
| Nov 7 | 12 | Indexes, B+ tree, hashing | |
| Nov 14 | 13, 14 | hashing (cont′d), query processing and optimization | Final Project Part 1: Thu, Nov 17 |
| Nov 21 | 15 | transactions | |
| Nov 28 | 16 | concurrency control, final review on Nov 29, no class on Dec 1 | |
| Dec 5 | finals week; | Test 2 Thurs, Dec 8; Final Project Part 2: Fri, Dec 9 |
- Course news.
- Useful links, primarily offsite.
- Setup your account to run Informix, servlets.
- Setup your account to run PostgreSQL server.
- Assignments
- Tomcat installation and use.
- Allocation of ports.
- Servlet and php examples running on tomcat server. URL′s provided.
- If you want to connect using perl. Don′t know how it′s working
