profile pic
⌘ '
raccourcis clavier

Book: Database Management System ISBN-13:978-0072465631

Midterm

Thurs Oct.24 2024 (during lecture time)

Due at 2200, late penalty of 20% per 24h, max 5 days.

ssh se3db3

Relational Model, E-R Model, Views, Indexes, Constraints, Relational Algebra

  • 2.5 exabytes of data per day.

search vs. query

  • indexed keyword

  • PageRank

  • 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