framework - Difference between horizontal and vertical partitioning
of data - Aug 11, 2009 at 19:00 pm by Shuchi Guari
Difference between horizontal and vertical partitioning of
Horizontal partitioning of data
refers to storing different rows into different tables. E.g.: Students with
their first name starting from A-M are stored in table A, while student with
their first name starting from N-Z are stored in table B. Therefore the
partition tables are A and B.
On the contrary, vertical partitioning of data refers to creating tables with
fewer columns and using other tables to store the remaining columns.
Normalization follows a similar principle. E.g. separately storing Age and Name
(frequently needed) in one table and Phone number and address (less frequently
used) in another.