The DTS Smallworld Connector provides access to all collections in the requested DS Views (for the given alternatives), with the following exceptions:
▪internal collections (e.g. join intermediate tables, geometry storage tables, etc.);
▪drawing and raster collections (dimensioning, raster_map, background_raster, logo, function_geometry, drawing_template, drawing_function).
DTS Naming
DTS Name |
<collection_name> |
DTS Key |
<view_name>.<collection_name> |
Fields
The Smallworld Connector handles various fields as follows:
▪Physical Fields: All physical fields of known types are supported, except internal fields, which are ignored.
▪Logical Fields: Derived fields are treated like physical fields, so the same rules apply.
Logical Field return values are not type-enforced in Smallworld in any way
The Connector relies on the types declared for the field in its metadata (case), but has no way to verify that the method associated to the field always returns the declared type. If there are discrepancies, this can cause errors while streaming data!
▪Geometry Fields: All geometry fields are supported except dimension and raster fields, which are ignored.
▪Join Fields: Homogeneous join fields of all cardinalities (0:0, n:1, m:n, etc.) are supported, but heterogeneous join fields currently are not.
oThe Smallworld Connector packages join field values according to result multiplicity (i.e. whether more than one result can be expected):
•Single Result: The join value offered through DTS will be a single Minimal Record * for the collection targeted by the join. (e.g.: n:1, 0:1)
•Multiple Results: The join value offered through DTS will be an array of Minimal Records * for the collection targeted by the join. (e.g.: m:n, 1:n)
* A Minimal Record is a record from a collection containing only the fields which compose the primary key. It serves as an identifier, or a foreign key.
Text join fields are treated like physical fields and will be populated with a STRING
Metadata
The Smallworld Connector includes the following field metadata in the DTS descriptor structures:
▪type
▪type_size
▪mandatory? (can_be_unset)
▪simple_geometry