CS 582 – Database Management System II 


The course Web site is http://www.cs.nmsu.edu/~tson/classes/spring05-582. Please visit the web-site to get the latest announcements.

  • Time and place: TTh, 11:45am - 1:00pm, SH113
  • Final exam: TBA
  • Office hours: TTh, 10:45am – 11:45am, or by appointment. Send email to ask questions.
  • Instructor: Dr. Son Cao Tran, SH 161, 646-1930


Course Content

In this class, we will study several advanced topics in database which were not covered in the first class on database management system (CS482). These topics gear towards the applications of databases rather than the implementation of a database management system. Topics include:

  • Query Optimization
  • Object-oriented database design and query language
  • XML and Web Data
  • Distributed Databases
  • OLAP and Data Mining
  • If time permits, we will study deductive databases, security and internet commerce, and the use of databases in planning

There will be some programming problems and 8-10 written homework (time allowed).

The tentative weekly schedule is as follows:

  • Week 1-2: introduction, review
  • Week 3-4: Querry Opimization
  • Week 4-6: Object oriented database
  • Week 5: Midterm 1
  • Week 7-10: XML and Web Data
  • Week 10: Midterm 2
  • Week 11: Spring break
  • Week 12-13: Distributed Databases
  • Week 14-16: OLAP and Data Mining
  • Week 16: Review, Term’s paper presentation
  • Week 17: Final Exam

Prerequisites

It is assumed that the students are familiar with the basic topics covered in most of the first course in database. This includes: relational algebra, ER design, relational database design, SQL, Database application on the web, basics of query processing, Web design, PHP, etc. Familiarity with UNIX, C, Java, Oracle is necessary.  


Books

  • Databases and Transaction Processing - An Application Oriented Approach (Second Edition). Philip M. Levis, Arthur Bernstein, and Michael Kifer: Addison Wesley, ISBN 0-201-70872-8
  • Papers on advanced topics in database, whenever it deems appropriate

Assignments

There will be around 8 to 10 assignments during the course. Assignments are usually due one week after they are given out. Homework and project are important and weight 25% of your grade. A C grade is unavoidable if you miss all of this part. Use the homework submission and grade checking system at http://www.cs.nmsu.edu/~tson/classes/spring05-582/Submit.html  to submit your homework and check your grade.


Grade

Computed based on the standard scale of 100 points. The components of the final grade will be distributed as follows:

90% up

A

80%-89%

B

70%-79%

C

60%-69%

D

< 60%

F

with the following distribution:
one midterm (30%),
final comprehensive examination (30%),
homework assignments (10%), quizes(5%), term’s paper (10%)  (research papers’ reading and report)

Use the homework submission and grade web site to submit your homework. Late homework will not be allowed. Quiz cannot be made up. 


Class Policy

Students are strongly encouraged to attend class since material covered in class and not present in the textbook will be used in the tests and homework. Withdrawing must be done on time, in accordance with the university calendar.

The grade of I (incomplete) may be given only if you are unable to complete the course due to documented circumstances beyond your control that develop after the last day to withdraw from the course. Appropriate circumstances include illness and death or crisis in your immediate family. Consult the university catalog for regulations regarding the I grade. In no case will an I grade be assigned to avoid a grade of D or F in the course.

If you elect to be graded under the S/U option, you must declare your intention when registering for the course. All work in the class will be graded in a manner identical to that for students choosing the letter grade option. At the end of the semester, your final letter grade in the course will be used to assign either a S or an U. You must achieve a minimum grade of C in order to receive a grade of S.

It is expected that students follow the code of conduct stated in the University Student Handbook. Any violations of the code will result in a grade of F for the course, in addition to any further sanctions imposed by the university. Unless explicitly stated by the instructor, you are assumed to perform the assigned work by yourself, without any external collaboration. Note that a person copying an assignment is guilty of a violation of academic conduct, as is the person from whom the assignment was copied.

If you have or believe you have a disability and would benefit from accommodations, you may wish to self-identify. You can do so by providing documentation to the Office for Services for Students with Disabilities (SSD), located at Garcia Annex Room 102 (phone: 646-6840, TTY 646-1918). If you are already registered with the SSD Office and need accommodations please provide your "Accommodations Memo" from the SSD Office within the first two weeks of class. If you have a condition which may affect your ability to exit safely from the premises in an emergency or which may cause an emergency during class, you are encouraged to discuss this in confidence with the instructor and/or the Coordinator for SSD. Feel free to call Ms. Elva G. Telles, EEO/ADA, Employee Relations Director at 646-3333 with any questions about the Americans with Disabilities Act (ADA) and/or Section 504 of the Rehabilitation Act of 1973. All medical information will be held in strict confidence.



Spring 2005

Last modified: Tue Jan 11 18:35:10 Mountain Standard Time 2005