CSQL Cache

CSQL Cache is an open source^[1] high performance, bi-directional updateable data caching infrastructure that sits between the clustered application process and back-end data sources to provide high throughput to the application.^[2]

CSQL Cache uses Main Memory Database (CSQL MMDB) for caching the table.^[3] This main memory database is many times faster than traditional disk based database system as the database completely resides in main memory and developed to be used on real time high computing data platforms.^[4]

Features

Table level cache granularity
Operation consistent caching
Transparent pass through for non-cached tables
Partial table caching - Partial Rows or Partial Columns
Recovery of cached tables from target database
Bi-Directional updates - Auto refresh of cached tables
Automatic fail over to target db
Tool to check cache consistency
Support for JDBC and ODBC Driver

DBMS Supported

MySQL
Postgres
Oracle
DB2
Sybase

References

^ "CSQL sourceforge". sourceforge.net.
^ "CSQL Cache" (PDF). csql.
^ "DB Cache" (PDF). stanford.
^ "THE DATABLITZ MAIN-MEMORY STORAGE MANAGER: ARCHITECTURE, PERFORMANCE, AND EXPERIENCE". sigmod proceedings. CiteSeer^x: 10.1.1.33.4556. {{cite journal}}: Cite journal requires |journal= (help)

[1] "CSQL sourceforge". sourceforge.net.

[2] "CSQL Cache" (PDF). csql.

[3] "DB Cache" (PDF). stanford.

[4] "THE DATABLITZ MAIN-MEMORY STORAGE MANAGER: ARCHITECTURE, PERFORMANCE, AND EXPERIENCE". sigmod proceedings. CiteSeer^x: 10.1.1.33.4556. {{cite journal}}: Cite journal requires |journal= (help)

[1]

[2]

[3]

[4]