Product Documentation

c-treeACE V10.0 Update Guide

Previous Topic

Next Topic

Multiple Record Formats

Multi-Record Format

Introducing a unique new feature you will not find with any other database vendor. We have added the ability to handle data files containing multiple proprietary data record formats and map them into a relational representation. This provides the ability to operate on that data from our SQL layer, opening your unique file formats to industry standard SQL.

Many users have taken advantage of the flexibility of c-tree’s ISAM or Low-Level record-oriented interface and defined their own data record layouts. In many cases, these layouts do not conform to a relational model required by SQL. Proprietary data types, multiple record types based on “record type” flags, are common in many specialized c-tree applications. Now, with our support to handle this type of non-relational data, we can convert data formats at runtime and map non-relational data into a relational model “on-the-fly” and access this data via SQL. You retain the original application’s ability to operate on the data as your actual data is not modified.

We have also implemented this technology in our COBOL product. Many COBOL applications have this type of record-oriented (ISAM) data and require access to SQL without exporting / importing to an alternate SQL database. c-treeACE SQL can operate over this native original data.

For more information, see Multiple Record Formats - c-treeDB Virtual Tables.

TOCIndex