CMSI 3520 Database Systems

4 semester hours

Theory, design, and programming of database systems. Data modeling foundations such as relational algebra and applications of canonical, logical, and physical schemas. ACID, normalization, constraints, transaction processing; concurrency, scaling up vs. scaling out. Query languages, database software interfaces and frameworks. Database security; indexing and optimization. Students work on a range of real-world database systems and datasets of different types including file-based, relational, document-centric, graph, data warehouses, and search engines.

Prerequisite: CMSI 2210