ICS222- Principles of Database Management
Fall 2008
Professor Sharad Mehrotra

Index

• Announcements
• Course Information
• Lecture Notes
• Homeworks and Project
• Exams
• Resources

· Instructor and Office Hours

· Working in Groups

· Grading Policy

· Prerequisites

· Time and Place

· Textbooks

· Electronic Lists

---

Announcements

Mon Oct 6^th : A list of suggested projects has been placed on the web site. Click on the Homework and Projects link to access

Mon Oct 6^th: Your first assignment has also been posted. Click on the Homework and Project link to access.

Lecture Notes

Date	Topic	Notes	Reading: "Implementation"	Reading: "Complete Book"	Additional Reading
9/29-10/1	Introduction& brief intro to key database technologies	brief history of data mgmt Intro. to data mgmt	Chapter 1, 2	Chapter 1, 11	Postgres1.pdf postgres2.pdf,
10/6, 10/8	Record manager	Record-manager			Weaving Relations for Cache Performance Operating System Support for Database Management
10/13- 10/15	Indexing & B-trees, hashing	indexing-basic B-trees	Chapter 3.2, 3.4, 3.5	Chapter 12.2, 12.4, 12.5
10/20, 10/22, 10/27, 10/29	Multidimensional Data Structures	handouts\slides08-extend.ppt			Overview R-tree hybrid tree Gist Knn-search Clustering
11/3	MID TERM	EXAM
11/5, 11/10, 11/12, 11/17	Query Processing	query processing.ppt			Query processing
11/19,11/24,11/26	Query Optimization				query optimizationt
12/1, 12/3, 12/8, 12/9
3/19	FINALS	WEEK	FINALS	WEEK

---

Resources

· Click HERE to log into OTC, a service provided by Gradiance . Check the instructions on how to use the system.

· Major database courses at UCI: ICS184, ICS185, ICS214A, ICS214B, ICS215.

· UCI Calendar (05-06); ICS Instructional Course Offerings.

· Places to find papers: DBLP, ACM Digital Library, ACM SIGMOD Anthology, Google, NEC CiteSeer.