Department of Engineering & Science

Graduate Certificate in Database Systems

Objectives:
The Database Systems Certificate is designed to provide both theory and practical knowledge in database design, client server applications, and database management.

Program Description:
The Certificate in Database Systems focuses on the area of database technology and related methodologies of analysis and design. It is expected that students who choose this certificate are currently employed or intend to seek employment in the area of database administration.

Required:
CSCI-4380 Database Systems
Principles of database systems. Data independence, storage structures, relational data models, CODASYL and network data models, security, and integrity. Stresses basic concepts and presents many examples from existing database systems. A programming project may be required.

and any three (3) of the following electives:

CSCI-6460 Adv. Database Management Topics
Continuation of Database Fundamentals, presents a more theoretical approach to logical and physical database design. Algorithms for logical database design, primary and secondary indexing techniques, query processing and query optimization, and database security. Problems of interfacing a database system with an operating system, and some of the issues in implementing distributed database systems. Much of the material comes from recent research papers. A term paper may be required.

CISH-6110 OO Database Systems
Presents concepts and architectures of object oriented database systems. Provides the object oriented view of data models, query languages, versioning evolution, authorization, transaction control, storage management, indexing techniques, distributed data, and parallelism. Current object oriented database systems are reviewed and compared. A programming project or research paper may be required.

CISH-6120 Distributed Database Systems
Examines client/server DBMS and considers how a client-server architecture can be used to implement the requirements of a DDBMS. Topics include DDBMS taxonomies, case studies, design considerations, transaction management, and global query optimization. Concludes with an examination of multidatabase systems.

OR

CISH-6960 Data Warehouse Systems
Course presents a comprehensive overview of the concepts and facilities of data warehouse systems.  Special attention will be given to current research issues as described in the scholarly journals.  The course begins with an introduction to the basic concepts and objectives of data warehouse systems.  This is followed by an examination of the logical data structures and related design methodologies applicable within a data warehouse environment.  Special attention is given to multidimensional data models based on the star and snowflake schemas.  Thereafter, the course considers data warehouse performance.  Special attention is given to recent enhancements in DBMS technology and techniques applicable to physical database design.  Topics include:  SQL extensions for OLAP, special indexes, table partitioning, view materialization, query optimization, and query re-write, and data warehouse benchmarks.
Prerequisite: CSCI-4380.  It is suggested that students complete CSCI-6460 before registering for this course.

Back to top