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". csql.
- ↑ "DB Cache". stanford.
- ↑ "THE DATABLITZ MAIN-MEMORY STORAGE MANAGER: ARCHITECTURE, PERFORMANCE, AND EXPERIENCE". sigmod proceedings. CiteSeerX: 10
.1 ..1 .33 .4556