Product Documentation

c-treeDB API API for C

Previous Topic

Next Topic

Working with Multi-Record Virtual Tables

A common technique in many early applications was to combine multiple types of records into a single physical data file. Many of those applications have been very successful for many years and are still in service. This technique was a common practice when storage space was at a premium. However, this technique does not conform to the standard, single-schema, relational model necessary for SQL access.

Developers are looking at adding more complex features and interoperability over their data with new technologies such as web access and Windows .NET support. This has proven to be a challenge when the data is not of a consistent schema due to multiple record types in a single table.

FairCom DB allows a single table with multiple schemas (multiple record types) to appear to SQL as multiple virtual tables, each with a single schema.

In This Section

c-treeDB API Virtual Tables

FairCom DB MRTTable API

Multi-Record Table Tutorial