Mar 28, 2024  
Loyola Marymount University Bulletin 2019-2020 
    
Loyola Marymount University Bulletin 2019-2020 [ARCHIVED CATALOG]

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 .