_index.org

DBMS Storage Format

Last edited: August 8, 2025

Database Page

each Database Page is given a unique identifier; a page ID could be unique per DBMS, per DB, or per table—page IDs is indirection to physical location.

  • a Database Page is a fixed-size block of data
    • tuples
    • meta-data
    • indicies
    • log records
  • most systems do not mix page types (don’t mix different tables, do not mix different types, etc.)
  • some systems require a page to be self contained (no pointers, etc.) — for fault tolerance

Whoops, we accidentally overloaded a word

  • Hardware Page (4kb, i.e. a block on the physical disk)
  • OS Page (usually a block, notionally different for now but abstracted, 2mb, 1gb)
  • Database Page

each Database Page is automatically read/written

DBMS Storage Management

Last edited: August 8, 2025

Storage Manager is responsible for maintaining the database’ files: turn the database into files.

DCGAN

Last edited: August 8, 2025

De novo biosensors

Last edited: August 8, 2025

Speed up biosensor development? Preso felt like an ad.

LucCage

And then we throw ML at designing LucCage binding structures. Using LucCage florescence as a reporter tool for detection of the molecule

  1. we found LucCage
  2. used the platform + ML to engineer binding sites to things we want to bio on
  3. we tacked a light on it
  4. florescence
  5. now you have a lightbulb as an assay