Book: Database Management System ISBN-13:978-0072465631, or pdf
Midterm
Thurs Oct.24 2024 (during lecture time)
Due at 2200, late penalty of 20% per 24h, max 5 days.
ssh se3db3Relational Model, E-R Model, Views, Indexes, Constraints, Relational Algebra
- 2.5 exabytes of data per day.
search vs. query
-
indexed keyword
-
data independence
-
fault tolerant
-
concurrency control for transactions
-
reliable storage to maintain semantics
independence
- logical: protection from changes in logical structure
- physical: protection from changes in physical structure