CSQL Cache
Encyclopedia
CSQL Cache is an open source
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.
CSQL Cache uses Main Memory Database
(CSQL
MMDB
) for caching the table.. 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.
Open source
The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...
high performance, bi-directional updateable data caching infrastructure that sits between the clustered
Cluster (computing)
A computer cluster is a group of linked computers, working together closely thus in many respects forming a single computer. The components of a cluster are commonly, but not always, connected to each other through fast local area networks...
application process and back-end data sources to provide high throughput to the application.
CSQL Cache uses Main Memory Database
Main Memory database
An in-memory database is a database management system that primarily relies on main memory for computer data storage. It is contrasted with database management systems which employ a disk storage mechanism...
(CSQL
CSQL
CSQL is an open source main memory high-performance relational database management system developed @ sourceforge.net. It is designed to provide high performance for SQL queries and DML statements....
MMDB
Main Memory database
An in-memory database is a database management system that primarily relies on main memory for computer data storage. It is contrasted with database management systems which employ a disk storage mechanism...
) for caching the table.. 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.
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