DB-EnginesCrateDB bannerEnglish
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > c-treeACE

c-treeACE System Properties

Please select another system to compare it with c-treeACE.

Our visitors often compare c-treeACE with Microsoft SQL Server, MongoDB and Redis.

Editorial information provided by DB-Engines
DescriptionHigh speed key-value store, desgined for high availability, mission critical applications with automatic recovery and immediately consistent transaction support.
Primary database modelKey-value store
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Rank#207  Overall
#37  Key-value stores
#99  Relational DBMS
Technical documentationlearn.faircomcorp.com/­developers/­documentation_directory
DeveloperFairCom Corporation
Initial release1979
Current releaseV11.5, November 2017
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 systemsAIX
Windows infoeasily portable to other OSs
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.no
Secondary indexesyes
SQL infoSupport of SQLyes infoANSI SQL queries
APIs and other access methodsADO.NET
Direct SQL
Supported programming languages.Net
Visual Basic
Server-side scripts infoStored proceduresyes info.Net, JavaScript, C/C++
Partitioning methods infoMethods for storing different data on different nodesFile partitioning, horizontal partitioning, sharding infoCustomizable business rules for table 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
Specific characteristics
Speed, reliability and consistency are the reasons businesses choose FairCom’s c-treeACE multimodel-database management solution for mission-critical tasks. These attributes are at the core of the c-treeACE foundation that powers fast indexing technology for high-performance NoSQL and industry-standard SQL within the same application, over the same single-instance of data. This is why more than 40 members of the Fortune 100 trust c-treeACE technology for their database management.

Since a database is a long-term investment, c-treeACE is designed and built to evolve with applications as business needs and technologies change. Developers can easily configure their database to meet the routine and difficult challenges that are unique to their organizations. c-treeACE is highly configurable, with more than 500 parameters that allow tight calibration, enabling system administrators to maintain strict security and a delicate balance of performance vs. reliability unique to each business.

c-treeACE empowers developers to take full advantage of an immediately consistent ACID-compliant transaction engine, across any combination of more than 20 NoSQL and SQL APIs/drivers, all over a single instance of your data. This multimodel database ability provides simultaneous access to a single instance of data with the high degree of control and performance of a NoSQL database -- combined with ease of enterprise integration, web and mobile platforms through standards based on SQL APIs and drivers -- is one of many reasons leading global companies trust c-treeACE with their database needs.

Mission-critical systems require integration with multiple and diverse applications, programming languages, and operating systems. c-treeACE is available for more than 20 platforms, including real-time operating systems, and offers more than 20 APIs in a variety of development environments, both SQL and NoSQL. After deployment, c-treeACE requires low database administration to maintain a high level of performance with minimum resources, dramatically reducing total cost of ownership (TCO) while running these mission-critical systems at maximum capacity at all times.

The most current version, c-treeACE V11.5, has new features that significantly reduce downtime when changes are required. One such feature is Hot Alter Table, which enables application schema changes with little or no interruption to database operations, eliminating multi-hour file conversions.

High availability and disaster recovery (HA/DR) are easily accomplished through the c-treeACE Replication Management solution that provides near real-time replication through several topologies, including hub-spoke, chain replication, single and two-way replication. c-treeACE Replication operates from the transaction logs, and therefore requires minimum bandwidth, reducing latency to milliseconds.​
Competitive advantages
Top Features
  • High-speed transaction processing
  • Immediately consistent, ACID-compliant, across all APIs
  • NoSQL key-value store with advanced features like automatic recovery, roll-forward and roll-back support, dynamic index rebalancing, conditional indexes, data filters, user defined functions, etc.
  • Highly configurable database that allows precision tuning for ultra-high performance and durability
  • Real-time replication with low bandwidth for HA/DR
  • Support for multiple platforms and operating systems
  • Cloud-neutral: Can run on all major public cloud and private data center platforms
Key Benefits
  • Low TCO with maximized performance and efficiency
  • Mission-critical-by-design, with HA/DR capabilities embedded across the technology
  • Advanced encryption for data storage, access and communication
  • Perfect combination of speed, durability and flexibility allows organizations to overcome their unique challenges
  • Flexible support program, with a 24-hour, 7-day, 365-day option available
  • Support for developers, by developers​
Typical application scenarios
c-treeACE speed, reliability, and flexibility are direct reasons this technology has been adopted by organizations of all sizes: ranging from small and medium-sized to some of the world’s largest enterprise companies.

Some installations routinely operate with throughput speed measured in the hundreds of thousands of transactions per second. One such install routinely has 500-plus concurrent connections, with more than 25,000 open files, and obtains transactions rate of more than 375,000 transactions per second, 24 hours a day, 7 days a week, 365 days per year.

These valuable benefits are also reasons c-treeACE is used in a plethora of industries and government sectors: financial, 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.
Key customers

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

Market metrics
  • From banking and financial transactions, transportation, warehouse automation, package delivery, medical, legal, healthcare, and many others. c-treeACE 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: www.gartner.com/reviews/review/view/486105
Licensing and pricing models

Just as the technical aspects of c-treeACE are flexible to meet operation requirements, so are the purchasing options. FairCom offers three editions of the c-treeACE Server - Essential, Evolve and Enterprise. A stand-alone version of c-treeACE is also available. Contact a FairCom sales representative for pricing and licensing information at sales at FairCom.com.

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 and Software AG sign new contract for c-treeACE Database
22 March 2019, PRNewswire

FairCom names new senior sales director
27 January 2020, PRNewswire

FairCom to feature #ctreeEDGE IoT Database at LiveWorx19
4 June 2019, PRNewswire

FairCom joins INCITS committee that defines GQL, SQL standards
21 January 2020, Yahoo Finance

FairCom, creators of c-treeACE NoSQL Database, Expands Operations to Silicon Slopes, Utah
1 July 2015, PR Web

provided by Google News

Job opportunities

Business Development Representative
FairCom, Salt Lake City, UT

jobs by Indeed

Share this page

Featured Products

Couchbase logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

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