Conditions Data Payload

Conditions data payload may be different from folder to folder because it is completely specified by the users. COOL supports payloads that may be represented as rows of a simple relational table. as described by the COOL Record class and the CORAL AttributeList class. One conditions data payload is a vector of name/type/value triplets, where supported types include numbers of various precisions, short strings and large character (CLOB) or binary (BLOB) objects. When creating a folder, users must specify the desired payload specification, i.e. the vector of name/type pairs describing the payload values that users will store.

In the simplest case, payload values are stored in-line with IOVs in the IOV table of the relevant folder. Since the latest COOL release 2.8.0, users also have the option of specifying that payloads should be stored in a separate payload table, referenced by the IOV table using a foreign key constraint.

-- AlexLoth - 16-Dec-2009