FairCom Corporation
 
FairCom Start PageFairCom ProductsDownloadsDeveloper SupportSales InformationFairCom CustomersFairCom Company InformationContact FairCom

Homebulletgrey.gifProductsbulletgrey.gifSQL Enhancements


c-treeACE SQL Enhancements

c-treeACE SQL has undergone extensive enhancements in both performance and features. The query optimizer engine underwent a major analysis and many queries now run exponentially faster. Many language constructs were added to make c-treeACE SQL more flexible than ever as well. Additional scalar functions provide convenient operations with data of all types.

New and Enhanced Functionalities

  • Stored Procedures, Triggers, and User Defined Functions are Included by Default
  • Included Built-In Stored Procedures
  • Improved Stored Procedure Handling
  • Automatic Shared Memory Protocol with Local Windows Clients
  • FairCom Security Handshake for c-treeACE SQL Clients
  • c-treeACE SQL Client Connection and Login Timeout Support
  • Advanced Encryption for Tables
  • A new TRUNCATE Table function
  • Now Supports Transaction Isolation Levels 1 and 2
  • Many New Scalar Functions
  • Advanced Seaching of LVARCHAR Fields with the CONTAINS Clause
  • Complete RIGHT OUTER JOIN Syntax Added

Performance Enhancements

  • Huge Performance Gains in Complex Query Performance
  • Query Timeout Option to Prevent Long Running Queries
  • Diagnostic Logging of Query Times

Utilities

  • Utility Option to Copy a Database
  • Types SDK for ISAM Compatibility
  • c-treeACE ISAM to SQL Migration Toolkit

Many More ...

Complete Online Documentation

Complete information for all of the updated c-treeACE SQL features are available in the updated manuals available online.

c-treeACE SQL Reference Guide

c-treeACE SQL Java Stored Procedures, Triggers and User Defined Functions Guide

c-treeACE SQL ODBC Developer’s Guide

c-treeACE SQL JDBC Developer’s Guide

c-treeACE SQL ISQL Tools and Reference Guide

c-treeACE SQL ADO .NET Data Provider Developer’s Guide

c-treeACE SQL PHP Developer’s Guide

c-treeACE SQL Direct SQL Developer’s Guide

c-treeDBX Developer’s Guide

Follett Software Company utilizes FairCom technology as part of their Catalog Plus and Circulation Plus library automation systems. Catalog Plus offers powerful searching of entire library collections including books, periodicals, audio and video files, eBooks, and a host of other media.

Follett's Circulation Plus system is designed to minimize the work associated with circulation and inventory management by automating these tasks. This includes routine circulation tasks that are typically performed by hand such as checking-in and checking-out books, calculating fines, sending overdue notices, and processing renewals. Circulation Plus puts complete inventory control in the hands of the librarian.

The portability and flexibility that has been part of FairCom's reputation for over 20 years have been fundamentally important to FSC. c-tree Plus' native support for multiple platforms, including Windows, Novell Netware, and Apple Macintosh, means that no changes are required in the database code when moving an application to different operating systems. The c-tree Server's heterogeneous networking allows FSC's engineers to implement Catalog Plus and Circulation Plus on different server platforms while supporting clients using any combination of Windows and Mac operating systems. FairCom handles all data conversions between the various operating systems and allows FSC to concentrate on what its customers need from the application and how to deliver it most efficiently.

The c-tree Server's client/server architecture allows FSC to maximize performance since database operations take place on the Server machine, thus reducing network I/O common with other databases. Clients access the server only when requesting data and only the results travel across the network, not the entire data search detail. In addition, FairCom's full-featured transaction processing assures that vital data will be preserved even in the face of a catastrophic failure, such as a machine crash or power failure.

(510KB PDF)

FairCom Start PageSite MapContact FairComThe FairCom Privacy Policy Your Location: USA | Europe | Brazil | Japan
Copyright 2010 FairCom Corporation. All rights reserved.