The difference between segmentation and splitting in KDB

Question

What is the difference between HDB segmentation and HDB partition? According to my understanding, data is stored in different sections (based on date, month, year, etc.).

Answer 1

In a segmented table, none of the partitions is under the same root; instead, the root contains a file called par.txt , which has paths to different segments. while in a partitioned table, all partitions are under the same root.

Check out this link: https://code.kx.com/wiki/JB:KdbplusForMortals/kdbplus_database

Use . Q.par to find the exact path (segment) of the segmented table.

The main advantage of a segmented database is its speed when performing map reduction operations.

Typical broken db structure:

 /db [sym] /partition1 /partition2 

Typical structured segmented db:

 /db [sym] par.txt " ==drive1==== /segment1 /partition1 /partition2 " ==drive2==== /segment2 /partition1 /partition2 "