CIS 770: Database Management Systems
Description
Fundamental design considerations and system principles of database
management systems.
Level, Credits, Class Time Distribution, Prerequisites
| Level |
Credits |
Class Time Distribution |
Prerequisites |
|
U G |
3 |
Three one-hour lectures |
CIS 670 |
Quarters Offered, General Information, Exclusions, Cross-Listings, etc.
Objectives
- Master designing, tuning and implementating relational
databases.
- Master using suitable techniques, algorithms and performance
considerations in the implementation of database management systems.
- Master using suitable principles and techniques for implementing
transaction-oriented computing.
- Be familiar with using techniques for providing concurrent,
recoverable access to data.
- Be familiar with using techniques and algorithms for set-oriented query
processing and optimization.
- Be exposed to the objectives of object-oriented and distributed
database management systems.
Texts
- J. Gray and A. Reuter, Transaction Processing: Concepts and Techniques.
| Relationship to ABET Criterion 3 |
Relationship to CSE Program Objectives |
| a |
b |
c |
d |
e |
f |
g |
h |
i |
j |
k |
| XXX |
X |
XXX |
|
XX |
X |
|
X |
X |
|
XXX |
|
| 1a |
1b |
1c |
2a |
2b |
3a |
3b |
3c |
4a |
4b |
| XXX |
XX |
XX |
|
|
|
|
X |
XXX |
XX |
|
Topics
| No. of Weeks | Topic |
|
1 |
Overview of DBMS |
|
3 |
Concurrency control, Transaction mgmt |
|
2 |
Resources mgmt
Access methods, Storage Considerations |
|
3 |
Query Processing and Optimization |
|
1 |
Object-oriented and Distributed DBMS |
Grading Plan
| Homeworks |
40% |
| Midterm Exam |
30% |
| Final Exam |
30% |
Preparer Information and Date:
Syllabus prepared by Doug Kerr, last modified April 30, 1999.