Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register


0
(click on this box to dismiss)

Partitioning

Does Cubrid support data partitioning and if yes how?

링크 댓글 쓰기 (0) 선택된 답변
질문시간 3년 전
picador_jr
292
10 답변들
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.

 

 

링크 댓글 쓰기 (0)
답변시간 2년 전
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: