CSG130: Introduction to Database Systems (Fall 2007)


NEWS

Instructor

Donghui Zhang

Office Hours: M Th 4-5:30pm.
Office: 478WVH
Phone: x2177
Email: donghui AT ccs.neu.edu

Lecture: Thursday 6-9pm. 300RI.

TA

Jian Wen <jarodwen AT ccs.neu.edu>, office hour W 3-6pm, 472WVH.
Tianhua Zheng <tianhua AT ccs.neu.edu> office hour Tu 1-4pm, 472WVH.

Overview

This course covers fundamental topics of database systems. It covers both topics needed for developing (web-)database applications and topics needed to develop a database system itself. As foundations to database design, ER model and relational model will be discussed. To express database queries, relational algebra and SQL will be studied in-depth. From the database internal's side, this course covers storage, indexing, query evaluation and optimization, and transaction management.

Grading

Textbook

Textbook: Database Management Systems, 3rd edition, Ramakrishnan and Gehrke, published by McGraw-Hill Company, ISBN 0-07-246563-8.
TEXTBOOK HOMEPAGE: a very important site you should study. You can download the lecture slides, study sqlplus, etc.

Presentation

You are recommended to give a 10-minute presentation on any database-related stuff. Some examples are: your experience in developing a database application; a recent XML paper; clustering technique in the data-mining field; how to write Java code to deal with Excel data, etc. The idea is that everyone in the class should learn something from your presentation.

Projects

Tentative Schedule

 

Date

Lecture

Quiz & Milestone

Week 1

Sep 6

Chp 1: Introduction

 

Week 2

Sep 13

Chp 6 & 7: Web database application

 

Week 3

Sep 20

Chp 2 & 3: ER model, Relational Model

 

Week 4

Sep 27

Chp 19: Normal forms

 

Week 5

Oct 4

Chp 4: Relational algebra

Quiz 1

Week 6

Oct 11

Chp 5: SQL

 

Week 7

Oct 18

Chp 5: SQL

 

Week 8

Oct 25

Chp 12: Query evaluation, NEUStore

Quiz 2

Week 9

Nov 1

Chp 8, 9, 10, 11: Storage, B+-tree, Hash

 

Week 10

Nov 8

Instructor travel, no class.

 

Week 11

Nov 15

Chp 13 & 15: External sort, Query optimization

Quiz 3

Week 12

Nov 22

Thanksgiving, no class.

 

Week 13

Nov 29

Chp 16 & 17: Transaction Management

 

Week 14

Dec 6

Project demo

 

Final Exam

Dec 13

 

 

Academic Honesty

Northeastern University is committed to the principles of intellectual honesty and integrity. All members of the Northeastern Community are expected to maintain complete honesty in all academic work, presenting only that which is their own work in tests and assignments. If you have any questions regarding the proper attribution of the work of others, contact your professor prior to submitting the work for evaluation.