Accuracer Database System:
Client/Server Single-File BDE Replacement
Description
Description
Accuracer Database System for Delphi / C++ Builder and Kylix is a new, fast, and high-reliability
embedded BDE replacement database with small footprint designed to be used with multi-user database applications
and to provide the fast database operation on huge data.
Accuracer supports both client/server and file-server modes of multi-user work
to gain client/server flexibility as well as the simplest way of the multi-user access to a database file.
Accuracer Database System uses its own format that allows to store multiple tables in a single-file database.
Accuracer compiles right into executable file of your application
and does not require BDE as well as DLLs or any other external drivers.
Accuracer Database System is a cross-platform DBMS worked in Linux as well as
in Windows so you may easily use your databases in both these systems.
Accuracer Database System products line includes several independent DBMS products for working with the databases in Accuracer format:
-
Accuracer VCL - general package for software development in Delphi and C++Builder in Windows;
-
Accuracer CLX - general package for Kylix which allows development in Linux as well as applications migration from Windows to Linux by fast and easy way;
-
Accuracer Utilities - package includes Accuracer Database Server, Accuracer Database Manager and other utilities with full source code;
-
Accuracer ODBC Driver - Windows DLL with install/uninstall application;
-
Accuracer Bold DB Adapter - support for
Borland Bold for Delphi: http://info.borland.com/techpubs/delphi/boldfordelphi/?idh_Overview_auto_1.htm
, a usefull tool for data import/export ;
-
Accuracer Data Provider for Fast Query Builder - for working with Fast Query Builder ,
a visual SQL query builder by Fast Reports Inc.;
-
Accuracer Database Connection for Easy Query - to work together with EasyQuery.VCL ,
a visual query builder by Korzh.com;
-
Accuracer Data Provider for Active Query Builder - to create SQL queries via an intuitive visual interface using
Active Query Builder .
Accuracer Database System provides the following capabilities:
- compiles right into executable application file; no BDE, no DLLs requires;
- multi-user concurrent read / write access (both file-server and client/server mode);
- multi-thread access enables to develop thread-safe applications, for example, web application (see Demos);
- multiple tables in a single-file database;
- SQL & DDL commands support;
- SQL stored functions and procedures support;
- Referential Integrity support (SQL'99 compliance)
- 100% Unicode support - SQL, filters, database objects names
- DB-aware controls and tools compatibility ;
- IProvider support for TClientDataset compatibility;
- master / detail relationship;
- creating, renaming, emptying, deleting, restructuring and repairing tables;
- creating, editing, deleting, browsing and searching for records;
- creating and deleting multiple indexes;
- calculated and lookup fields;
- fast searching using multiple indexes;
- filtering support;
- default values support;
- record-level constraints;
- Key and Range methods;
- tables and database restructuring and repairing routines;
- progress bar support;
- using BLOB fields with data compression ability;
- Varchar support with optional compression;
- strong database encryption with wide variety of algorithms and modes;
- custom memory manager speed up operation and guarantees low memory usage;
- in-memory mode is also available to speed up the work with small tables;
- shareable in-memory tables;
- transactions support with READ COMMITTED isolation level;
- batch operations with groups of records;
- backup-restore capabilities;
- triggers - database and server events;
- reverse engineering (table or whole database to SQL script export);
- capability of database embedding inside the executable file ;
- importing from and exporting to any data source in fast and easy way;
- internationalization / localization and Unicode support.
Accuracer VCL/CLX is a fully functional database system; it includes visual components, utilities with source code, comprehensive documentation and help system, a lot of demos
(see Package Contents for details).
The core of Accuracer, TACRTable, which is a fast and easy TTable replacement, provides all the TTable functions such as master / detail relationship, filtering, searching, sorting, blob fields, key and range methods, as well as some advanced features like table and database encryption, blob fields compression and multiple indexes.
All the components are fully compatible with standard DB-aware controls as well as with the most of third-parties database tools such as DBGrids, Tries, Report Generators, etc.
Accuracer Database System allows easy migration from the database systems you used and has the widest functionality to help you to save your time of development. It provides an access to databases from different OS and environment to give you the fabulous flexibility.
Accuracer Database System is a complete database solution which can help provide return on investment by capitalizing on new, revenue-generating software with respond to requests from new prospects at low cost, allowing you to extend your reach to new markets.
Specification
Specification
SQL & DDL commands support.
Data types:
ftFixedChar, ftString, ftWideString, ftSmallint, ftInteger, ftLargeint, ftWord, ftAutoInc, ftFloat, ftBoolean, ftCurrency, ftDate, ftTime, ftDateTime, ftTimeStamp, ftBytes, ftVarBytes, ftDBaseOle, ftParadoxOle, ftTypedBinary, ftBlob, ftGraphic, ftMemo, ftFmtMemo
Advanced data types:
aftUnknown, aftChar, aftString, aftWideChar, aftWideString, aftShortint, aftSmallint, aftInteger, aftLargeint, aftByte, aftWord, aftCardinal, aftAutoInc, aftAutoIncShortint, aftAutoIncSmallint, aftAutoIncInteger, aftAutoIncLargeint, aftAutoIncByte, aftAutoIncWord, aftAutoIncCardinal, aftSingle, aftDouble, aftExtended, aftBoolean, aftCurrency, aftDate, aftTime, aftDateTime, aftTimeStamp, aftBytes, aftVarBytes, aftBlob, aftGraphic, aftMemo, aftFormattedMemo, aftWideMemo
Default page size: 4096 bytes (4 Kb).
Minimum page size: 128 bytes.
Maximum page size: 65535 bytes (64 Kb without 1 byte).
Maximum number of pages per database file: 231 (over 2 billions).
Maximum record size: 231 bytes (over 2 billions).
Maximum number of concurrent connections: 100,000,000 in MU, 1 in SU, 2 in Trial version.
Maximum fields per table: 231 (over 2 billions).
Maximum indexes per table: 231 .
Maximum index fields per index: 231 .
Maximum index entry size: (PageSize - 128) / 2.
Maximum field name's length: 255 characters.
Maximum index name's length: 255 characters.
BLOB fields block size: > 1 byte, default 100 KB.
BLOB and Varchar compression algorithms: ZLib, BZip, PPM.
Database encryption: 12 strong encryption algorithms with 4 different modes and 2 different encryption schemes.
Search operators: <,>,=,<>,<=,>=, like, not like,
is null, is not null, and, or, not, ().
Data Import/Export Capabilities
Data Import/Export Capabilities
Batch import/export operations with groups of records or entire tables using TACRBatchMove component,
which works in the same manner as TBatchMove and supports almost all of its functionality.
Look at source code of our BatchMove demo to get assistance.
Tables import and export using ImportTable and ExportTable methods.
If you need to move data to Accuracer database from the database that can be accessed via BDE or ODBC,
the better way is to use
Accuracer DBTransfer utility ,
which are available with full source code and can be used
as an example to help you to implement import/export capabilities in your project.
If you need to move data to Accuracer database from the EasyTable database ,
you can download Database Coverter Utility from EasyTable to Accuracer ,
then just run it and select existing EasyTable database file.
This utility is available with full source code, too.
If you need to move data to Accuracer database from MySQL database ,
you can also use our MySQLImport demo.
If you need to move data to Accuracer database from CSV (coma-separated values) file ,
look at our CSVImport demo.
Table or whole database backup-restore capabilities.
You can download Accuracer Backup and Accuracer Restore utilities
and use them with your Accuracer database.
These utilities include full source code and you can use them as examples on
how to add backup/restore functionality to your project.
Accuracer supports
Borland Bold for Delphi: http://info.borland.com/techpubs/delphi/boldfordelphi/?idh_Overview_auto_1.htm
technology, special thanks to
Konstantin Gribachev, the author of the book "Delphi and Model Driven Architecture".
The easiest way to move your data using Borland Bold® technology is to use his
Bold Data Pump utility .
Here you can download Accuracer Bold DB Adapter
with full source code, a demo and an example of application with source code, too.
Accuracer ODBC Driver is a version
of Accuracer VCL to work with the database in Accuracer format via ODBC interface.
It includes almost all the ODBC compatible functionality of the Accuracer VCL, including
file-server and client/server multi-user access. Accuracer ODBC Driver can be used for
data import/export from/to ODBC data sources.
If you need a help in your special data import/export case, please
contact
our Support Team.
Advanced Client-Server Features
Advanced Client-Server Features
Accuracer Database Server provides you a possiblity to change any SQL query before execution or even abort it.
Thus you can make your application more flexible:
- you can change data definition without recompiling and reinstalling client applications;
- you can block some SQL queries for security reasons;
- you can log all SQL queries executed by clients.
For more information read TACRServer.OnSQL event description in
Accuracer Component Reference
Another great advantage of the Accuracer Server is the custom messages support.
Now you can make any communication between server and any client connected to it.
Accuracer allows to send and receive text, binary and stream messages by both sides: client and server.
Thus you can communicate any client with another client (through the server), client with server and server with client.
And these messages can be sent and received at any time, simultaneously with accessing the tables and executing SQL scripts.
For more information look at events OnReceiveTextMessage, OnReceiveBinaryMessage, OnReceiveStreamMessage and method SendMessage of TACRDatabase and TACRServer components in
Accuracer Component Reference
SQL Support
SQL Support
Here is a full list of supported SQL statements in current version of Accuracer:
SELECT [DISTINCT | ALL]
* | column [AS correlation_name | correlation_name], [column...]
[INTO destination_table]
FROM table_reference [AS correlation_name | correlation_name] [Password 'password']
[[[[NATURAL][INNER | [LEFT | RIGHT | FULL] OUTER JOIN] table_reference [AS correlation_name | correlation_name]
[ON join_condition] | USING (join columns)]
[WHERE predicates]
[GROUP BY group_list]
[HAVING predicates]
[ORDER BY order_list]
[UNION [ALL] [CORRESPONDING [BY (column_list)]] SELECT...]
[EXCEPT | MINUS [ALL] [CORRESPONDING [BY (column_list)]] SELECT...]
[INTERSECT [ALL] [CORRESPONDING [BY (column_list)]] SELECT...]
GET TABLES statement (SELECT * FROM TABLES)
CREATE DATABASE, DROP DATABASE statements
CREATE FUNCTION, DROP FUNCTION, ALTER FUNCTION, EXECUTE FUNCTION statements
Assign operator :=
IF ... THEN ... ELSE ...
Session variables: @SessionVariableName
CREATE TABLE, DROP TABLE, ALTER TABLE statements
CREATE INDEX, DROP INDEX statements
INSERT, UPDATE, DELETE statements
SQL scripts (multiple commands separated by ';')
BETWEEN, IN, EXISTS, LIKE, IS NULL operators
Aggregate functions COUNT,SUM,MIN,MAX,AVG
Most of all SQL'92 arithmetic, logical, datetime and string expressions, functions and operators
Data types conversion function CAST
Parameters in queries
Uncorrelated subqueries
START TRANSACTION, COMMIT, ROLLBACK
If you have any questions or would like to tell us what SQL feature you need first of all,
please feel free to contact our
Support Team
.
Visual Query Building
Visual Query Building
Requirements
Requirements
Accuracer Database System is available for Delphi 4, Delphi 5, Delphi 6, Delphi 7, Delphi 2005, Delphi 2006
for C++Builder 4, C++Builder 5, C++Builder 6, C++Builder 2006,
and for Kylix 3 (Delphi).
As the Delphi Standard and Personal editions do not support TDataset class
Accuracer will not work there as most other BDE alternatives.
Accuracer Trial and Std are not compatible with trial versions of Delphi / C++ Builder
and Kylix.
How to Use
How to Use
Accuracer is easy-to-use:
just run install.exe and it installs all the components to Delphi (C++ Builder).
The installation process is detailed in Installation chapter in readme.txt.
If you have any questions, please read it carefully.
This product comes with full documentation presented in Accuracer Developer's Guide and Accuracer Component Reference
(AccuracerGuide.hlp and AccuracerRef.hlp or HTML files for Kylix).
Developer's Guide contains examples showing how to use all the Accuracer's operations
and step-by-step instructions.
Setup program automatically installs Accuracer Reference into Delphi / C++Builder IDE.
Help System
Help System
Support
Support
If you have any problems or questions, please
read FAQ first.
In case if you did not find an answer to your questions there, please
contact our
Support Team
.
We consider any ideas while developing further versions of our products.
Here you can read more about our Support Policy .
Purchasing and Registration
Purchasing and Registration
Custom Development
Custom Development for you -
Delphi and
C++ Builder !
Experts in Database, Networking, Data Compression and Encryption.
10+ years experience.
Contact Us!
讠믬/a>
讠믬