As shown in the figure a couple paragraphs below, the Employee
table is divided into two tables: a reduced Employee
table and an EmployeePicture
table. The EmployePicture
table has just two columns, EmployeID
and Picture
, separated from the original table. Moreover, the primary key EmpoloyeeID
of the Employee
table is added in both partitioned tables. This makes the data read and write easier, and the reconstruction of the table is performed efficiently.
EmployePicture
EmployeID
EmpoloyeeID
Course: Grokking Modern System Design Interview for Engineers & Managers - Learn Interactively
Lesson: Data Partitioning - Grokking Modern System Design Interview for Engineers & Managers