Technology Sized to Fit Your Need |
FairCom empowers you to select the edition of the database engine that best aligns with the business and technical requirements of your application and your target market.
Operating EnvironmentThe 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 |
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 |
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 |
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:
|
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 |