Product Line

FairCom Corporation has been providing fast, portable and reliable embedded database and data management solutions since 1979. FairCom gives developers the power and flexibility to quickly and reliably deal with all aspects of storing, retrieving and updating mission critical data. FairCom services customers worldwide and is in use by such noted companies as Computer Associates, Compuware, Citibank and Federal Express.

Whether building an application for a robust enterprise wide system or designing a database for an embedded process that requires performance and a small footprint, FairCom has a database technology solution that will meet the needs of even the most advanced application.

c-tree Plus

With unparalleled sophistication, c-tree Plus has established itself as the premier choice for commercial database development. Our rich API's include low-level routines, ISAM (Indexed Sequential Access Method) routines, higher-level C and C++ interfaces and VCL/CLX components for Borland developers. c-tree Plus is distributed in full source code and has been ported to over 100 environments.

• Fast performance
• Single user and peer-to-peer (non-server) support
• Client-side support for the c-tree Servers and c-treeSQL Servers
• Full source code
• Small footprint
• ODBC and Crystal Reports™ drivers
• Robust server side SDK—build your own application-specific database server with full source available
• Fixed and variable length records and keys
• Huge file support (up to 16 exabytes)
• Segmented file support
• 64-Bit support
• Dynamic space reclamation
• Powerful stand-alone index support
• Windows to Mac to Unix all in one package

c-tree Plus for .NET – Components for the Microsoft® .NET Framework

c-tree Plus for .NET provides application developers working in .NET environments an easy to use interface into the powerful core of c-tree Plus

• Provides a .NET assembly that exposes FairCom's record oriented architecture.
• Integrates with VB .NET, C#, J# and others
• Similar API to FairCom's c-treeDB API

c-treeVCL/CLX - Data access components for Borland environments

FairCom's VCL and CLX components for c-tree Plus bring the proven performance and reliability of c-tree Plus to developers working in Delphi, C++Builder, and Kylix environments.

• Access c-tree Plus using Borland's RAD tools
• Eliminate the dependency on the Borland Database Engine (BDE)

c-treeDBX — dbExpress Driver for Borland environments

The c-tree dbExpress Driver provides a set of methods for dynamic SQL processing and will serve as the next generation data-access method for Kylix, Delphi, and C++Builder. This cross-platform, database-independent interface allows developers to take advantage of the performance and reliability offered by FairCom’s SQL database server, c-treeSQL Server.

• Fast access to SQL database servers
• A driver that adapts the server-specific software to a set of uniform dbExpress interfaces
• Simply include a dll (server-specific driver) to deploy the database application
• Eliminate the dependency on the Borland Database Engine (BDE)

c-treeSQL Server - Includes ODBC and JDBC drivers

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. 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.

• All the benefits of the c-tree Server and more
• SQL interface
• Embedded SQL and interactive SQL utilities
• ODBC driver with server-side processing
• 100% Pure Java™ JDBC driver (Type IV 100% Java driver)
• Stored procedures and triggers

c-tree Server

FairCom's robust database server provides additional features over the non-server models provided within c-tree Plus. These features offer significant throughput enhancements by reducing network traffic, providing sophisticated caching, and offering advanced, re-entrant multi-threading. FairCom's client/server implementation supports heterogeneous networks and lets dissimilar clients concurrently attach to any c-tree Server. Developers can build an application for one platform and easily migrate to any of over 30 other platforms. The c-tree Server also provides the following multi-user features:

• Easy deployment to end-user sites with no ongoing configuration, tuning, or upkeep
• Tuned for fast on-line transaction processing (OLTP)
• Automatic disaster recovery
• Multiple save/restore points
• Real-time data backups (dynamic dumps)
• Advanced file encryption
• Communication encryption
• Login security
• File security
• Configurable data/index caches
• Robust multithreading
• SMP support
• Customizable server
• Huge File support (up to 16 exabytes)
• Segmented file support
• 64-Bit support
• Seamless heterogeneous support

c-tree Server SDK - Customize your database server!

The c-tree Server Development Kit was created to allow the advanced developer to take full control of the database Server side of client/server applications. It allows developers to move application functionality to the server to decrease network traffic and increase performance thereby allowing the developer the means to create an industrial strength, application specific Server. This includes the ability to add to or override existing database functionality or to create a special multi-threaded server with FairCom's proven technology. Bind your application to our advanced server core for maximum performance! This powerful SDK is included in c-tree Plus at no additional cost!

• Full control over the server side of development
• Move data intensive processes from the client to the server
• Link your own needs into the thread-safe c-tree Server
• Utilize your own communications subsystem
• Bind your application to our server core
• Exceptional performance

c-tree Plus and c-treeSQL ODBC Drivers

Today's computer user demands direct, easy access to personal and corporate data from within popular applications. The ODBC (Open Database Connectivity) standard from Microsoft provides this type of open connectivity.

The connectivity is made possible through vendor specific database drivers that map a particular vendor's API (Application Programming Interface) to the ODBC standard API.

FairCom offers three varieties of ODBC Drivers:

• c-treeSQL ODBC Driver - for use with the c-treeSQL Server.
• c-tree Plus ODBC Driver - for use with c-tree Plus standalone operational models and standard (non-SQL) c-tree Servers
• c-tree ODBC Driver - for use with older c-tree V4 data files

With an ODBC driver in place, it is possible for your customers to access c-treeSQL™, c-tree Plus®, or c-tree® (V4) files from ODBC compliant applications like Microsoft Access and Microsoft Excel. ODBC drivers can also be used as a programmatic interface when using a development environment such as Visual Basic that provides ODBC access.

c-tree Plus Crystal Reports™ Driver

The c-tree Plus Crystal Reports Driver provides direct access to c-tree Plus data and index files from Seagate's popular Crystal Reports software. The primary benefit of this native Crystal Reports driver over our c-tree Plus ODBC Driver is a dramatic increase in read/write performance over the traditional ODBC approach. The c-tree Plus Crystal Reports Driver places the c-tree Plus read/write logic directly into the Crystal Reports report engine, thereby eliminating the costly overhead of the ODBC parsing and translation layer. Customers using this driver have reported performance enhancements of 10-75% over Crystal Reports access through ODBC technology.

• Utilize Crystal Reports' powerful tools and easy-to-use interface to access your c-tree Plus data
• Significant performance gains compared to ODBC access
• A powerful add-on to any application based on c-tree Plus

c-tree Plus Driver SDK

The c-tree Plus Driver SDK offers the FairCom application developer the ability to customize the c-tree Plus ODBC Driver and the c-tree Plus Crystal Reports Driver to meet specific application needs. The c-tree Plus Driver SDK supports custom data types, individual record control, and custom ODBC Driver/Crystal Reports Driver Installation. The record level API allows the developer the ability to capture data before it is written to disk and before it is displayed on screen allowing for full data manipulation prior to storage and/or display.

• Custom installation
• Record-level control
• Build your own custom DLL

r-tree Report Generator

r-tree produces detailed, multi-line reports from multiple c-tree Plus data files. r-tree handles virtually every aspect of report generation. The only programming requirement is to call the r-tree report function which reads c-tree Plus data files; performs necessary calculations; monitors control breaks and accumulators; and produces a formatted report.

• Create custom reports tailored to your needs
• Simple scripting language makes report generation easier
• Reports can be distributed as editable scripts or compiled scripts