Posted By: David Faust
For the First Time, Developers can Map Non-relational Data as Relational (SQL), Without Modifying the Data, and Realize Significant Performance Gains
Columbia, Mo. – November 12, 2012 – FairCom, a database company that builds high-performance, engineering-level database technology, today announced the tenth major edition of its cross-platform database technology, c‑treeACE® V10, that introduces the industry’s first Relational Multi-Record Type support for seamless integration between relational and non-relational database worlds.
c‑treeACE V10 also delivers features such as new Java interfaces, performance and scalability enhancements, additional platform support, and new replication models. With this latest version come significant performance gains including 30 percent faster transaction throughput, 60 percent faster SQL performance, 200 percent better replication throughput, and 26 percent faster read performance.
“The database market is growing substantially, yet there are many problems plaguing developers today: large data volumes; requirements to reduce data access time; data access requirements from a myriad of new locations, like mobile devices and the cloud; trickier integration; and decreasing budgets,” said Randal Hoff, FairCom’s VP of Engineering. “Engineers tell us they really need technology that enables them to work seamlessly within both the relational and non-relational worlds. In the past, they’ve felt forced to choose one or the other, when, in fact, they realize concrete benefits from both. Our newest c‑treeACE gives them the flexibility to enjoy the best of both worlds: high performance data throughput levels that a NoSQL database can provide; and concurrent relational access for ease of data sharing with other parts of the enterprise, including cloud and mobile devices, all at a reasonable price point.”
For more than 30 years, FairCom has provided a unique model to enterprise database developers and ISVs not available from off-the-shelf databases. Its c‑treeACE offers the highest levels of tailored configuration and control while simultaneously supporting a variety of non-relational API’s (e.g., ISAM, .NET, and JTDB) along with industry-standard relational API’s (e.g., SQL, JDBC, ODBC, PHP, Python, etc.) within the same application, over the same data. Enterprises such as Federal Express, Microsoft, NASA and Visa have used FairCom technology in mission-critical solutions.
“FairCom’s flexible approach allows us to take advantage of new technologies at our own pace, never forcing us to rewrite our old code before we or our customers are ready to,” said Ron Stoll, president, BoxWorks Technologies, Inc., a FairCom customer that trialed a pre-release c‑treeACE V10. “With c‑treeACE, we can continue to realize the benefits of our legacy interfaces while adding newer interfaces such as SQL and PHP. Reports that used to take three minutes to run now take just over one minute, with c‑treeACE V10’s new ‘shared memory’ functionality. This is a major savings of cost and time for our customers who typically run hundreds of reports many times throughout the day.” Customers use tailored software from BoxWorks, integrated with FairCom’s c‑treeACE, for automated generation of inventory reports, transaction histories, and tracking reports that crunch through volumes of records requiring continual communication between the c‑treeACE SQL server and the clients.
An industry-first, Relational Multi-Record Type Support maps non-relational, proprietary data records into relational formats, opening these unique file formats to industry-standard SQL without the need to change existing data. This allows for the mapping of non-relational data into relational models “on-the-fly,” while preserving the existing code, thus improving performance while minimizing the risk of a full-blown data migration.
Other standout features are new Java-based GUI administration tools and a new record-oriented Java interface, which provides native Java implementation on top of an ISAM API which has shown 30-40 percent performance gains over typical functionality that has been coded using JDBC. Few other vendors offer this level of NoSQL Java support, resulting in greater programmer control and thereby greater throughput.
Additional c‑treeACE V10 features include:
- Data Filter Stacks–Users “stack” data record filters over the same data file for precise data access at runtime.
- Thread Impersonate–Users “toggle” between SQL and ISAM code within applications.
- Data Compression–Developers choose industry-standard compression algorithms, or use their own compression technology, for controlling the precise balance between performance and size of data.
- Automatic Recovery Enhancements–Users may redirect files during automatic recovery; expanded recovery logging.
Replication Enhancements–Flexible set of facilities for data replication among servers and clients.
FairCom supports major hardware platforms and operating systems ranging from Microsoft Windows, Linux and Mac OS X to IBM AIX and Oracle Solaris. New with V10 is formal support for Mac OS X 10.7 (Lion) and 10.8 (Mountain Lion), Microsoft Windows® 8 and Microsoft Windows® Server 2012, and the latest compiler suites such as Microsoft Visual C 2012 (Visual Studio), and Embarcadero XE2 and XE3. Additionally, c‑treeACE V10 supports more than 20 APIs/languages, provides among the industry’s lowest total cost of ownership (TCO), has minimal hardware requirements, and imposes little-to-no DBA overhead.
FairCom c‑treeACE V10 is available now. Pricing is based on customer requirements, including the number of users, CPUs, and server type.
For more than 30 years, FairCom has built high-performance, engineering-level database technology that empowers developers to meet their specific data management requirements. With low licensing costs, minimal hardware requirements, and little-to-no DBA overhead, FairCom delivers one of the database industry’s lowest total costs of ownership (TCO). Its flagship product, c‑treeACE, provides the most robust solution for ISAM and SQL, allowing developers to enjoy the optimal mix of each technology’s unique performance and ease of data sharing benefits. Thousands of ISVs and 43 percent of the Fortune 100 have selected c‑treeACE to power their applications, including Federal Express, Microsoft, NASA and Visa. FairCom is headquartered in Columbia, Mo., with offices in Europe, South America and Asia (Japan). For more information, visit www.faircom.com.