Home › Forums › kdb+ › Storage architecture for KDB › Re: Storage architecture for KDB
-
Some inbuilt functions do make assumptions around how data is stored for segmented databases.
The functions assume each date is stored in the segment entry matching modulus of the date by the number of par.txt entries .i.e round robin.
See related thread:
Solved: .Q.par Doesn’t Provide the Correct Result in the S… – KX Community – 14220
And warning: https://code.kx.com/q/database/segment/#considerations
“Partition data correctly: data for a particular date must reside in the partition for that date.”
However for querying and normal operations where these functions are not called there is no such requirement.
Symlinking is used often in kdb+ systems for flexibility around storage layouts.