Accuracer Database System: BDE replacement embedded database for Delphi / C++ Builder / Kylix

Accuracer Database System:
BDE replacement embedded database
for Delphi / C++ Builder / Kylix

Features and Benefits

Compactness
High Performance
Functionality
Compatibility
Security
Reliability
Convenience
Utilities

Compactness

Short compiled code with approximate size 1200 KB, BDE replacement embedded database, no DLLs, no external drivers (such as BDE) required.
Accuracer supports storing multiple tables inside the single database file or even inside the executable file.
Small memory consumption by Accuracer database engine.
Fast Varchar and BLOB data compression. Your large data fields will need the less possible disk space. Accuracer compresses data on the fly. The data packing / unpacking process is not appreciable compared to the disk write / read process. The compression routines used in the Accuracer are much faster than most of popular archivers like PKZip, WinRar, Arj.
Accuracer automatically reduces the size of the database file in case of deleting data from the end of file.

High Performance

Fast search by B-tree indexes. At the moment Accuracer is one of the fastest existing single-file databases for Delphi, C++ Builder and Kylix.
Transactions support enables you to increase the performance. Even reading records works much faster inside the transaction. Read Transactions chapter in Developer's Guide to learn details.
In-memory mode assigned to speeding up the working process in case when all the data may be stored in RAM.
High-speed memory operations performance is achieved by means of using a custom memory manager and specially optimized algorithms.
Advanced SQL optimizer often makes query execution several times faster by choosing the best execution plan.

Functionality

Scalability: from single-user (SU) mode with no concurrent write access up to thousands users multi-user mode, zero-administration file-server (MU), or even client/server (CS).
A subset of SQL'92 DML & DDL operators enhanced by advanced statements are supported by TACRQuery component. With Accuracer you can create SQL scripts for creating databases and tables, inserting, editing and deleting records, retrieving data by SELECT command. See full list of supported commands.
Correlated subqueries are supported in SELECT, UPDATE and DELETE SQL statements.
Stored procedures and functions are supported - both using TACRQuery and TACRDatabase. The script language is the combination of SQL and Pascal.
100% Unicode support - SQL, Filters, Expressions, database objects' names (stored functions, tables, indexes, foreign keys), database file names.
Most of TTable functions are supported including Key and Range methods.
Advanced search engine. Accuracer supports 'LIKE' operator with wildcards '%' and '_', as well as 'IS NULL' and 'IS NOT NULL' in filters and queries.
Single file format. Multiple tables can be stored inside the single database file.
Support for executable databases. Database file can be integrated into the executable file of application. Thus you can distribute only single executable file and either use database in read-only mode (OS locks executable file when application starts) or copy it to any directory and use in any access mode. Database file can be linked to the application file by calling MakeEXEDatabase, tested by IsAccuracerDatabaseFile, and extracted by RemoveDatabaseFromExe functions of TACRDatabase component.
Full multiple index support, i.e. numerous fields in a table may comprise an index. Accuracer provides descending and ascending indexes, case-sensitive and insensitive indexes for string fields.
Shareable in-memory tables. Accuracer supports simultaneous access to a table by multiple TACRTable components within a single application.
Reverse engineering (table or database to SQL script export) capabilities enables you to build SQL script to create your table or whole database and insert all existing data.
Backup and Restore support. You can easily backup and restore your database using build-in data compression to reduse disk space usage as well as using strong encryption to prevent unauthorized access to your backup copy.
Triggers - database and server events.
Default values support.
Record-level constraints, i.e. constraints that must be met when editing the data.
Referential integrity SQL-99 compliance - foreign keys support.
Advanced Client-Server Features.
Visual Query Building. With Accuracer you can use a visual query builder for handy visual creation of database queries even without knowledge of SQL!
Advanced Data Import/Export capabilities for groups of records, tables, or the whole database.

Compatibility

Most of TTable, TQuery, TDatabase, TSession and TBatchMove properties, methods and events are supported.
Accuracer supports almost all of TTable field data types, including BLOB fields, moreover it allows to create string and wide string fields of any fixed as well as variable length.
Accuracer is fully compatible with standard DB-aware visual controls such as QuickReport, DBGrid, DBNavigator, DBImage, DBMemo, DBRichEdit, as well as with third party products supporting TDataset descendant components - FastReport, DBFlyTreeView and others.
IProvider interface support. You can access TACRTable and TACRQuery components via TClientDataset.
Calculated and lookup fields can be used in the same way as TTable.

Security

Accuracer provides encryption of the entire database contents using strong encryption algorithms.
Wide choice of encryption algotithms:
- Rijndael, the Advanced Encryption Standard (AES) winner, 128 bit key
- Rijndael, 256 bit key
- Blowfish, 448 bit key
- Twofish, 128 bit key
- Twofish, 256 bit key
- Square
- Single DES 8 byte Blocksize, 8 byte Keysize 56 bits relevant
- Double DES 8 byte Blocksize, 16 byte Keysize 112 bits relevant
- Double DES 16 byte Blocksize, 16 byte Keysize 112 bits relevant
- Triple DES 8 byte Blocksize, 24 byte Keysize 168 bits relevant
- Triple DES 16 byte Blocksize, 24 byte Keysize 168 bits relevant
- Triple DES 24 byte Blocksize, 24 byte Keysize 168 bits relevant
You can use one of the best existing symmetric block ciphers tested by the best cryptography experts to achieve so fast speed and strong encryption as you need.
Four different encryption modes: CTS, CBC, CFB, OFB.
Two different encryption schemes. You can use a password as well as an encryption key itself to protect your database. Accuracer has the best encryption functionality among all known Delphi database systems.
Advanced methods in TACRDatabase component IsDatabaseEncyrpted, IsDatabaseEncyrptedByPassword, and IsCryptoParamsValid allow safe detection of database encryption.

Reliability

Transactions support enables you to increase reliability. If some failure will occurs duing the transaction processing all modifications will be lost and database will be in the same state as before starting the transaction.
Accuracer provides two alternative possibilities to repair tables and databases in case of hardware failure or operating system error caused by another application.
Accuracer supports changes detection and write failures detection using table states (TACRTable.GetTableState method or GET TABLES SQL statement).
Accuracer works with large databases (millions records and gigabytes of data).

Convenience

Cost-effectiveness: royalty-free (you may develop any number of applications for any number of users using this product without additional fees); a large number of licenses (SU / MU / CS versions, source code and non-source code editions, multi-developers licenses). Also look at price comparison matrix.
Easy switching between single-user, file-server and client/server modes.
Ease of deployment: no BDE, no DLLs; no special installation and configuration required.
Ease of development: compatibility with standard database data access components (TTable, TQuery, TDatabase, TSession, TBatchMove), database data controls (DBGrid, DBNavigator, DBImage, DBMemo, DBRichEdit, etc.), third-party components (like QuickReport, FastReport, DBFlyTreeView, etc.); almost all standard and advanced field data types.
Prompt and responsive technical support by e-mail.
Usage examples. There are about 50 demos for Delphi / C++ Builder / Kylix in Accuracer distribution package. Utilities include full source code.
Comprehensive help. Accuracer comes with full documentation presented in Accuracer Developer's Guide and Accuracer Component Reference.
Table restructuring is being performed in the easiest way keeping all the existing data.
Data importing from and exporting to any data source is supported. Accuracer provides you with the simplest way to import and export of tables using ImportTable and ExportTable methods.
TACRBatchMove component, which works in the same manner as TBatchMove and supports almost all of its functionality, performs database operations on groups of records or entire tables.
Internationalization / localization support. All text search and sorting functions use current system locale, so localizing your program with Accuracer is a very simple task.
Unicode support. All the text operations work with multi-byte encoding using ftWideString.
Displaying progress during potentially slow operations with the tables and databases is supported.
Transactions provide you an adiitional convenience of work.

Utilities

Accuracer Manager helps you manage a database easily. This powerful tool allows you to perform any supported operations with Accuracer tables and databases.
Accuracer Database Server utility (in client/server version only). Flexible database administrator and server management tool.
DBTransfer utility will help you transfer your existing tables from database systems with BDE driver, such as Paradox, Interbase, Access, Oracle, SQL Server to Accuracer database and vice versa.
ACR4Convert utility is needed to convert old Accuracer 1-4 database to new Accuracer v.5.
Converter utility helps you to convert your existing databases from EasyTable to new Accuracer Database System format.
SQL Console provides you an easy way of executing SQL queries. You can load and run demo queries supplied with it or create your own scripts and save them to a text file.
AccuracerBackup and AccuracerRestore help you to organize backup-restore process and give you an example to add backup/restore functionality to your apps.
All utilities include full source code that can be used as advanced examples.


	Custom Development

	Custom Development for you - Delphi and C++ Builder! Experts in Database, Networking, Data Compression and Encryption. 10+ years experience.

02/02/12
EasyTable v.7.00

01/31/12
Single File System v.3.00

01/30/12
CryptoPressStream v.3.00

10/27/11
MsgCommunicator v.5.00

10/19/11
SQLMemTable v.5.00

10/06/11
Accuracer VCL v.6.00 Beta 2 with XE2

04/27/11
MsgCommunicator Database Pack v.1.10

03/30/11
Accuracer ODBC Driver v.4.02

03/23/11
Accuracer VCL v.5.90 is the fastest Delphi C/S database

02/10/11
Accuracer is the best in the SQL test!

02/17/06
EasyTable ODBC Driver v.1.20

12/14/05
Active Query Builder v.1

10/12/04
Accuracer & EasyTable
are the fastest!
Competitive Prices and
Features Comparison

01/28/04
Accuracer CLX v.1.40 for Kylix


	Competitive Upgrade

	If you own a competing product, you may take a discount up to 50%. Please, contact our

Voting

Do you need Lazarus/FreePascal commercial version of our products?

Accuracer

CryptoPressStream

MsgCommunicator

Single File System

SQLMemTable


	Accuracer is fastest!

	Accuracer Database System is the fastest Delphi client/server database!


	Last Releases

	02/02/12 EasyTable v.7.00 01/31/12 Single File System v.3.00 01/30/12 CryptoPressStream v.3.00 10/27/11 MsgCommunicator v.5.00 10/19/11 SQLMemTable v.5.00 10/06/11 Accuracer VCL v.6.00 Beta 2 with XE2 04/27/11 MsgCommunicator Database Pack v.1.10 03/30/11 Accuracer ODBC Driver v.4.02 03/23/11 Accuracer VCL v.5.90 is the fastest Delphi C/S database 02/10/11 Accuracer is the best in the SQL test! 02/17/06 EasyTable ODBC Driver v.1.20 12/14/05 Active Query Builder v.1 10/12/04 Accuracer & EasyTable are the fastest! Competitive Prices and Features Comparison 01/28/04 Accuracer CLX v.1.40 for Kylix