Relational functions
Relational functions are used to relate data items of different domain units like Lookup or Rjoin or create new domain units like Unique. For the spatial counterparts of a join, and how they lead on to allocation, see Spatial joins and allocation.
Selection functions can be found on the separate page: Selection functions.
- Lookup - using a relation to find the relevant entries
- Rlookup - using a foreign key attribute to make a relation
- rlookup_with_null - as rlookup(relational function), but a null value is looked up in a null entry of the target values instead of resulting in null
- Rjoin - using a foreign key to find the relevant entries, combining lookup and rlookup
- Join_equal_values - find all combinations of A and B where A.x_rel is equal to B.x_rel
- join_equal_values_uint8 - is the Join_equal_values variant with a uint8 result domain
- join_equal_values_uint16 - is the Join_equal_values variant with a uint16 result domain
- join_equal_values_uint32 - is the Join_equal_values variant with a uint32 result domain
- join_equal_values_uint64 - is the Join_equal_values variant with a uint64 result domain
- join_equal_values_uint8_16_32_64 - find all combinations of A and B where A.x_rel is equal to B.x_rel, resulting in a domain unit with the explicit value type
- join_near_values - creates a new unit with points nearby other points
-
join_near_values_uint8, join_near_values_uint16, join_near_values_uint32, join_near_values_uint64 - join_near_values variants with a typed result domain
- Index - an index number based on a sort order
- direct_index
- Invert - inverts a relation
- invertAll - inverts a relation with linked list for one-to-many navigation
- 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
- collect_spec - as above, with the choice of org_rel/condition and the collection scope taken from the first argument
- table_spec - as collect_spec, but returns the supplied selection domain as a new table with the collected attributes directly beneath it
- collect_by_cond - collects an attributes to a new domain unit, using a condition
- recollect_by_cond - recollects attribute values of a selection back to an original set using the condition for the selection.
- collect_by_org_rel - collects values via an org_rel relation; synonymous with Lookup (the arrow/array-index operator)
- subindex - refines an Index: within runs of an equal primary key, the elements are ordered by the secondary values
- ordinal - passes the ordinal value of an attribute through (identity on numeric attributes)
- Unique - configures a new unit, based on the unique values
- unique_uint8 - is the Unique variant with a uint8 result domain
- unique_uint16 - is the Unique variant with a uint16 result domain
- unique_uint32 - is the Unique variant with a uint32 result domain
- unique_uint64 - is the Unique variant with a uint64 result domain
- unique_uint8_with_null - is the Unique variant with a uint8 result domain that keeps a null entry
- unique_uint16_with_null - is the Unique variant with a uint16 result domain that keeps a null entry
- unique_uint32_with_null - is the Unique variant with a uint32 result domain that keeps a null entry
- unique_uint64_with_null - is the Unique variant with a uint64 result domain that keeps a null entry
- unique_with_null - is the Unique variant that keeps a null entry when the input contains null 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_unit_uint8, union_unit_uint16, union_unit_uint32, union_unit_uint64 - Union_unit variants with a typed result domain
- Union_data - configures a new attribute, based on the union of other data items
- combine_uint8 - is the Combine variant with a uint8 result domain
- combine_uint16 - is the Combine variant with a uint16 result domain
- combine_uint32 - is the Combine variant with a uint32 result domain
- combine_uint64 - is the Combine variant with a uint64 result domain
- combine_unit_uint8 - is the Combine variant without subitems, with a uint8 result domain
- combine_unit_uint16 - is the Combine variant without subitems, with a uint16 result domain
- combine_unit_uint32 - is the Combine variant without subitems, with a uint32 result domain
- combine_unit_uint64 - is the Combine variant without subitems, with a uint64 result domain
- combine_unit - is the Combine variant without subitems
- Ordered_union_data - union_data variant, stating that all unioned values are non-decreasing; registered operator name ordererd_union_data (sic)
- Combine - configures a new unit, based on the Cartesian product of other units
- combine_unit_uint8_16_32_64 - configures a new unit, without subitems, based on the Cartesian product of other units, with a uint8_16_32_64 values unit
- 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