3 credits
Fall 2026 Lecture Distance Learning Upper Division
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 Outcomes1Explain how real-world application scenarios can be modeled inside database management systems.
2Express queries over database systems and understand how they are evaluated.
3Understand how the various data types can be supported inside the database management system and how new data types can be introduced and supported.
4Understand the various ways data can be stored inside a database management system and how data can be accessed efficiently.
5Characterize the various types of workloads of database systems and their characteristics and how to tune the database infrastructure accordingly.
6Understand how queries are optimized and are executed efficiently.
7Understand how data is manipulated and modified inside a database management system.
8Identify the challenges and anomalies associated with the concurrent modification and access to the data.
9Understand how to guarantee the consistency of the data in the presence of concurrent updates to the data.
10Describe the problems that might occur when a crash happens to the database and ways to mitigate that.
11Understand how the various emerging hardware architectures affect the design of the various layers of database management systems.
Prerequisites
Restrictions
GPA by professor
made by Purdue students.