.NET Architecture & System Design Interview Question #58
What is vertical partitioning?
Database Scaling, Partitioning, NoSQL & Data Consistency Mid-Level Intermediate
Quick Interview Answer
Vertical partitioning separates columns or related groups of data into different tables or stores. It can keep frequently accessed data small while moving large or rarely used attributes elsewhere.
Detailed Explanation
Vertical partitioning separates columns or related groups of data into different tables or stores. It can keep frequently accessed data small while moving large or rarely used attributes elsewhere.
The trade-off is that requests needing the separated data may require additional joins or calls. Vertical partitioning should reflect real access patterns rather than arbitrary table splitting.
Code Example
Customer
- Id
- Name
- Email
CustomerProfile
- CustomerId
- Biography
- LargePhoto
- Preferences