DBMS > Faircom DB
Faircom DB System Properties
Please select another system to compare it with Faircom DB.
|Editorial information provided by DB-Engines|
|Name||Faircom DB formerly c-treeACE|
|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|
|Current release||V12, November 2020|
|License Commercial or Open Source||commercial Restricted, free version available|
|Cloud-based only Only available as a cloud service||no|
|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|
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.||no|
|SQL Support of SQL||yes, ANSI SQL with proprietary extensions|
|APIs and other access methods||ADO.NET|
RESTful HTTP/JSON API
RESTful MQTT/JSON API
|Supported programming languages||.Net|
|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||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Eventual 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|
|Faircom DB formerly c-treeACE|
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.
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
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.
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.
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
• High availability
• Disaster recovery
• Massive horizontal scale with read-only and read-write shards
• Globally distributed data with local reads and writes
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.
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.
|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.
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.
|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 firstname.lastname@example.org 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.
|Faircom DB formerly c-treeACE|
|Recent citations in the news|
FairCom Lives 2021 on the 'Edge' with IoT Data Management Solution
provided by Google News
Technical Account Manager
QA Engineer (Hybrid)
Director of Product
Senior Technical Account Manager
Share this page