View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0000818||CaseTalk Modeler||Generation (SQL, XML, etc)||public||2015-12-11 14:08||2018-02-05 10:23|
|Assigned To||BCP Software|
|Target Version||Future||Fixed in Version|
|Summary||0000818: ComplexTypes in DBMS|
|Description||Some ObjectTypes containing more than a single role, may be represented by a complextype in some DBMS's. For instance a coordinate system containing both X and Y. Instead of having to columns, some DBMS's may contain this in a single column of the coordinate data type.|
|Additional Information||Upon GLR and Script generation, conceptual paths could be recognized and collapsed according to complex type names.|
|Tags||No tags attached.|
A check could be placed upon Object Types, stating it should be a complex type, and not broken down in separate grouped and lexicalized roles. In NO-SQL environments this could even become a nested Object.
In case a RDBMS does not support the complex type, it could still flatten it as if it doesn't exist.
|Visually the solid line of the Object Type in diagrams, could be drawn as a dotted line, similar to Label Types. This should not effect the validation rules, since some DBMS's may still require these to be checked.|
Non grouped or reduced object types may be considered complex types if the target platform supports them. PostgreSQL supports multiple variations of complex types. So this might be a good starting point for testing. For instance the JSON datatype.
|2015-12-11 14:08||BCP Software||New Issue|
|2015-12-11 14:08||BCP Software||Status||new => assigned|
|2015-12-11 14:08||BCP Software||Assigned To||=> BCP Software|
|2016-01-20 12:56||BCP Software||Category||Generation => Generation (SQL, XML, etc)|
|2018-01-29 11:12||BCP Software||Note Added: 0001095|
|2018-01-29 11:13||BCP Software||Note Added: 0001096|
|2018-02-05 10:23||BCP Software||Note Added: 0001111|