DBMS > Faircom DB

Faircom DB System Properties

Please select another system to compare it with Faircom DB.

Our visitors often compare Faircom DB with Microsoft SQL Server, Couchbase and MariaDB.

Editorial information provided by DB-Engines

Name

Description

Native high-speed multi-model DBMS for relational and key-value store data simultaneously accessible through SQL and NoSQL APIs.

Primary database model

Key-value store
Relational DBMS

DB-Engines Ranking measures the popularity of database management systems
Trend Chart

Score	0.28
Rank	#347	Overall
	#51	Key-value stores
	#149	Relational DBMS

Website

www.faircom.com/products/faircom-db

Technical documentation

learn.faircomcorp.com/developers/documentation_directory

Developer

FairCom Corporation

Initial release

1979

Current release

V12, November 2020

License

Commercial or Open Source

commercial

Restricted, free version available

Cloud-based only

Only available as a cloud service

DBaaS offerings (sponsored links)

Database as a Service

Providers of DBaaS offerings, please contact us to be listed.

Implementation language

ANSI C, C++

Server operating systems

AIX
FreeBSD
HP-UX
Linux
NetBSD
OS X
QNX
SCO
Solaris
VxWorks
Windows

easily portable to other OSs

Data scheme

schema free, schema optional, schema required, partial schema,

Typing

predefined data types such as float or date

yes, ANSI SQL Types, JSON, typed binary structures

XML support

Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.

Secondary indexes

yes

SQL

Support of SQL

yes, ANSI SQL with proprietary extensions

APIs and other access methods

ADO.NET
Direct SQL
JDBC
JPA
ODBC
RESTful HTTP/JSON API
RESTful MQTT/JSON API
RPC

Supported programming languages

.Net
C
C#
C++
Java
JavaScript (Node.js and browser)
PHP
Python
Visual Basic

Server-side scripts

Stored procedures

yes

.Net, JavaScript, C/C++

Triggers

yes

Partitioning methods

Methods for storing different data on different nodes

File partitioning, horizontal partitioning, sharding

Customizable business rules for table partitioning

Replication methods

Methods for redundantly storing data on multiple nodes

yes, configurable to be parallel or serial, synchronous or asynchronous, uni-directional or bi-directional, ACID-consistent or eventually consistent (with custom conflict resolution).

MapReduce

Offers an API for user-defined Map/Reduce methods

Consistency concepts

Methods to ensure consistency in a distributed system

Eventual Consistency
Immediate Consistency
Tunable consistency per server, database, table, and transaction

Foreign keys

Referential integrity

yes

Transaction concepts

Support to ensure data integrity after non-atomic manipulations of data

tunable from ACID to Eventually Consistent

Concurrency

Support for concurrent manipulation of data

yes

Durability

Support for making data persistent

Yes, tunable from durable to delayed durability to in-memory

In-memory capabilities

Is there an option to define some or all structures to be held in-memory only.

yes

User concepts

Access control

Fine grained access rights according to SQL-standard with additional protections for files

More information provided by the system vendor

Specific characteristics

Achieve Hundreds of Thousands of Transactions Per Second

on A Single Database Server and Scale to Hundreds of Servers

FairCom DB gives developers total control to achieve unprecedented performance. It is also self-tuning for the lowest total cost of ownership (TCO).

FairCom DB is ideal for large-scale, mission-critical, core-business applications that require performance, flexibility and capabilities that cannot be achieved by other databases. It is the database of choice for 42 percent of the Fortune 100. It is the best kept secret of the database industry because of the competitive advantage it offers.

Predictable high-velocity transactions are a hallmark of FairCom DB. It empowers developers with easy NoSQL APIs in their favorite programming languages to process structured binary data at machine speed using custom algorithms, and it provides ANSI SQL over the same binary data for easy queries, analytics, and integration with SQL tools. Further, it provides high-speed data replication to create massively scaled solutions with a continuum of control from ACID compliant to eventually consistent.

Multiple Models

FairCom DB supports Relational and Object Models. The data in either model is available simultaneously through SQL and NoSQL. Its NoSQL NAV APIs give the developer full control over every aspect of storing, indexing, querying and navigating across all data.

• The Relational Model is backed by a fast and mature index, join and filter engine that provides standard ANSI SQL.

• The Key-value Store Model stores, indexes, queries and navigates binary structures. The entire contents of a record can be a binary structure of any type, and the database can index one or more parts of it. For example, a record can contain raw object data or a binary structure. It can also contain serialized data, such as BSON, Avro, Google Protocol Buffers, Google FlatBuffers, MessagePack, etc.

Custom Data Algorithms

Developers use FairCom’s NAV API to navigate data from within their favorite programming language including Java, Python, C#, C++, C, Cobol, JavaScript (Node.js and browser), PHP, and Visual Basic. This API literally “remote controls” the database. This makes the database an extension of the developer’s code. A developer can use their favorite programming language to create any algorithm to process data – including graph algorithms. Unlike other SQL and NoSQL databases, FairCom DB does not limit a developer to a few built-in data processing algorithms.

Some customers continuously operate FairCom DB at hundreds of thousands of transactions per second. One such customer consistently has 500-plus concurrent connections with more than 25,000 open tables and obtains more than 375,000 transactions per second, 24 hours a day, 7 days a week, 365 days per year.

Custom Architectures

FairCom DB runs on the largest servers as a traditional database server. It also runs well embedded inside applications. And most importantly, it can be used in both ways simultaneously to deliver powerful solutions like no other database.

For example, FairCom DB can be embedded inside each app server for extremely fast local data processing of cached data. It can also run as a traditional centralized database for all app servers to use simultaneously. Further, built-in data replication can automatically replicate data between the central database server and the embedded databases. This combination of centralized and decentralized processing allows applications to achieve unprecedented performance and availability.

Custom Clustering

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, high availability, eventual consistency, ACID compliance, and anywhere in between.

Implement any cluster scenario including:

• Eventually consistent

• ACID-compliant

• High availability

• Disaster recovery

• Massive horizontal scale with read-only and read-write shards

• Globally distributed data with local reads and writes

• Etc.

Control replication at all levels from individual tables to entire databases. Publish data once and subscribe to the publication many times across many servers.

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.

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. FairCom Replication can also be automated through a JSON/HTTP web service API and a C/C++ API.

Low TCO

FairCom DB dramatically reduces TCO. It requires little-to-no database administration and runs on less expensive hardware while delivering exceptional performance and high availability.

For example, the database’s indexes and tables automatically tune themselves. Hot Alter Table enables users to perform schema changes instantly against huge tables with no need to run multi-day background conversion processes that degrade performance. Forty years of fine-tuning makes the engine run efficiently and quickly on less expensive hardware. On high-end hardware, its performance is unparalleled. Lastly, its easy-to-use SQL and NoSQL APIs make developers highly productive at solving the most complex of data processing challenges.

Competitive advantages

Top Features

SQL
Key-value store and navigational NoSQL API
Indexed binary objects and structures
JSON
Automatic database tuning
Custom control from ACID-compliant to Eventually Consistent
User-configurable balance between speed, atomicity, consistency, isolation and durability
Bi-directional replication for eventual consistency
Parallel synchronous replication for high availability
Parallel asynchronous replication for massive scalability and disaster recovery
Supports all major programming languages, platforms and operating systems

Key Benefits

Exceptional performance and scale
Your custom algorithms process data at high speed for a unique competitive edge
Outstanding customer support
Lowest total cost of ownership (TCO)
- Low software costs
- Low hardware costs because of its extremely efficient and fast data processing
- Almost no database administration costs with its automatic ability to tune and heal itself
- Maximal developer productivity – easy APIs with the ability for total control when needed
- Built-in data replication for high availability and horizontal scalability

Typical application scenarios

Real-time transaction processing solutions leverage FairCom DB because its NoSQL engine delivers predictable high velocity performance. Large stock market, logistics, and semiconductor companies use FairCom DB in this way to run their core business.

Metadata is at the heart of large applications, such as enterprise resource planning (ERP) and medical management and logistics solutions. Metadata drives the business rules of the application and makes it customizable. FairCom DB is often used as the metadata engine at the core of applications because of its exceptionally fast in-memory performance and its ability to be embedded inside an application.

Microservices leverage FairCom DB’s ability to embed the database inside each app server for true horizontal scale, data independence, and unprecedented performance. They use FairCom DB’s built-in data replication to ensure critical data changes are delivered synchronously across app servers and less-critical changes are delivered asynchronously. Large telecom and financial corporations use FairCom DB in this way.

Problems no other database can solve are regularly solved by FairCom DB. This is not a marketing slogan. FairCom DB’s NoSQL API remote controls all aspects of data processing. This allows developers to implement any algorithm to process data – and do it at remarkable speed. FairCom DB does not impose any restrictions on a developer’s ingenuity and it provides a proven NoSQL API that has been fine-tuned and improved for 40 years to make developers highly productive.

Key customers

Microsoft, UPS, Verizon, Motorola, Commvault, Thomson Reuters, ACI, BNY Mellon, Rockwell Automation, FICO, SS&C, Abacus, Tealeaf, Henry Schein, CA Technologies, Zeiss, IBM, U.S. FAA.

FairCom DB is used in a wide variety of industries and government agencies including finance, healthcare, telecommunications, manufacturing automation, accounting, legal, dental, education, construction, aerospace, trucking, gaming, space exploration, oil and gas, energy, major league baseball, fraud detection, public safety and infrastructure management.

Market metrics

From banking and financial transactions, transportation, warehouse automation, package delivery, medical, legal, healthcare, and many others.
More than 100,000,000 deployments of FairCom databases.
Global reach with customers in more than 100 countries.
95.3% customer satisfaction rate.
The FairCom Technical Support Team received a 97.2% satisfaction rate from customers
Highly regarded by users on third-party sites: Gartner Reviews

Licensing and pricing models

Just as the technical aspects of FairCom DB are flexible to meet operation requirements, so are the purchasing options. FairCom comes in multiple editions to meet your specific needs. Contact FairCom for pricing and licensing information info@faircom.com or 1-573-445-6833.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources

Recent citations in the news

FairCom kicks off new era of database technology USA - English
10 November 2020, PR Newswire

Shane Johnson Joins FairCom as Head of Marketing
16 June 2021, The Fast Mode

c-treeAMS: Replication - FairCom
6 June 2023, faircom.com

FairCom MQ | Robust MQTT Broker | Embedded Database
20 April 2023, faircom.com

FairCom EDGE | Database for IoT | FairCom
20 April 2023, faircom.com

provided by Google News

Job opportunities

Senior Software Engineer
FairCom, Columbia, MO

Digital Media Coordinator
FairCom, Salt Lake City, UT

Digital Media Coordinator
FairCom, Columbia, MO

Software Engineer
FairCom, Columbia, MO

jobs by

Share this page