CS522 Advanced  Database  Systems

                                                   Syllabus

                                                  Fall 2009
Course Web page: www.calstatela.edu/faculty/hpguo/Teaching/Fall09/CS522/CS522_f09.html
Lectures: MW:    4:20pm - 6:00pm,   ET A210
Instructor: Huiping Guo
  hpguo@calstatela.edu
  323-343-6673
  ET A325
Office Hours:

Monday:      9:10 -- 9:50am

Tuesday:     9:00 -- 11:40am

Wednesday:   9:10 -- 9:50am        

Course Description: This is an advanced course in the area of database, which focuses on implementation details of a database
management system.  Topics to be covered include file organization, indexing, query evaluation, query optimization,
concurrency control, crash recovery and some other advanced topics such as database security etc.
Course Goals: At the end of the course, students are able to   have a deep understanding of how a DBMS stores data, evaluates and
optimizes queries, and guarantees the ACID properties.
Prerequisites:     CS422 & CS442  
Textbook(s):

 “Database Management System”, 3rd edition  by Raghu Ramakrishnan and Johannes Gehrke   ISBN: 0072465638
Topics: 1. Introduction to DBMS   (ch1)
  2. Data storage  (ch8, 9)
  3. Tree indexes (ch10)
  4. Hash indexes (ch11)
  5. Query evaluation (ch12,14)
  6. External sorting (ch13)
  7. Query optimization (ch15)  
  8. Introduction to transaction management (ch16)  
  9. Concurrency control (ch17)  
  10.Crash recovery (ch18)  
       
Grading Policy:

Homework/Project   30%
Midterm 30%
Final 40%

A          90-100
A-         85-89
B          70-84
C           60-69

 
 
 
Final exam:

Monday,  Dec. 7,      4:30pm - 7:00pm

  
Academic Integrity: Cheating will not be tolerated. Cheating on any assignment or exam will be taken seriously.  All parties involved will
receive a grade of F for the course and be reported to the Academic Senate.