UW > iSchool > David Hendry > Course: INFO-340
- - - - -

INFO-340: Database Management and Information Retrieval

What's new?

• 23 Jan: The FINAL EXAM will be held WED, MARCH 14, 1230 in MGH 420.

• 15 Dec: See job prospects for Librarians and Database Admins

• 15 Dec: Welcome to INFO-340! The first class is Jan 4 in MEB 242 at 130.
  
  Here is the syllabus — I will bring copies to the first class
  For the first class, please read chapter 1 from Connolly & Begg.
  
  The class mailing list: info340a_wi07@u.washington.edu (Archive)

Class Topics

What do I read? ~ When is it due? Find out!
Week 1: Overview	Week 1 | Dev Info | About labs | Lab 1
Week 2: Relational Model	Week 2 | Lab 2
Week 3: SQL	Week 3 | subqueries | Lab 3
Week 4: ER Modeling	Week 4 | Lab 4 | DbConnect.java | DbConnectExample.jsp
Week 5: Normalization	Week 5 | Midterm Examples | Lab 5 | DbBaseConnect.java | ZipCode.java | zipcode.jsp
Week 6: Introduction to IR Systems	Class 11 (no slides) | Midterm | Project Lab
Week 7: Documents and Indexing	Week 7 | Lab 7 | src | lucene-core-2.0.0.jar | luke.jar | NetBeans Project |
Week 8: Queries and Matching	Week 8 | Lab 8
Week 9: Evaluation	no slides (see week #8) | Project lab
Week 10: Review	Week 10 | Demo Day Lab !!

Work

A1: Assignment 1 | Additional Resources

A2: Assignment 2 | Data

A3: Assignment 3

A4: Assignment 4 | Data

Project: Social Bookmarking System | UML Parts (Adobe Illustrator)

Resources

• Programming Examples
  Getting started guides and code examples -- used frequently in labs

• DreamHome Database
  This database is used in the textbook. Use it to practice SQL.

• Boat Club Database
  This database is used frequently in class. Use it to practice SQL.

• Links to Technical resources (By Suzi Soroczak and Shaun Kane)
  Some links to technical information on Linux, JSP, JAVA, etc.
  A very good book on Information Retrieval -- available in online form

Readings

• Belew, R.K. (2000). Chapter 1-2 and Chapter 3

• Barroso, L. A., Dean, J., & Holzle, U. (2003 ). Web Search for a Planet: The Google Cluster Architecture. IEEE Micro, 23(2), 22-28. [Available at http://dx.doi.org/10.1109/MM.2003.1196112]

• Baeza-Yates, R. and Ribeiro-Neto, B. (1999). Modern Information Retrieval, Chapter 3. New York: Addison Wesley

  - - - - -