Product Documentation

c-treeACE V11.0 Update Guide

Previous Topic

Next Topic

Cutting-Edge No+SQL Features

Be sure to review the latest No+SQL integration features.

FILESET for Querying Multiple Physical ISAM Files

The new FILESET syntax allows simple SQL queries to operate on thousands of files with little to no loss in performance. This new extension to SQL provides the flexibility and performance you need for challenging statistical analysis and other complex queries across multiple physical data files.

SQL Data Arrays allow Sub-Record Reads

SQL enables support for data files with multiple record schemas where each c-tree data record contains zero or more sub-records. The main data file can be imported into a SQL database creating a multi-record table (MRT) for each sub-record type. c-treeDB has been updated to read individual field values from a sub-record. After the MRTs are created, they can be queried through SQL.

TOCIndex