CSQL

About the Product

CSQL is the highly effective relational database management system based on open codes, developed by sourceforge.net. It is developed so that to provide high efficiency for requests of the SQL language and operators of the DML language. CSQL executes requests 30 times faster than others with open source codes of a management system for the database and provides the predicted answer time (10 microseconds for accomplishment of a request on LOOKUP and 20 microseconds for the transactions INSERT, UPDATE, DELETE) that allows to use this DBMS for the transactions executed in real time and applications for work with arrays of databases, and requests, critical to runtime.

The databases located in a base memory allow to execute transactions 10-20 times faster than commercial database management systems as the data used in requests are had in RAM. CSQL can be configured so that to work as the transparent updated cache of real time, for the commercial databases which are on a disk, such as Oracle, Sybase, MySQL, Postgres, etc.

Features

• Direct access to the database, data are available in an address space of the application via the internal mechanism;
• Client-server access for applications, computers, residing on remote from the server;
• Atomicity - all transactions of the executed transaction should be confirmed for entry into force, in the absence of confirmation of change will be cancelled;
• The sequence - the database should be in the available mode, prior to accomplishment of transaction and some time after its termination;
• Isolation - each transaction is executed in the isolated area, is independent also unavailable to transactions executed by other applications;
• Fault tolerance - an opportunity to recover all confirmed transactions in case of refusal of the equipment or other failures in system operation;
• Restrictions are NOT NULL, Unique key, Primary Key, Foreign Key;
• Values by default for avtoinkriminentny fields;
• Automatic system of release of resources of those applied processes which received failure and ceased to answer;
• The accelerated accomplishment of the LOOKUP command, due to use of indexes and a cache of indexes;
• The accelerated accomplishment multiple zaprosv due to use of treelike indexation;
• Data types: BYTE, SMALL, INT, BIGINT, FLOAT, DOUBLE, CHAR, BINARY, DATE, TIME, TIMESTAMP;
• Blocking at the level of a data member (line), blocking of free inner patterns for high degree of multithreading;
• Support of an authentication mechanism of users for access to the database;
• Support of aggregate functions, groupings, internal consolidation, outer join, self-consolidation, exception, sorting;

Platforms

• Linux, Oracle Solaris

The supported interfaces

• SQL, ODBC, JDBC, PHP