How databases store data on disk?
Вставка
- Опубліковано 30 тра 2024
- Architecture Readings #3 - Database Internals. Slotted Pages
0:00 Start
0:23 Encoding data with binary calculation system
3:19 Storing strings
4:00 Structure of a database file
4:56 Fixed-size page layout
6:13 Variable-size pages: Slotted pages
8:00 Cell structure
8:50 Cells inside the page
10:13 Summary - Наука та технологія
Good stuff here
I'll Explain it To You P1G. In a SQL Relational Database: Data that is Infrequently Accessed is Normalised (Relational: SQL) AND Data that is Frequently Accessed is De-Normalised (Hierarchical: MongoDB or Mainframe Database). This Reduces the Size of Database Files. Processing Smaller Database Files is Faster.