CS 365  Advanced Database  Systems

 

Introducing  ORACLE (Backend,  Application Server and Client) - Industry Standard

Database  Supplements

MS SQL Server,   MySQL

Syllabus

 

 
Course Links 

Students  Notes   Homework   Paper  Project   CASE Tool   Publication  KDnuggets

Course Description

The course builds upon CS364 and  focuses on advanced topics such as transactions, recovery, crash, concurrency, distributed, object-oriented, deductive and knowledge databases.  At the conclusion of CS365,  students will be able to

  • create integrated database application (industry standard).
  • use emerging Internet and object-oriented technologies in databases.
  • build app in a three-tier architecture.
  • apply  ORACLE software effectively.

Students are allowed to use any client software to interface Oracle database (web-/ non-enabled ).

Textbooks

Database  Systems by P. Rob and C. Carlos, 6th ed.,  Course Technology  2004

Grading

The grading scale for all assignments and examinations is as follows:

  • A          90 - 100 %
  • B          80 -  89 %
  • C          70 - 79 %
  • D          60 - 69 %
  • F           0  - 59 %

Final grades will be based on 5 components as weighted below:

  • Attendance/Homework                                    20 %
  • Midterm Exam                                                 20 %  
  • Project / Presentation                                       30 %
  • Final Exam                                                       30 %

To get a passing grade all components must be done or an incomplete grade will be awarded.   No late work will be accepted !

Miscellaneous Policies / Responsibilities
  • Students are expected to come to class prepared (have textbook and have read required assignments), and submit homework on time avoid penalty. If a student is not able to attend class, student should contact the instructor prior to class.
  • Projects will be executed in groups or teams. Other activities must be done individually to avoid penalty. Make-ups and incompletes are not encouraged and can only be granted for rare cases. Avoid submitting virus-infested disks or a score of zero will be awarded.
  • All misconducts will be forwarded to the Chair after the first warning.
  • The instructor may revise this syllabus as deemed necessary.

 

American With Disabilities Act

Any student whose disability falls within ADA guidelines and who is registered with the Adaptive Needs Program should inform the instructor during the first week of class of any special needs or equipment necessary to fulfill the requirements of this course. Students who have or may be dealing with a disability should speak with the disability office (260-481-6657).

 

 
Course Content:   (Warm and interactive lecture with demonstration.)
Chapters   Lecture Topics  
Chapter     Query Optimization / Database Tuning
Chapter      Database Security
Chapter     Transaction Management Overview
Chapter     Concurrency Control
Chapter     Crash Recovery
Chapter    Parallel and Distributed Databases
Chapter     Internet Databases
Chapter     Decision Support
Chapter      Data Mining
Chapter    Object-Database Systems
Chapter      Spatial Databases
Chapter    Deductive Databases
Other Info

 Instructor Dr. E. Udoh,  Phone 260-481-6946,   Room  ET 125P,   Email udohe@ipfw.edu,   

 Lecture Time: Tuesday &  Thursday    

Office Hours:  Tuesday 9:30 - 10:30 a.m.  &  12:30- 1:30 p.m.

 (Students are required to adhere to these times or send me an email). 

* This course is designed with the interest of the student at heart. Get involved, no student can afford to be a spectator in computer science!