c-treeSQL Server

The c-treeSQL Server provides a high performance SQL interface into the proven core of the c-tree Server. Tailored for high volume production environments, the c-treeSQL Server includes optimizations such as sophisticated query rewrite techniques to improve nested query performance and join-order optimization to improve performance of queries joining many tables. The c-treeSQL Server extensively caches and buffers information for maximum transaction and query throughput.

Because the c-treeSQL Server is built on the same core technology of the c-tree Server, you get all of the performance and features that distinguish the c-tree Server with the additional benefits of a functionally-complete SQL interface compatible with SQL-92, ODBC 3.0 and JDBC 2.0 standards.

FairCom offers both a c-treeSQL Server and a c-treeSQL Server Java Edition. The c-treeSQL Server provides embedded SQL and interactive SQL utilities, JDBC support, and an ODBC driver. The c-treeSQL Server Java Edition adds support for stored procedures and triggers. Note that the c-treeSQL Server Java Edition requires the JDK from Sun Microsystems.

FairCom's latest commercial release includes c-treeSQL Server support for most of the major platforms including Windows, Linux, Mac OS X, HP-UX, Solaris, and AIX. Additional ports to other operating systems are ongoing, so please contact FairCom for the latest status of your operating system of choice.

Follow the links above for detailed information on the c-treeSQL Server or click here to learn more about the features of the standard c-tree Server.