The three UTLX tree data structures are: 1) Single File Recursion (SFR) trees, 2) Multi-Table Network Recursions that mirror Bills of Materlals (BOM) trees, and 3) Multi-Table Hierarchical Trees.
Note: SoftVelocity has recently changed its terminology for "files" to be "tables," because Clarion supported databases now are now defined through the ISO/ANSI SQL standard database language that was based on tables, columns, and relationships.
The first unique UltraTree tree data structure type supports the defininition, creation, display, and update of rows of data--recursively--in a single Clarion hierarchically represented table. Every row within the hierarchy is of the same type. Additionally the count of rows in the hiearchy are identical to the count of rows in the tree's display.
The second unique UltraTree tree data structure type supports the network defininition, creation, display, and update of rows of data--recursively--that conform to the the Bill of Materials type of data structures.
Bills of Materials (BOM) structure represent the list of raw materials, sub-assemblies, intermediate assemblies, sub-components, parts, and the quantities of each needed to manufacture an end product.
What is unique about these network structures is that there almost always are different types of parts that are interrelated. Further, the count of rows contained is almost always magnitudes fewer than the count of the rows displayed.
The third tree type, not unique to UltraTree, consists of rows from multiple, hierarically related tables. This tree type is not a recursion. While Clarion too has this tree type, the UltraTree version has been extended with many more features. This is not really a suprise as the scope of development work in SoftVelocity's Clarion is massively larger than that in UltraTree's overall scope of work. This expansion was seen as an opportunity to make a multi-table Clarion data structure even better.
UltraTree has had two major edition architectures and within each a number of versions. The UltraTree LX is so much more advanced than its prior edition that the prior edition is no longer available or supported. Further, the prior edition has no migration path to the UltraTree LX edition. Rather it has to be repurchased and the trees have to be reimplemented as the configuration process is too different. That said, the features and speed of the UltraTree LX edition has been judged worth the repurchase and reimplementation.
