SQL access to your standalone database (Overview)

 FairCom database technology has driven many application success stories. Featuring deployment simplicity with high performance data retrieval, FairCom DB sets the standard for data integrity and performance for this class of applications.

SQL is the standard of choice for today’s data access integration. FairCom DB SQL is an ANSI-compliant SQL database engine with support for everything you expect from a robust SQL database including stored procedures, triggers, user-defined functions, ODBC, JDBC, and a wealth of standard interfaces. Built upon our roots of NoSQL ISAM, FairCom DB SQL is proven technology in mission-critical applications.

FairCom DB SQL has been traditionally available as a client-server only architecture. FairCom DB Standalone SQL Service changes this. FairCom DB Standalone SQL Service provides users of FairCom’s Multi-User Standalone operational model database with advanced SQL access to their standalone data.

Much more powerful than a standalone ODBC driver, FairCom DB Standalone SQL Service leverages the FairCom DB SQL database engine and provides SQL access using such industry standards as ODBC, JDBC, and PHP.

Notice that some FairCom DB Standalone SQL Service packages may not include support for all APIs. Please contact FairCom if your package does not include an API you are interested in.

FairCom DB Standalone SQL Service installs on your network, typically on the machine hosting your application data, and connects to your FairCom DB database similar to any other multi-user application. FairCom DB Standalone SQL Service allows users to take advantage of third-party applications to access your FairCom DB data using ODBC, JDBC, ADO.NET, etc.

In most cases, FairCom DB Standalone SQL Service requires no changes to your application or your application data.

Note: No changes are required if your data files have the file definitions (known in c-tree terminology as IFIL structures) and field schema definitions (known as a Dynamic Object Definition Array or DODA). See Application Data Setup in this document for details.

Build for Your Future

FairCom DB Standalone SQL Service is nearly 100% compatible with the FairCom DB SQL client-server architecture. When you add FairCom DB Standalone SQL Service to your Multi-User Standalone application, you open it to SQL access and you make it ready for the future. If, at a later time, you decide to migrate your application to a full client-server model, you will already have much of the infrastructure in place for making that move.

Maximize your growth opportunities as your user base and application needs grow. FairCom DB Standalone SQL Service brings a highly scalable new architecture to your existing standalone application.

Key Benefits

• Choice of client APIs: ODBC, JDBC, ADO.NET, PHP, Python
• Interactive tools and utilities for data management
• Centralized query service for performance gains
• Views for data access management
• Permissions-based data access controls
• Advanced query optimization
• Stored Procedures support
• 64-bit ODBC support

Architecture

The following diagram illustrates a typical multi-user application. The blue boxes represent multiple instances of the application accessing a shared set of data on a central computer. FairCom DB Standalone SQL Service is installed on your central computer. A FairCom DB ODBC driver (or any other supported driver) is then installed on any computer that is hosting ODBC-compliant applications. The final part of the installation process is to create the data dictionary for FairCom DB Standalone SQL Service.