Ask a question
          

Difference between horizontal and vertical partitioning of data

<<Previous   Next>>

Microsoft solution 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 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. 
 

<<Previous   Next>>
 



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
 
Home | Login | About us | Sitemap | Contact us