Selecting the Right Edition

Technology Sized to Fit Your Need

Operating Environment

The hardware resources utilized for each edition of the FairCom DB Server are different. Thus, you need to consider the requirements of your application (e.g., CPU usage, database size, or cache limits) when determining the FairCom DB Server edition to select.

Essential

Evolve

Enterprise

Purchase Method

Per User

Per User or Per Core

Per User or Per Core

Hardware Supported

Up to 4 cores

Up to 8 cores

OS Limit

Available Cache

Up to 128 MB

Up to 1024 MB

OS Limit

Maximum Database Size

10 GB

100 GB

OS Limit

Feature Set

As shown in the table below, each FairCom DB edition—Essential, Evolve, and Enterprise—supports a different set of features. A basic Essential server supports a core set of features, but none of the advanced features demanded by a more sophisticated application, which would be better served by all of the advanced features in the Enterprise server. FairCom Replication is available starting with the Evolve edition.

NoSQL Standard Features

Essential

Evolve

Enterprise

Sophisticated Key/Value Pair data access
Flexible Record Schema
User-defined data types
Primary and secondary indexes
Multithreaded engine
Full client and partial server source code
ACID Transactions
Automatic Aggregation
Automatic Purging
Automatic Timestamps
Table Marks - group files to simplify file open/close with large quantities of files
JSON
JavaScript NAV API
Python NAV API
REST API

NoSQL Advanced Features

Essential

Evolve

Enterprise

Hot Alter Table
Full-text Search
In-Memory data files
Server-to-server communication
Partition Files
Alternate Collating Sequences

SQL Features (ANSI 92)

Essential

Evolve

Enterprise

Users and groups with authority definitions
Triggers
Stored Procedures (.NET and Java)
User Defined Functions
Interactive/Scriptable SQL interface
Multiple interfaces (ADO.NET, JDBC, ODBC, Python, Delphi)
Multiple Record Type (MRT) Support
Advanced Dynamic SQL Partitioning (FILESET)
Multiple Record Type (MRT) Support
Hot Alter Table
Full-text Search
Truncate file support
Nodename/Process ID used to identify the application using the ODBC drive
PHP PDO support
Python SQL Alchemy
Automatically add tables to SQL Dictionary (sqlize)

High Availability and
Business Continuity

Essential

Evolve

Enterprise

Basic Transaction control: full disk, full recovery, no grouping
Tunable transaction Commit Delay control for ultra-high speed data I/O applications
Two-phase commit
Deferred durability: delay flushing of transaction logs
Quiesce operation for hot snapshot
Full real-time backup support
Point in time backup/restore
VSS backup support
Real-time replication for Failover, DR, read/write scalability

May be purchased

May be purchased

Read Only Server

Security Features

Essential

Evolve

Enterprise

Basic Security/Data Camouflage
Advanced Security

Data Encryption

TLS (Transport Layer Security)

Multi-Level File Authentication [ File Password ]

Row-level Security

LDAP Support

Secure OEM Client/Server Handshake/OEM Builds

AWS Secrets Manager

Performance Tuning & Capacity Limits

Essential

Evolve

Enterprise

Support > 32,000 file opens per Server (current limit is 1,000,000 and can be increased further)
4 TB Sort Memory
Huge Columns (Maximum column size increased to 65,500)
Huge Columns to Tables (columns per table 2,500)
Huge Temporary Table Size (128TB)
Basic Cache Management
Basic Cache Management
Advanced Cache Management

Cache Priming

Dedicated File Cache

Index Management

Basic Index Management

Conditional Indexes

Advanced Index Management

Deferred Indexes

Deferred Data Handler

Advanced I/O Operations

Direct I/O [Peripheral-specific file I/O implementation]

Partial Record Reads/Writes

Enable shared memory performance enhancement for all Unix platforms
Extend leaf node read lock optimization to moving right or left at leaf level
Prevent server‑wide delays opening / closing files

Development and Ops Tools

Essential

Evolve

Enterprise

Scriptable & Graphical Server Administration and Logging Tools
Web Browser-based GUI tools
HTTP App Server
Plug-in support for easily enhancing database with custom features

Miscellaneous Features

Essential

Evolve

Enterprise

Full-text Search

Target Usage

The target usage of your application is also a consideration when determining the FairCom DB Server edition to use. Here are some questions to consider while you evaluate the table below:

  • Are you building an in-house application or are you an ISV?
  • Are you shipping to small or larger end users?
  • Are you deploying into an on-premise, hosted, or SaaS environment?

Essential

Evolve

Enterprise

Target Usage

• Redistribution by ISVs Targeting Small Companies

•  ISVs with SaaS Business Models

• Hosted Applications

• Redistribution by ISVs Targeting Small/Medium Companies

• Mission Critical

• High Throughput

•  ISVs with SaaS Business Models

•  Hosted Applications

•  Redistribution by ISVs Targeting Medium/Large Companies

Contact Us

×