logo
 
Syllabus
CS 6800 - Advanced Database Management Systems
Utah State University
Home
Calendar
Homework   
Syllabus
Resources
People

Course Location

Tu-Th 9:00-10:15, Hunstman Hall 380

Course Web Site

http://cs.usu.edu/people/CurtisDyreson/teaching/databases/201

Teacher Contact Details

Assistant Professor Curtis Dyreson
Office: Main 402A
Phone number: 797-0742
E-mail: Curtis.Dyreson at usu dot edu Office Hours: Tuesday and Thursday at 8:15-8:50AM and 10:15-11:00AM or by appt. via e-mail

Course Background

This course is an advanced study of
  • non-relational data models,
  • the internals of a database management system,
  • and database frontiers.

Course Objectives

This course will help students to achieve the following objectives.
  • Learn new ways to query and model data.
  • Become familiar with the expanding role of database technology.

Text

Elmasri and Navathe, Fundamentals of Database Systems, 7th Edition, Addison Wesley

Additional Reading

Other papers will be either handed out in class.

Course Prerequisites

The course prerequisite is CS5800, or permission from the instructor. If you do not meet these prerequisites, you MUST come and talk with the teacher in the first week of class. The teacher reserves the right to drop you from the course if it becomes obvious that you do not meet the prerequisites.

Course Requirements

Students are responsible for attending lecture. Lecture notes will be posted on-line. Students are also expected to participate in class discussions to a reasonable extent. The teacher reserves the right to lower the grade of any student who is deficient in attendance and/or participation.

Homework, Assignments, and Tests

There will be one mid-term exam and one final examination. The final will be comprehensive. There will be several homework assignments given out, mainly involving programming and exercises from the book. Finally, there will be five discussions. Each discussion will cover material in a paper that is handed out in class.

The following allocation of grade percentages is tentative, and may change during the semester.


Exams (2): 40% (15, 25)
Discussions (5): 10%
Homework (8): 50%

Cheating Policy

Exams, homework, and programming projects are subject to the CS Department policy on academic integrity. DO NOT CHEAT IN ANY WAY: DO YOUR OWN WORK! Side effects of cheating can be severe, and may include expulsion from the university.

Grading Policy

All grading will generally be marked within a week of the due date and returned to students in lecture. Additionally, some grades will be sent via e-mail. Assessment may be resubmitted for re-grading no later than one week after the assessment is returned. This is the only window of opportunity for re-grading. In order to submit a piece of assessment for re-grading, write or type a detailed explanation of the reasons for the re-grading. Then submit the re-grading to the professor.

Withdrawal Policy

Students are required to complete all courses for which they are registered by the end of the semester. In some cases, a student may be unable to complete all of the coursework because of extenuating circumstances, but not due to poor performance or to retain financial aid. The term extenuating circumstances includes:
  • incapacitating illness which prevents a student from attending classes for a minimum period of two weeks,
  • a death in the immediate family,
  • financial responsibilities requiring a student to alter a work schedule to secure employment,
  • change in work schedule as required by an employer, or
  • other emergencies deemed appropriate by the instructor.

Students with Disabilities

Students with ADA-documented physical, sensory, emotional or medical impairments may be eligible for reasonable accommodations. Veterans may also be eligible for services. All accommodations are coordinated through the Disability Resource Center (www.usu.edu/drc) in Room 101 of the University Inn, (435)797-2444 voice, (435)797-0740 TTY, or toll free at 1-800-259-2966. Please contact the Disability Resource Center as early in the semester as possible. Alternate format materials (Braille, large print or digital) are available with advance notice.

MSDNAA Agreement

The USU Computer Science Department is a member of the Microsoft Academic Alliance (MSDNAA), and specifically what is now called the Developer Academic Alliance. Through this program, students in CS courses can obtain and use a large number of Microsoft's operating systems and software packages.

Topics

  • Review
  • Models and Query Languages
    • Relational Model - DRC and TRC
    • Historical Models
      • Network Model
      • Hierarchical Model
    • Cloud, Pig Latin
    • Logic/Deductive, Datalog
    • OODBMS, OQL
    • XML and semistructured, XPath, XQuery
  • Concurrency Control
    • ACID
    • Serializability
    • Two-phase locking
  • Recovery
    • System log
    • Undoing and redoing
  • Security
    • Roles
    • Properties
  • Odds and ends
    • Temporal and spatial databases
    • Data warehousing
    • Data mining
    • Distributed databases

                                                                                                                                                                                                                                                                                                                                             
  E-mail questions or comments to Curtis.Dyreson at usu dot edu