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. CiteSeerX 10.1.1.33.4556
.
This article is issued from Wikipedia - version of the 11/10/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.