Posted By: Brad Thomas
Latest version provides users with faster performance and valuable new features
Part 1: SQL
Note: This is the first in a series about the benefits of upgrading from a legacy version of c-tree to a current version.
For 40 years, FairCom’s c-tree Database Engine has provided customers with uncompromising speed, reliability and capabilities. In fact, FairCom’s database (which started as c-tree and evolved to c-tree Plus and today is c-treeACE) is so reliable that some of you are using versions that date back to the early 1980s. Our new versions continue a legacy of reliability and have maintained backwards compatibility to ensure you have a quick and easy upgrade process.
Why should you upgrade when your legacy version of c-tree is working? The answer is simple: By remaining on a legacy version, you are missing out on important bug fixes, security fixes, security features, performance improvements and support that make your system even more reliable. c-treeACE’s new features provide more value to developers and users at lower cost.
Enhanced SQL capabilities is one area that your organization will greatly benefit from by upgrading to the current version of c-treeACE, especially if you are using c-tree V6.11 or older. First, the current version is a full 92 and partial 99 ANSI-compliant SQL database engine, with stored procedures, triggers, user-defined functions, etc. With minimal work to upgrade, your developers and customers can leverage SQL to query the data in your ISAM files, without changes to your existing application. This is because FairCom’s technology seamlessly translates non-standard data types into SQL data types.
One of the best attributes of SQL is that it is the most productive software development language for querying data, and, thus, it greatly increases development speed. However, there is a tradeoff: At times, complex SQL queries become difficult and slow. To enable you to overcome these overly complex and slow queries, c-treeACE provides APIs, such as NAV, ISAM and CTDB, that provide you with the direct control you need for high velocity data processing. This gives you the best of both worlds over the same data: SQL for productivity and FairCom’s APIs for extreme performance.
ODBC and JDBC enable your application, if you so choose, to expose data in the c-tree Database Engine to all major industry standard tools. With little-to-no extra work, you can allow users of your application to perform data analytics, create dashboards, generate reports, run ad hoc queries and integrate data into other systems. Solutions that c-treeACE works well with include Microsoft Power BI, Microsoft Excel, Microsoft Access, Tableau, ThoughtSpot, Qlik, Sisense, Salesforce, SAP, etc. It also works with data integration tools that extract, transform and load data (ETL), such as Informatica, IBM, SAP, Talend, SAS, Oracle, etc.
Here are other SQL-related benefits you can utilize by upgrading to the current version of c-treeACE:
- Use SQL to query and update non-standard or legacy data types of all varieties. The FairCom Database Engine allows you to store any type of binary data in its tables, such as custom date and time formats, COBOL data records, etc. You can tell c-tree to translate this data automatically into standard SQL data types. This allows SQL to transparently and automatically read and write to non-standard data types.
- Use ODBC for UNIX and Linux. It allows the FairCom Database Engine running on Unix and Linux to share data with the vast array of standard SQL tools that use ODBC.
- Run SQL on top of a file that contains multiple record formats. c-treeACE automatically detects each type of record and treats it as a separate SQL table, preventing the need to normalize existing data to comply with the SQL standard.
If you want learn how easy it is to upgrade from a legacy version of c-tree to a current version, please contact us at 1-800-234-8180 or email@example.com.
*TIOBE Index as of June 2019.