CREDIT HOURS: 3

PREREQUISITES: CSC 425, or approval of computer science graduate advisor

GRADE REMINDER: Must have a grade of C or better in each prerequisite course.

Examination and appraisal of the fundamental technology of database management systems and of the practice of database systems design, database administration, and DBMS acquisition.

Computer applications and information systems are evolving into database-centered rather than traditional file-oriented systems. Successful implementation and application of DBMS technology depend on understanding the architecture, economics, managements, and future directions of such systems. This course prepares students who will become acquisitioners, and maintainers of database installations. Emphasis is placed on DBMS design and construction from a systems perspective. This course complements the applications perspective of the undergraduate DBMS course, CSC 425.

CONTENT . . . . . . . . . Hours

Historical Development of DBMS Technologies . . . . . . . . . 3

Relational, CODASYL, and Hierarchical Models . . . . . . . . . 3

Externals (productivity and ease of use considerations) . . . . . . . . . 15

Performance Monitoring and Tuning

Query Processing and Optimization

Economics of Application Development

Physical Database Design

Internal (Efficiency and Flexibility) . . . . . . . . . 15

Storage Structure

Access Methods

Storage Management

Concurrency Control

Failure Handling

Directions in Hardware and Software . . . . . . . . . 6

Database Machines

Distributed Databases

The 4GL Environment

Exams . . . . . . . . . 3

TOTAL . . . . . . . . . 45

Atre, Shaku. Database: Structured Techniques for Design, Performance, and Management, Wiley, 1988.

Cardenas, Alfonso F. Data Base Management Systems, Allyn and Bacon, 1985.

Date, C.J. An Introduction to Database Systems, Addison-Wesley, 1986.

Hawryszkiewycz, I.T. Database Analysis and Design, SRA, 1984.

Shepherd, John C. Database Management: Theory and Application, Irwin, 1990.

Wiederhold, Gio. Database Design, McGraw-Hill, 1983.