Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


0
(click on this box to dismiss)

Partitioning

Does Cubrid support data partitioning and if yes how?

link comment (0) accepted answer
asked 3 years ago
picador_jr
292
10 Answers
1

Currently CUBRID supports three ways of data partitioning: range partitioning, hash partitioning and list partitioning. Partitioning is implemented using subtables. A subtable is created for each partition.

You can define a range partitioning by using the PARTITION BY RANGE clause. When defining a range partitioning you should specify the column which is the key of the range. And the ranges themselves. As an example we might want to store seprately olympic games which were held before 1970 and after.

You can define a hash partitioning by using the PARTITION BY HASH clause. When defining a hash partition you specify the column which will be the seed of the hashing algorithm and the number of partitions you want to have. Depending on the hash value of the key the record will be stored in the respective partition.

You can define a list partitioning by using the PARTITION BY LIST clause. List partitioning allows you to specify the key column and to define which values of the column correspond to which partition.

 

 

link comment (0)
answered 2 years ago
swanotets
263
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: