DB-EnginesExtremeDB: the embedded DBMS for embedded systemsEnglish
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Faircom EDGE

Faircom EDGE System Properties

Please select another system to compare it with Faircom EDGE.

Our visitors often compare Faircom EDGE with MongoDB, Redis and PostgreSQL.

Editorial information provided by DB-Engines
NameFaircom EDGE infoformerly c-treeEDGE
DescriptionFairCom EDGE is an Industry 4.0 solution built to integrate, collect, aggregate and synchronize mission-critical data in edge computing environments
Primary database modelKey-value store
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Rank#271  Overall
#42  Key-value stores
#123  Relational DBMS
Technical documentationlearn.faircomcorp.com/­developers/­documentation_directory
DeveloperFairCom Corporation
Initial release1979
Current releaseV3, October 2020
License infoCommercial or Open Sourcecommercial infoRestricted, free version available
Cloud-based only infoOnly available as a cloud serviceno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageANSI C, C++
Server operating systemsAndroid
Linux infoARM, x86
Data schemeFlexible Schema (defined schema, partial schema, schema free)
Typing infopredefined data types such as float or dateyes, ANSI Standard SQL Types
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yes
Secondary indexesyes
SQL infoSupport of SQLyes infoANSI SQL queries
APIs and other access methodsADO.NET
Direct SQL
IoT Microservice layer
MQTT (Message Queue Telemetry Transport)
Supported programming languagesC
Server-side scripts infoStored proceduresyes info.Net, JavaScript, C/C++
Partitioning methods infoMethods for storing different data on different nodesFile partitioning infoCustomizable business rules for partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoSynchronous and asynchronous realtime replication based on transaction logs
MapReduce infoOffers an API for user-defined Map/Reduce methodsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Tunable Consistency
Foreign keys infoReferential integrityyes infowhen using SQL
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID
Concurrency infoSupport for concurrent manipulation of datayes infoacross SQL and NoSQL
Durability infoSupport for making data persistentyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlFine grained user, group and file access rights managed across SQL (per ANSI standard) and NoSQL.
More information provided by the system vendor
Faircom EDGE infoformerly c-treeEDGE
Specific characteristics

FairCom EDGE provides the power of a full-featured database that is designed specifically for IoT applications that run at or near the point where the data is collected. With FairCom EDGE, developers can embed or integrate a fast, transaction-controlled database into an edge-computing application.

Since FairCom EDGE can store data near its collection point, such as sensors, it provides autonomy in situations when communication with the cloud or on-premise data centers are slow or unavailable. This database makes it easy to aggregate data locally and send data summaries to the cloud or remote data centers. FairCom EDGE also eliminates bandwidth concerns since large amounts of data are not required to be transmitted to the cloud or remote data centers.

Furthermore, FairCom EDGE IoT Database opens the door for applications to make real-time decisions, augmented by local, historical data.  Whether it is an Industry 4.0 factory, a smart hospital, or smart city scenario, edge computing can make these decisions faster, smarter and more efficient for different operations. A database is a critical component for such applications, which is where FairCom EDGE IoT Database can make a difference.

FairCom database technology is known for its ability to be used with a plethora of platforms and operating systems. FairCom EDGE IoT Database is no exception. It is software that runs on almost all operating systems, such as Windows, Windows IoT, Linux, macOS, Raspbian. Released in 32-bit and 64-bit editions, it supports Intel and ARM processors, such as the Raspberry Pi, industrial PCs (IPCs), laptops, and high-end servers. It also runs on specific IPCs with integrated PLCs, such as the Siemens Simatic Nanobox and the Rockwell Allen-Bradley CompactLogix 5480 Controllers. This flexibility results in having the ability to run EDGE IoT Database in almost any environment - in a factory, hospital, store, bus, cell tower, stop light, device, remote data center and in the cloud.

The FairCom EDGE IoT Database also comes with additional technologies that make it easier to build edge applications that collect, transform, enhance, store, forward, and integrate data. These include a MQTT Broker, a REST API, Data Replication, RPC interfaces, and an App Server. These technologies are fully integrated with the database and each other, which makes the whole greater than the sum of the parts.

Through the embedded MQTT Broker, developers can use FairCom EDGE IoT Database to automatically store messages by simply exchanging messages with the database. When subscribers are inaccessible or with connectivity issues, FairCom EDGE will automatically forward those messages when subscribers are again available, guaranteeing data deliverability, and preserving the autonomous operation of the edge application. The REST API automatically makes collected data available to authorized applications, while use of FairCom Replication continuously clones data from a source database to one or more target databases. Finally, with the App Server developers can automatically serve up browser-based applications.

Also available to FairCom EDGE developers in a version dedicated to integration and data management, FairCom EDGE IIoT Hub. Specifically designed for the new Industry 4.0 edge computing applications,  the EDGE IIoT Hub includes the IoT Database plus a browser-based graphical user interfaces for point-and-click integration between MQTT, OPC UA, REST, SQL, and ThingWorx, a leading IIoT solution. It can store data near its collection point, such as data from factory equipment and sensors, as well as be used to send and receive data between the cloud and data centers. With little-to-no code, organizations can connect, monitor, and control factory equipment, PLCs, and sensors.

Competitive advantages
Top Features
  • JSON
  • Multimodel SQL and NoSQL APIs
  • Automatic database tuning
  • Custom control from ACID-compliant to Eventually Consistent
  • User-configurable balance between speed, atomicity, consistency, isolation and durability
  • Parallel synchronous replication for high availability
  • Parallel asynchronous replication for massive scalability and disaster recovery
  • Supports all major programming languages, platforms and operating systems
  • MQTT topics store and forward
  • Graphical user interface
  • ThingWorx integration: Visual data mapping, automatic modeling, automatic updates and many more via native AlwaysOn protocol
  • Massively parallel data replication: Asynchronous, N-to-M schemas, automatic replication and drag and drop management and many more
  • Automatic data aggregation: User-defined length, retention and functions and numeric data aggregation                         
  • OPC-UA Client: Certified OPC-UA client, binary protocol for better performance and improved security and SDK for custom integration
  • SQL: ANSI SQL with ODBC and JDBC and integration with all BI and analytic tools
  • Browser-based database administration: ISAM Explorer, SQL Explorer and Database Monitor

Key Benefits of FairCom EDGE

  • Data storage on the edge: Keep mission-critical data close to the source
  • Mission-critical ops: Enable real-time IoT decision making
  • Fast: High-speed data collection at the edge
  • Data quality control: Guarantee data quality using transactional edge persistence
  • IoT specific: Built for IoT applications to run on major operating systems and hardware platforms
  • Security: Transmit only the data needed and store all data securely encrypted at the edge
  • Database as a microservice: Uses both SQL and NoSQL microservices to collect, query and analyze data in real time for IoT systems
  • Analytics-tool neutral: Compatible with nearly all analytics tools for use over actual real-time unstructured data
  • Micro footprint of 40 MB or less based on configuration
  • Easy graphical user interface (GUI): Intuitive and user friendly
  • Automatic data fabric/mesh network - Data replication, PLC, MQTT, REST, OPC, SQL
  • Automatic data processing: Map, convert, transform, store, forward and replicate
  • Automatic data conversion: JSON, SQL, tables, time-series, C structures and more PLC more
  • Increase factory uptime: Add data redundancy across all processes
  • Access data anywhere: Across the factory floor or via private or public cloud
  • Leverage critical data cached in factory controllers: Recipes, parts, machine learning, operations history and more. Operator documentation: process, troubleshooting and more
  • Integrate factory data with IT apps/databases: Merge protocols: MQTT, REST, OPC, SQL, Replication, PLC and more. Merge data: Map, convert, transform, store, forward, replicate, data between JSON, SQL tables, time-series, C structures, PLC and more
Typical application scenarios

FairCom EDGE can be deployed at or near the data collection point (sensors) and used to store, manage data and transmit data to the cloud and/or data centers. 

FairCom EDGE can also be used in Industrial IoT environments (such as manufacturing plants, power plants, transportation command centers) to easily integrate systems.

Key customers

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

Market metrics
  • From banking and financial transactions, transportation, warehouse automation, package delivery, medical, legal, healthcare, and many others. FairCom reliably powers database operations in more than 100,000,000 instances.
  • Global reach with customers in more than 100 countries
  • Customers provide FairCom with a 95.3% 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 EDGE are flexible to meet operation requirements, so are the purchasing options. 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
Faircom EDGE infoformerly c-treeEDGE
Recent citations in the news

FairCom kicks off new era of database technology USA - English Brazil - Português
10 November 2020, PRNewswire

Thoma Bravo to Acquire Talend for $2.4 Billion
11 March 2021, EnterpriseTalk

provided by Google News

Job opportunities

Office Assistant
FairCom, Sandy, UT

Account Executive
FairCom, Salt Lake City, UT

Director of Sales
FairCom, Salt Lake City, UT

Software Engineer
FairCom, Salt Lake City, UT

Senior Software Engineer
FairCom, Salt Lake City, UT

jobs by Indeed

Share this page

Featured Products

Couchbase logo

Power, flexibility & scale.
All open source.
Get started now.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Present your product here