|
|
|
c-tree application developers have been very creative in how they take advantage of c-treeACE for performance-driven applications. One technique employed is storing many small data records in a single c-tree record. By packing multiple data points into a single write operation one can greatly boost performance. Consider the savings for rapidly accumulated time-series data. But, until now, there was no way to efficiently query that data via SQL.
By combining Multi Schema Table support (MRT, introduced in V10) with additional support to "sub-read" data points from records, c-treeACE SQL can layer new views onto this data access challenge. We call this capability SQL Data Arrays.
Given appropriate schemas for each sub-record type, MRT definitions can be created providing virtual table views over these data points. With modifications to read routines in c-treeDB, c-treeACE SQL can access individual records contained in the c-tree record structure. A simple rule associating each data point with its associated schema is all that is needed to complete this highly extensible support. Quickly view data relationships you never saw before.
Contact your nearest FairCom office for the latest availability of this feature.
