INLS 623, Fall 2014 section 001 Schedule

INLS 623, section 001, Fall 2014
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, the 5th (2007) edition or later. Reading, MA: Addison-Wesley (which you should have from DBI), and Ramakrishnan & Gehrke (2003) Database Management Systems, 3rd edition, McGraw-Hill (which can also be found as PDF online). 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 Review	6. XML, DB, IR
2. SQL and MySQL	7. Non-Text Databases
3. DB Indexing and Tuning
4. DB Development on the Internet
5.Introduction to XML

Introduction and Review (2 classes)

Wednesday 8/20	Read Ramakrishnan 2.8, 3.8 Exercise 1.
Monday 8/25	Review Exercise 1; introduction to class.

SQL and MySQL (5 classes)

Wednesday 8/27	SQL and MySQL; Review Ramakrishnan chapter 5; read MySQL tutorial . Read the mysql-getting-started document, and create the tables as described.
Monday 9/1	Labor Day Holiday -- NO CLASS
Wednesday 9/3	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. Practice SQL
Monday 9/8
Wednesday 9/10	Exercise 3
Monday 9/15	A1 due. Assign A2

Database Tuning and Indexing (5 classes)

Wednesday 9/17	Read Ramakrishnan chapters 8, 19.9, and 20. Indexing Examples and . Indexing Details.
Monday 9/22	A2 due. Assign A3. In class practice exercise exercise on indexing
Wednesday 9/24	Exercise 4 . Query Processing Tree Example
Monday 9/29	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. Particularly sections 8.5 "Optimization and Indexes" and 8.8 "Optimizing Database Structures"
Wednesday, 10/1

Database Application Development and Internet Applications (3 classes)

Monday, 10/6	Read Ramakrishnan chapters 6-7, Elmasri chapter 9. A3 due. Assign A4. PHP examples (relevant to A4) can be found in our php1 directory.
Wednesday, 10/8	Exercise 5 (Ramakrishnan p261-263).

Introduction to XML (2 classes)

Monday, 10/13	Read Elmarsi Chapter 26.1-3; w3schools XML intro A4 due.
Wednesday, 10/15	Exercise 6 . Exercise 7.

XML, DB, IR (5 classes)

Monday, 10/20	Assign A5. Read Ramakrishnan chapter 27.1, Elmarsi Chapter 26.
Wednesday, 10/22	InClassExercise XML. See XML Schema info at w3schools, and class examples,
Monday, 10/27	Exercise 8. Read Bourett's web pages on XML & Databases, XML Database Links, XML Materials.
Wednesday, 10/29	Assign A6.
Monday, 11/3 Guest Speaker: Jaya	A5 due. XML-SQL NoSQL Materials. Jayasurya Somasunder Presents NOSQL!
Wednesday 11/5 Guest Speaker: Credit Suisse	Presentation by Database Professionals. Several folks from Credit Suisse will talk about what kinds of database work you might do at a company, what it's like in work force, what the job market is like, and what skills they are looking for in new hires.
Monday 11/10	Exercise 9. In Class Competitive Intelligence Exercise
Wednesday 11/12	Finish off any remaining material/questions on last module (XML,DB,IR). Preliminary review of Assignment 7. A7 Assigned. Exercise 10.

Non-Text Databases (4 classes)

Monday 11/17	A6 due--A6 Presentations. A7 mini-reports due. Read chapter 29 Ramakrishnan, chapter 29 Elmarsi.
Wednesday 11/19
Monday 11/24	A7 Report Presentations
Wednesday 11/26	NO CLASS Thanksgiving break
Monday 12/1	A7 Report Presentations.
Wednesday 12/3	Wrap-Up, Review, complete course reviews ONLINE (you must bring your laptop to class!!), Final Take Home Exam given out. Exam due Wednesday Dec 10th, 10am.

Return to the top of the page