|
Difference between horizontal and vertical partitioning of data.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.
|
