O'Reilly logo

Data Modeling Made Simple with ER/Studio Data Architect by Steve Hoberman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Partitioning is when a table is split up into two or more tables. Vertical partitioning is when columns are split up and horizontal is when rows are split up. It is common for both horizontal and vertical to be used together. That is, when splitting rows apart we in many cases learn that certain columns only belong with one set of rows.

Both vertical and horizontal partitioning are common techniques when building analytics systems. A table might contain a large number of columns and perhaps only a subset are volatile and change often, so this subset can be vertically partitioned into a separate table. Or we might have ten years of orders in a table and to improve query performance we horizontally partition by year so that when queries ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required