what’s the difference between page table and page directory in dbms

tags: learning database diff-between

content

  • page table is for buffer pool manager
    • it stores metadata of frames in memory
    • e.g., dirty flag of a frame, how many pointers of that frame is given out, when is that frame accessed
    • page table itself is in memory, ephemeral
  • page directory is for storage manager
    • it stores where a page is on disk
    • page directory itself is on disk, persistent

up

down

reference