FairCom DB

Extreme Speed
Maximum Control
Low TCO

How can you achieve Hundreds of Thousands of transactions per second on a single database server?

Use a database that gives you total control. Learn more…

FairCom DB is ideal for large-scale, mission-critical, core-business applications that require performance, reliability and scalability that cannot be achieved by other databases.

FairCom DB is an advanced database engine that gives you ultimate control to achieve unprecedented performance with the lowest total cost of ownership (TCO).

FairCom DB delivers predictable high-velocity transactions and massively parallel big data analytics. It empowers developers with NoSQL APIs for processing binary data at machine speed and ANSI SQL for easy queries and analytics over the same binary data.

You do not conform to FairCom DB…FairCom DB conforms to you.

With FairCom DB, you are not forced to conform your needs to meet the limitations of the database. You can conform FairCom DB to meet your business needs, giving you the database you need to meet your core-business needs — fast, reliably and efficiently.

c-treeACE is now FairCom DB

a few of our key customers
Try it Now!

FairCom DB V12

FairCom DB logo

Run FairCom DB anywhere & everywhere

Architecture Possibilities

  • Remote control many DBs simultaneously for linear scalability
  • Walk indexes and data using cursors, batches and SQL queries
  • Control transaction consistency from ACID to eventual
  • Embed or link DB app for local persistent data and in-memory cache
  • Replicate data between DBs: sync, async, parallel, shard, and HA

Choose the table type that fits your needs

  • Store, query and index your object data in fast binary records

Extreme Speed via your favorite language

  • Achieve up to 12 million transactions per second on a single database server
  • Use your language to navigate data with APIs, callbacks and plug-ins
  • Process data with custom algorithms at high speed for a unique competitive edge

LOW TOTAL COST OF OWNERSHIP

  • Low hardware costs due to extremely efficient and fast data processing
  • Self tuning and healing results in almost no database administration costs
  • Maximal developer productivity – easy APIs with the ability for total control
  • Built-in, low-cost data replication for high availability and horizontal scalability

NAV API Overview

FairCom’s NAV API gives your application an unprecedented level of control over every database action. NAV allows your favorite programming language to “remote control” the database. It can find any record (or a subset of records), move to next and previous records in index or data order, join to specific records in other tables, choose which records to lock, which records to include in a transaction, and which records to retrieve, insert, update, and delete. NAV allows you to save the position of records and immediately jump back to those positions to retrieve records without index lookup.

You can run SQL simultaneously with any NAV operation. This gives your application the best of both worlds. SQL solves easy problems with little code. NAV solves hard problems with little code by leveraging the full capabilities of mainstream programming languages, such as Java, C#, C++, Python, and Javascript. NAV extends these languages to control the database with a small amount of simple code. NAV provides unprecedented speed because your application uses the ideal algorithm to make the database do exactly what needs to be done and no more.

  YOUR ALGORITHM

Use NAV to create an algorithm to process your data exactly the way you want with total control for extreme performance and efficiency. You can use any algorithm – including hundreds of existing graph algorithms. NAV also gives you automatic behaviors that make writing code easy and intuitive.

  NAVIGATION

Use NAV to navigate from record to record and table to table using a wide variety of techniques, such as:

  • Using an index to look up a record.
  • Using a record position to jump directly to a record.
  • Moving to next or previous records in index or data order.
  • Embedding record positions in records and using them to quickly walk a hierarchy or process a graph of records without index lookups.
  • Using foreign keys to join records.
  • Filtering records server side for fast bulk retrieval, inserts, updates, and deletes.
  • Etc.

  POSITIONS

Use NAV to save and restore multiple record positions to instantly retrieve records or move a cursor to any record – without index lookups. With NAV, record positions can be immutable, making them safe to store inside records as “pointers” to other records. This makes graph traversal easy and fast.

  LOCKS

Use NAV to control if and how a record gets locked automatically or manually. You can combine automatic and manual locks for ease of use and total control. For locking records manually, you can use read, write, blocking, non-blocking, and exclusive locks. For automatically locking records while your application navigates records, use session lock modes, such as no locks, read-only locks, read-write locks, blocking locks, non-blocking locks, etc. You can suspend and resume automatic locking at any time and easily release all or some locks created by your session. You have the ability to freely intermingle SQL and NAV because locks are compatible across both.

  TRANSACTIONS

With NAV you have the ability to create all-or-nothing, isolated transactions that span multiple operations across many records, such as removing an amount from a debit record and adding it to a credit record. You can control when transactions begin, end, are nested, and whether specific records participate in a transaction. NAV allows you to create save points along the way and roll back to them as desired. NAV’s automatic transactions make ACID-compliant navigation easy, and NAV’s manual transactions provide total control to achieve extreme performance and any degree of consistency from eventually consistent to ACID compliance. You can also freely intermingle SQL and NAV because transactions are compatible across both.

Here to Help

No need to go alone.
The highly rated FairCom Support and Professional Services teams are here 24/7/365.

WHAT OTHERS ARE SAYING

“We reviewed every database option available on the market today. Only FairCom could meet the real-time and throughput requirements we had to deliver in the TeaLeaf Web application management solution.”

Tim Knudsen Director of Product Management, TeaLeaf

Custom Clustering for Horizontal Scalability & High Availability

FairCom DB does not limit you to one cluster topology. FairCom DB’s built-in Replication Manager makes it easy to mix and match data replication and failover to create any cluster topology you need for horizontal scalability and high availability.

Implement any cluster scenario including:

  • Eventually consistent
  • ACID-compliant
  • High availability
  • Disaster recovery
  • Massive horizontal scale with read-only and read-write shards

Control replication at all levels from individual data files to entire databases. Publish data once and subscribe to a publication many times across many servers. Don’t worry about performance because FairCom Replication uses multiple threads to continuously stream all changes at high speed, and it runs outside the database process to ensure database performance is not impacted.

Eventually Consistent - Write Anywhere Shards

Replication options:

  • Synchronous & asynchronous
  • Bidirectional & unidirectional
  • Subsets or entire files, folders, and databases
  • Filtered records

Automatic failover options:

  • FairCom failover
  • Linux cluster
  • Windows cluster

REPLICATION MANAGER

A browser-based graphical user interface, called Replication Manager, runs in a central location to configure, manage and monitor data replication across hundreds of servers and thousands of tables and files. FairCom Replication can also be automated through a JSON/HTTP web service API and a C/C++ API.

Continuum of Control

The secret to FairCom DB is its Continuum of Control, which allows you to configure the database to perfectly fit your application.

Control

The left side of each continuum is "Total Control" - which describes uniquely useful capabilities of the FairCom Database. The right side is "Traditional Control" where the FairCom Database operates like a SQL database. In between are multiple levels of control.

You choose your ideal level of control within and between continuums.

Predictable Development

Run SQL queries over custom binary data and simultaneously traverse SQL rows using powerful NoSQL APIs.

Start developing with standard SQL APIs (on the right) and work through the lower-level APIs as you need more control.

Low-level API

Low-level API

Control every bit in every record and index…

Binary Record API

Binary Record API

Store binary data as is, automatically index it, traverse indexes…

NAV API

NAV API

Control every aspect of finding, navigating, locking…

standard
ANSI SQL API

ANSI SQL API

Run SQL over binary and relational data…

Code Control

Developers have an unprecedented level of control over every aspect of the database.

Database behavior and APIs are predictable so a developer can consistently deliver high-performance solutions.

Source Code

Modify source code with full support…

Plug-ins

Safely extend the database…

Callbacks

Quickly process events…

Client Libraries

Use C, C++, Java, C#, VB, Node.JS, Python…

Java & C# in SQL

Use SQL to call Java and C# stored procedures…

Data Types

Process native CPU data types at machine speed using NoSQL APIs and simultaneously run SQL queries over the same data.

Custom Data Types

Store binary data as is, index and process it as relational data in SQL…

Machine Data Types

Process native CPU data types at machine speed: 2GB arrays, 2GB strings…

SQL Data Types

Run SQL over native machine data types: VARCHAR, VARBINARY, BIGINT…

Indexing

Index anything: arrays of bytes, binary structures, fields in records and SQL columns.

Byte Indexes

Control each byte indexed…

Binary Indexes

Index binary data structures…

Conditional Indexes

Selectively index records…

Column Indexes

Index one or more SQL columns…

Communications

Eliminate latency between applications and databases and maximize deployment flexibility.

Compile

Embed the database in app servers…

Dynamic Link

Run microservices at exceptional speed…

Shared Memory

Scale multitenant solutions to unprecedented levels at lowest costs…

TCP/IP

Scale horizontally and flexibly...

Clustering

Combine some or all of the following clustering technologies to create a custom clustering topology that matches your exact needs.

Custom Clustering

Custom scatter writes and gather reads…

Asynchronous Bidirectional Replication

Create eventually consistent clusters…

Synchronous Replication

Create ACID-compliant clusters…

In-memory Replication

Replicate reference data…

OS Clustering

Create high-availability…

TRY IT FOR YOURSELF

Explore How FairCom DB Can Achieve Your Goals

Consistency

Simultaneously use the full range of FairCom DB consistency options from 100% ACID compliant to eventually consistent.

There are four aspects of consistency: Atomicity, Transaction Consistency, Isolation and Durability.

The next four continuums of control illustrate how you can customize consistency of each database and each table to meet the precise needs of your application.

Atomicity

FairCom DB gives you control over how transactions commit and rollback as a group

Non-atomic Transactions

Extremely fast inserts, updates and…

Atomic Transactions

ACID Atomicity…

Consistency

FairCom DB provides a Continuum of Control over consistency to allow each type of record to meet required trade-offs between performance, capability and consistency.

ACID Consistency ensures, that at a single point in time, the same piece of data always has the same value when it occurs in multiple shards, tables, indexes and queries. Eventual Consistency allows the same piece of data to be different wherever it occurs while eventually making it the same. Partial consistency lies in between.

FairCom DB allows each type of record to have the precise type of consistency it needs.

Eventual Consistency

Maximum speed…

Custom Consistency

Per table consistency…

Index Consistency

Per index consistency…

Multi-server Consistency

Consistency across servers…

ACID Consistency

Point-in-time consistency…

Isolation

Isolation ensures your queries and transactions are not visible to other users and vice versa.

You can control the isolation level of each database, table and row.

No Isolation

Exceptional read speed…

Custom Isolation

Isolate exactly as much as you want…

SQL Read Committed

Automatically isolate from uncommitted writes…

SQL Repeatable Read

Automatically isolate from new rows…

Durability

Durability ensures your data is stored safely on persistent storage. FairCom DB gives you a Continuum of Control to achieve unprecedented performance and durability.

In-memory Durability

Fastest storage, period…

Delayed Durability

Fastest transaction IO…

Direct IO

Fastest non-transaction IO…

Table Mirroring

Durable NVMe storage…

ACID Durability

Ultimate durability…

PLATFORM SUPPORT

Hardware and OS

FairCom Database Engine runs on most hardware and operating systems.

  • Run and compile database on all major operating systems including Unix (AIX, Solaris, HPUX,QNX, VxWorks, FreeBSD, etc.), Linux, macOS, and Windows
  • Run and compile database on all major processor hardware including 32-bit and 64-bit Intel, AMD, ARM, and RISC based hardware
  • FairCom has ported c-tree to over 100 platforms. The code is extremely portable. FairCom can likely support any operating system or processor need you have.

Additional Information

Want to learn more about FairCom DB? Select a topic below for additional information.
 

See what is new!

FairCom DB

c-treeACE is now FairCom DB

c-treeACE lives on under a new name, FairCom DB. The same great technology you have come to expect from the FairCom c-tree product family with new improvements and a new name, FairCom DB. The upgrade to the new FairCom DB V12 from c-treeACE V11 or earlier versions of c-tree is as easy as ever.

To upgrade from c-treeACE, contact your FairCom account executive or contact us here.

×