CMSI 486 Introduction to Database Systems

3 semester hours

Introduction to the theory and design of database systems. Database system structure, semantic data modeling, relational databases and their object-oriented extensions, object relational modeling (ORM), document-store and key-value databases, graph databases, formal query languages, integrity and security are presented, along with physical database design, indexing and hashing, query processing, and optimization. Transaction processing, concurrency, and crash recovery are introduced. Students implement a semester-long database project, which is presented to the class.

Lecture, 3 hours.

Prerequisite: CMSI 386 .

Print-Friendly Page (opens a new window)