Vertical Partitioning

Vertical partitioning divides a single logical table into multiple physical tables based on the columns. All rows may appear in the new tables, but each new table contains a subset of the original table’s columns. The set of columns may be redundant across tables, and will necessarily be so for the columns that implement keys and indexes. Columns for row-level metadata are also implemented in all resultant tables. Vertical partitioning is employed when there is a regular need to access or to isolate a readily identifiable subset of the “parent” table’s columns. This technique may be effective to meet security, distribution, and usability requirements.

Get your copy of Information Governance World!

WordPress Image Lightbox
Scroll to Top