INLS 623, section 001, Spring 2009
Instructor: Dr. Hemminger

This planned schedule lists the assignments and readings for each of the topics we'll cover. The textbooks for this course are Elmasri, R. & Navathe, S. . Fundamentals of Database Systems, either the 4th (2004) or 5th (2007) edition. Reading, MA: Addison-Wesley, and Ramakrishnan & Gehrke (2003) Database Management Systems, 3rd edition, McGraw-Hill. Unless otherwise stated, the chapters listed in the schedule come from these books. All other readings are available electronically or on reserve in the SILS Information and Technology Resource Center on the first floor of Manning Hall. Readings are listed in the order they should be read. Other readings or assignments may be assigned as appropriate.

Table of Contents

1. Introduction and Database Design 6. XML, DB, IR
2. SQL and MySQL 7. Non-Text Databases
3. DB Tuning  
4. DB Application Development and Internet Applicationsl  
5.Introduction to XML  

 Introduction and Database Design (2 classes)
  

Monday
1/12

Read Ramakrishnan 2.8, 3.8
Exercise 1.

Wednesday
1/14		 Review Exercise 1; introduction to class.

 

SQL and MySQL (5 classes)

Monday
1/19		 Martin Luther King Holiday Day -- NO CLASS
Wednesday
1/21		 SQL and MySQL; Review Elmarsi chapters 8-9, Ramakrishnan chapter 5;
read MySQL tutorial . Read the mysql-getting-started document, and create the tables as described.
Monday
1/26		 Assign A1. Exercise 2 . Set of indivdual MySQL datafiles (example input file) for loading your own copy of MySQL tables for Ramakrishnan 5.3 exercise and assignment. Also Access datafiles for the some of the same exercises are available.
Wednesday
1/28		  
Monday
2/2 		 Exercise 3
Wednesday
2/4 		A1 due. Assign A2

 

Database Tuning and Indexing (4 classes)

Monday
2/9		 Read Ramakrishnan chapters 6.1, 6.2 intro, 6.5 intro, 19.9, 20. Indexing Examples and . Indexing Details.
Wednesday
2/11		 A2 due. Assign A3. In class practice exercise exercise on indexing
Monday
2/16		 Exercise 4 . Query Processing Tree Example
Wednesday
2/18		 The MySQL reference manual chapter on Optimization contains excellent reference material if you're interested in additional practical details about tuning and indexes for MySQL.

 

Database Application Development and Internet Applications (3 classes)

Monday,
2/23		 Read Ramakrishnan chapters 6-7.
Wednesday,
2/25		 Dr. Hemminger will arrive late due to teach CTL course until 1pm. A3 due. Assign A4. PHP examples (relevant to A4) can be found in our php1 directory.
Monday,
3/2 		Exercise 5 (Ramakrishnan p261-263).

 

Introduction to XML (2 classes)

Wednesday,
3/4
Read Elmarsi Chapter 26.1-3; w3schools XML intro
A4 due.
Monday,
3/9		 SPRING BREAK no class
Wednesday,
3/11		 SPRING BREAK no class
Monday,
3/16		 Exercise 6 . Exercise 7b

 

XML, DB, IR (5 classes)

Wednesday,
3/18		 InClassExercise 7. Assign A5. See XML Schema info at w3schools, and class examples,
Read Ramakrishnan chapter 27.1, Elmarsi Chapter 26. Exercise 7b Presentations
Monday,
3/23		 Read Bourett's web pages on XML & Databases, XML Database Links, XML Materials.Exercise 7a
Wednesday,
3/25		 Exercise 7d Start Exercise 7c
Monday
3/30		 Assign A6. Exercise 7c
Wednesday
4/1		 A5 due. A7 Assigned.

 

Non-Text Databases (4 classes)

Monday
4/6		 NO CLASS, Dr H out of town--work on A7 with your team
Wednesday
4/8		 Guest Lecture: Yaxiao Song on OpenVideo
Monday
4/13

A6 due. Preliminary review of Assignment 7.Read chapter 29 Ramakrishnan, chapter 29 Elmarsi.
Exercise 8.
Wednesday,
4/15
Monday,
4/20		 A7 Report Presentations.
Wednesday,
4/22		 A7 Report Presentations.
Monday
4/27		 Wrap-Up, Review, Final Take Home Exam given out. Exam due Monday May 4th, 10am.

 

Return to the top of the page

This page was last modified on August 21, 2008, by Bradley Hemminger. Address questions and comments about this page to him at bmh@ils.unc.edu.
© 2004-present Bradley M. Hemminger