Relational functions
Relational functions are used to relate data items of different domain units like lookup or rjoin or create new domain units like subset or unique
- lookup - using a relation to find the relevant entries
- rlookup - using a foreign key attribute to make a relation
- rjoin - using a foreign key to find the relevant entries, combining lookup and rlookup
- join_equal_values - find all combinations of A and B wherfe A.x_rel is equal to B.x_rel
- join_equal_values_uint8_16_32_64 - find all combinations of A and B wherfe A.x_rel is equal to B.x_rel, resulting in a domain unit with the explicit value type
- index - an index number based on a sort order
- direct_index
- invert - inverts a relation
- select_with_org_rel or subset - configures a new unit, based on a condition
- select_uint8_16_32_64_with_org_rel - versions of the select_with_org_rel function, resulting in a unit with the explicit value type
- select and select_data - similar to select_with_org_rel, but faster and less memory intensive in case of dense subsets
- select_uint8_16_32_64 - versions of the select function, resulting in a unit with the explicit value type
- select_with_attr_by_org_rel - similar to select_with_org_rel/subset, resulting in a unit and a set of attributes
- select_uint8_16_32_64_with_attr_by_org_rel - versions of the select_with_attr_by_org_rel function, resulting in a unit with the explicit value type
- select_with_attr_by_cond - similar to select_with_org_rel, resulting in a unit and a set of attributes
- select_with_org_rel_with_attr_by_cond - similar to select_with_attr_by_cond: condition is used for all collections, but an org_rel is also produced
- select_uint8_16_32_64_with_attr_by_cond - versions of the select_with_attr_by_cond function, resulting in a unit with the explicit value type
- collect_attr_by_org_rel - collects a set of attributes to a new domain unit, using an org_rel attribute (lookup)
- collect_attr_by_cond - collects a set of attributes to a new domain unit, using a condition
- recollect_by_cond - recollects attribute values of a subset back to an orininal set using the subset condition.
- unique - configures a new unit, based on the unique values
- unique_uint8_16_32_64 - configures a new unit, based on the unique values, with a uint8_16_32_64 values unit
- union - obsolete, only in use for backward compatibility
- union_unit - configures a new unit, based on the union of other units
- union_unit_uint8_16_32_64 - configures a new unit, based on the union of other units, with a uint8_16_32_64 values unit
- union_data - configures a new attribute, based on the union of other data items
- combine - configures a new unit, based on the Cartesian product of other units
- combine_uint8_16_32_64 - configures a new unit, based on the Cartesian product of other units, with a uint8_16_32_64 values unit
- combine_data - configures a new attribute, based on the Cartesian product of other data items
- merge - merges the values of a data item, based on an option data item
