| |
Oct 17, 2026
|
|
|
|
|
2026-2027 University Catalog
|
CS 54100 - Database Systems
Credit Hours: 3.00. Fundamentals for the logical design of database systems. The entity-relationship model, semantic model, relational model, hierarchical model, network model. Implementations of the models. Design theory for relational databases. Design of query languages and the use of semantics for query optimization. Design and verification of integrity assertions, and security. Introduction to intelligent query processing and database machines.
Learning Outcomes
1. Explain how real-world application scenarios can be modeled inside database management systems. 2. Express queries over database systems and understand how they are evaluated. 3. Understand how the various data types can be supported inside the database management system and how new data types can be introduced and supported. 4. Understand the various ways data can be stored inside a database management system and how data can be accessed efficiently. 5. Characterize the various types of workloads of database systems and their characteristics and how to tune the database infrastructure accordingly. 6. Understand how queries are optimized and are executed efficiently. 7. Understand how data is manipulated and modified inside a database management system. 8. Identify the challenges and anomalies associated with the concurrent modification and access to the data. 9. Understand how to guarantee the consistency of the data in the presence of concurrent updates to the data. 10. Describe the problems that might occur when a crash happens to the database and ways to mitigate that. 11. Understand how the various emerging hardware architectures affect the design of the various layers of database management systems.
Credit Hours: 3.00
|
|