Database Partitioning | Database Interview | Skill-Lync Resources
Hard Database Systems Distributed Databases

Explain horizontal vs vertical partitioning and partition strategies.

Answer

Vertical partitioning splits columns across tables (normalize or separate hot/cold columns). Horizontal partitioning (sharding) splits rows. Strategies: Range (by value ranges - time, ID), Hash (consistent hash of key - even distribution), List (by explicit values - geography), Composite (combined). Consider: query patterns (avoid cross-partition queries), data distribution (avoid hotspots), rebalancing needs. PostgreSQL has declarative partitioning; application-level sharding for cross-node.

Master These Concepts with IIT Certification
IIT Certified

Master These Concepts with IIT Certification

175+ hours of industry projects. Get placed at Bosch, Tata Motors, L&T and 500+ companies.

Relevant for Roles

Database Architect Senior Software Engineer Data Engineer