FairCom proudly announces the latest release of c‑treeACE, the industry-leading NoSQL + SQL database. With over 300 enhancements to our c‑treeACE V10.0 product, we are highlighting our top 11 reasons to make c‑treeACE V11 your next smart decision. Examine 11 of the many ways the original multimodel database has matured into the most powerful NoSQL and SQL solution for your enterprise data.
Performance enhancements throughout the product provide an opportunity for a 20% gain over c‑treeACE V10, and close to 40% over V9. A new Delayed Durability mode for our full ACID-compliant transaction processing achieves up to a 300% gain by allowing a slight delay for log updates (sync’s) after the commit. Log entries are guaranteed to be saved before associated updates are written to disk.
For over 15 years, FairCom has blended SQL and NoSQL into an integrated database. A comprehensive set of APIs, both SQL and NoSQL, provide full read/write access to your data, making c‑treeACE the original multimodel database. Integrating SQL and NoSQL into a single solution, c‑treeACE delivers new capabilities that are not possible with any other database. With V11, we are expanding our full read/write SQL capabilities over your NoSQL data:
The database world is built on data integrity. Transaction control, often thought of as part of the relational SQL model, does not have to be only at the SQL level. c‑treeACE has shown that full ACID-compliant transaction control can be built-in at the lowest level, making it available to SQL and NoSQL APIs simultaneously. With decades of experience in ACID transactions over alternative data models, V11 adds to an impressive list of integrity-related features: Time Limited Data Flushing; Index Cache Pages; expanded File Verification facilities; Incremental Roll Forward / Automatic Recovery with Restore Points; improved Directory Metadata Flushing; and much more. Put your data in trusted hands.
With the costs of memory dropping, many demanding applications are turning to pure In-Memory Files to drive performance. FairCom’s c‑treeACE leverages our considerable experience with In-Memory Files, which are available as long as the file is open and the controlling c-tree Server instance is active. The exceptional throughput is measured in hundreds of thousands of records per second.
In addition to In-Memory Files, c‑treeACE offers unique granular cache controls: you can specify which files to cache; how much of each file to cache; which files to cache on startup; and more. With these controls, you can tune for in-memory read performance, while retaining the benefits of disk-based data persistence.
A partitioned file logically appears to be one data file (and its associated index files). It is actually a set of files whose contents are physically partitioned by the value of a partition key that can be based on a rule or expression. With growing data volumes, this feature is becoming one of the most interesting scaling choices for database performance. By dynamically splitting data over multiple physical entities, it is much easier to quickly purge or archive volumes of data. By combining our powerful built-in expression parser, we’ve extended conditional expressions to the creation of partitioned files. Now it’s easy to create partitioned files at will by defining your partition rule as a conditional expression when creating the file. An extended set of predefined functions allow extremely flexible rules. For example, partition by day of week, day of month, monthly, quarterly or yearly. Partitioned Files are now a dynamic ready to use feature for any deployment.
We are pleased to introduce Full-Text Search technology into our database engine. V11 initially offers searching at the file/record level on character/string data types. We intend on expanding this support to global database and/or session levels.
We strive to provide intimate data control to the application programmer. We expect developers will find our new Index & Record Maintenance features a hit.
To maximize performance, V11 provides Deferred Index Maintenance. You can defer the overhead of maintaining indexes as you modify records. Deferring index overhead when multiple indexes are present can yield solid performance gains. Trim the updating of every associated key with each Add, Delete, and Update.
Record Maintenance Callback Functions give you the power to call user-defined actions when a record is modified.
c‑treeAMS Replication Agent 2.0 introduces a new, multi-threaded design. Previously each connection needed 1 or 2 agents. Now a single agent can service multiple c‑treeACE connections, reducing overhead and simplifying deployment and administration.
c‑treeACE Replication Management Studio gives you a visual reflection over your entire replication solution, easily organizing complex topologies. Define “Publications” and “Subscriptions” for your data. Point and click to make your server connections. Better management for your replication environment.
V11 pays special attention to Java programmer needs:
Considerable focus has been invested in our implementation of stored procedures and triggers.
Our new .NET support adds an additional environment for developing stored procedures in C# or Visual Basic. Visual Studio templates enable easy development and deployment.
Our new NetBeans Plug-in simplifies stored procedure development in this easy-to-use Java IDE. The JDK is now needed only on the server used for developing and compiling.
New tools streamline deployment to multiple servers.
Want to Learn More about c-treeACE V11?