Difference between horizontal and vertical partitioning of data - microsoft solution framework

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.

Benefits of using components to implement business rules - microsoft solution framework
Microsoft solution framework - What are the benefits of using components to implement business rules?.........
What is type safety verification? - microsoft solution framework
Type safe code is one that accesses types only in allowable and proper ways. JIT performs a type safety verification.......
What is Code Signing? - microsoft solution framework
Code Signing - While executing any piece of code or application, the users are not sure about trusting the code. This is also a major problem when accessing information through the internet.........
Post your comment