Welcome!

IBM Cloud Authors: Yeshim Deniz, Elizabeth White, Pat Romanski, Liz McMillan, Stefan Bernbo

News Feed Item

FairCom’s Newest c-treeACE® Bridges SQL, NoSQL Worlds

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 (Photo: Business Wire)

c-treeACE V10 (Photo: Business Wire)

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.

About FairCom

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.

Photos/Multimedia Gallery Available: http://www.businesswire.com/cgi-bin/mmg.cgi?eid=50473561&lang=en

More Stories By Business Wire

Copyright © 2009 Business Wire. All rights reserved. Republication or redistribution of Business Wire content is expressly prohibited without the prior written consent of Business Wire. Business Wire shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon.

IoT & Smart Cities Stories
The deluge of IoT sensor data collected from connected devices and the powerful AI required to make that data actionable are giving rise to a hybrid ecosystem in which cloud, on-prem and edge processes become interweaved. Attendees will learn how emerging composable infrastructure solutions deliver the adaptive architecture needed to manage this new data reality. Machine learning algorithms can better anticipate data storms and automate resources to support surges, including fully scalable GPU-c...
Machine learning has taken residence at our cities' cores and now we can finally have "smart cities." Cities are a collection of buildings made to provide the structure and safety necessary for people to function, create and survive. Buildings are a pool of ever-changing performance data from large automated systems such as heating and cooling to the people that live and work within them. Through machine learning, buildings can optimize performance, reduce costs, and improve occupant comfort by ...
The explosion of new web/cloud/IoT-based applications and the data they generate are transforming our world right before our eyes. In this rush to adopt these new technologies, organizations are often ignoring fundamental questions concerning who owns the data and failing to ask for permission to conduct invasive surveillance of their customers. Organizations that are not transparent about how their systems gather data telemetry without offering shared data ownership risk product rejection, regu...
René Bostic is the Technical VP of the IBM Cloud Unit in North America. Enjoying her career with IBM during the modern millennial technological era, she is an expert in cloud computing, DevOps and emerging cloud technologies such as Blockchain. Her strengths and core competencies include a proven record of accomplishments in consensus building at all levels to assess, plan, and implement enterprise and cloud computing solutions. René is a member of the Society of Women Engineers (SWE) and a m...
Poor data quality and analytics drive down business value. In fact, Gartner estimated that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. By eroding trust in information, analytics and the business decisions based on these, it is a serious impediment to digital transformation.
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing smart devices with AI and BlockChain capabilities prepare to refine compliance and regulatory capabilities in 2018. Volumes of health, financial, technical and privacy data, along with tightening compliance requirements by...
Predicting the future has never been more challenging - not because of the lack of data but because of the flood of ungoverned and risk laden information. Microsoft states that 2.5 exabytes of data are created every day. Expectations and reliance on data are being pushed to the limits, as demands around hybrid options continue to grow.
Digital Transformation and Disruption, Amazon Style - What You Can Learn. Chris Kocher is a co-founder of Grey Heron, a management and strategic marketing consulting firm. He has 25+ years in both strategic and hands-on operating experience helping executives and investors build revenues and shareholder value. He has consulted with over 130 companies on innovating with new business models, product strategies and monetization. Chris has held management positions at HP and Symantec in addition to ...
Enterprises have taken advantage of IoT to achieve important revenue and cost advantages. What is less apparent is how incumbent enterprises operating at scale have, following success with IoT, built analytic, operations management and software development capabilities - ranging from autonomous vehicles to manageable robotics installations. They have embraced these capabilities as if they were Silicon Valley startups.
As IoT continues to increase momentum, so does the associated risk. Secure Device Lifecycle Management (DLM) is ranked as one of the most important technology areas of IoT. Driving this trend is the realization that secure support for IoT devices provides companies the ability to deliver high-quality, reliable, secure offerings faster, create new revenue streams, and reduce support costs, all while building a competitive advantage in their markets. In this session, we will use customer use cases...