.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