Samiksha Jaiswal (Editor)

CSQL Cache

Updated on
Edit
Like
Comment
Share on FacebookTweet on TwitterShare on LinkedInShare on Reddit

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.

Contents

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.

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 Cache Wikipedia
    (Text) CC BY-SA