CSQL
Description
CSQL is an open source main memory high-performance relational database management system developed in sourceforge.net. It is designed to provide high performance on simple SQL queries and DML statements which involves only one table.
It supports only limited features which are used by most of the real time applications which includes INSERT, UPDATE, DELETE on single table and SELECT with local predicates on single table. It provides multiple interfaces to client
* DB API - to access the relational storage engine
* SQL API - to access SQL Engine
* ODBC - standard interface for C/C++ applications
* JDBC - standard interface for Java applications
This is mainly developed to be used as a cache for existing disk based commercial databases. Main Memory databases performs 10-20 times faster than the commercial database systems, as it completely keeps the database in main memory. Reference:
for more information.