|
|
| Course Description
ACS575 is a graduate-level course in database systems that builds
upon CS364. It emphasizes implementation issues and DBMS architecture
with focus on advanced topics
such as transactions and concurrency, object-oriented databases,
security, data warehousing and mining, query optimization, distributed,
deductive, client/server and knowledge databases. It also surveys
emerging database technologies. At the conclusion of ACS575, students will be able to
- create a simplified single-user relational database system with
layers.
- create integrated database application in a three-tier
architecture (industry standard).
- use emerging Internet and object-oriented technologies in
databases.
- apply ORACLE software effectively.
Students are allowed to use any client software to
interface Oracle database (web-/ non-enabled ). |
|
| Textbooks
Database Management Systems by R. Ramakrishnan and
J. Gehrke, 3rd ed., McGraw-Hill
|
|
| 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 %
- Paper
15 %
- Project /
Presentation
25 %
- Midterm
15 %
- Final Exam 25 %
Any component submitted after the due date earns
automatic 30 % deduction. To get a passing grade all components must be
done or an incomplete grade will be awarded. |
|
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 (Only 3 excused absences
allowed).
- 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.) |
| |
Lecture Topics
|
| 1 |
Query Processing and
Optimization |
| 2 |
Transaction Processing
Concepts |
| 3 |
Concurrency Control Techniques |
| 4 |
Database Recovery Techniques |
| 5 |
Database Security and
Authorization |
| 6 |
Distributed Databases and
Client-Server Architecture |
| 7 |
Deductive Databases |
| 8 |
Data Warehousing and Data
Mining |
| 9 |
Object-Oriented Databases |
| 10 |
Emerging Database Technologies
and Applications |
|
| Other Info:
Instructor Dr. E. Udoh, Phone
260-481-6946, Room ET 125P, Email udohe@ipfw.edu,
Lecture Time
Office Hours:
(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!
|
|