Database partitioning means to split one database or, in many cases, one single large table, into multiple distinctive pieces. Partitioning is often used to optimize performance when different parts of the database undergo different treatments or processes. But it can also be used as an organization technique, where meaningful groups of data are kept together.
Types of Database Partitioning?
In general, there are two types of partitioning: horizontal partitioning and vertical portioning. Horizontal partitioning means the rows of a table are broken out into pieces which the table schema is kept. In this case the ending result is multiple smaller tables with the same schema, a union of all the horizontal partitions produces the wholesome table. On the other hand, vertical portioning implies splitting columns or fields. In this case, the resulting partitions will have completely different schemas, but a join of all partitions by the primary keys will still result in the wholesome table.
There are many different partitioning techniques, such as range partitioning, list partitioning, and hash partitioning, etc. For Acho Studio users, database partitioning generally is a backend structure that they do not need to worry about. The Acho team will configure the backend database structure to ensure performance is always optimized for frontend user experiences.
Get started for free right now!
Enterprise Data Hub
Let’s build data apps to transform your business processes