Csql Cache
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Csql Cache as PDF for free.
More details
- Words: 388
- Pages: 12
CSQL cache
What is CSQL cache? • a generic database caching platform to cache frequently accessed tables from a backend DBMS. • Uses CSQL MMDB which gives high performance • Provides faster and predictive response time with high throughput.
Why CSQL cache? • • • • • •
100X faster access for cached tables Application transparent caching Distributed caching for cluster Flexible deployment options Standard Support: JDBC, ODBC, SQL Automatic Fail over to target database
What does the cache do? • Works in conjunction with the existing DBMS caching frequently accessed tables • Provides application flexibility • acts as gateway forapplications to access cached tablesfrom CSQL MMDB and other tablesfrom existing database transparently
Benefits • • • •
Performance - 100 times faster response time for cached tables Scalability - Leverages multi core and processor architecture machines Stability - works in conjunction with the existing databases. Reduces deployment effort - uses standard ODBC and JDBC interface thereby reducing the learning curve - completely removes performance tuning as it requires no DBA -requires no application code changes thereby reducing development and testing effort
Features of CSQL cache • • • • • • • • •
Caching Types Transparent caching Data consistency Update propagation mode High availability APIs Deployment options Supported database platforms Industry Applications
Caching Types • • • •
Full table Partial table Read only table Bi-directional table updates
Transparent Caching • Access to tables in target database(non-cached tables) • Calls to target database specific features like stored procedures, SQL extensions, are routed transparently to target database
Data consistency • Operation consistent caching • Transaction consistent caching • Tools to check cache consistency
Update Propagation modes • Sysnchronous mode - update operation on the cache and the target database at the same time • Asynchronous mode - updates are delayed to the target database
High availability • Automatic fail over to target db • Automatic recovery • Load balancing with multiple cache nodes
Deployment Options • • • • • •
Transparent Updateable Cache Read Intensive Cache Read/Write Intensive Cache Write Intensive Cache Bi-directional Distributed Cache Coherent distributed cache
Supported Database Platforms • Oracle, MySQL, Postgres
Industry Applications • • • •
Telecom, Finance, Retail, HealthCare, Airline, High traffic web sites
For more information, visit Product web site at http://www.csqldb.com Company web site at http://www.lakshyasolutions.com
THANK YOU
What is CSQL cache? • a generic database caching platform to cache frequently accessed tables from a backend DBMS. • Uses CSQL MMDB which gives high performance • Provides faster and predictive response time with high throughput.
Why CSQL cache? • • • • • •
100X faster access for cached tables Application transparent caching Distributed caching for cluster Flexible deployment options Standard Support: JDBC, ODBC, SQL Automatic Fail over to target database
What does the cache do? • Works in conjunction with the existing DBMS caching frequently accessed tables • Provides application flexibility • acts as gateway forapplications to access cached tablesfrom CSQL MMDB and other tablesfrom existing database transparently
Benefits • • • •
Performance - 100 times faster response time for cached tables Scalability - Leverages multi core and processor architecture machines Stability - works in conjunction with the existing databases. Reduces deployment effort - uses standard ODBC and JDBC interface thereby reducing the learning curve - completely removes performance tuning as it requires no DBA -requires no application code changes thereby reducing development and testing effort
Features of CSQL cache • • • • • • • • •
Caching Types Transparent caching Data consistency Update propagation mode High availability APIs Deployment options Supported database platforms Industry Applications
Caching Types • • • •
Full table Partial table Read only table Bi-directional table updates
Transparent Caching • Access to tables in target database(non-cached tables) • Calls to target database specific features like stored procedures, SQL extensions, are routed transparently to target database
Data consistency • Operation consistent caching • Transaction consistent caching • Tools to check cache consistency
Update Propagation modes • Sysnchronous mode - update operation on the cache and the target database at the same time • Asynchronous mode - updates are delayed to the target database
High availability • Automatic fail over to target db • Automatic recovery • Load balancing with multiple cache nodes
Deployment Options • • • • • •
Transparent Updateable Cache Read Intensive Cache Read/Write Intensive Cache Write Intensive Cache Bi-directional Distributed Cache Coherent distributed cache
Supported Database Platforms • Oracle, MySQL, Postgres
Industry Applications • • • •
Telecom, Finance, Retail, HealthCare, Airline, High traffic web sites
For more information, visit Product web site at http://www.csqldb.com Company web site at http://www.lakshyasolutions.com
THANK YOU
Related Documents
Csql Cache
May 2020 23
Csql Cache For Postgres
May 2020 4
Cache
May 2020 12
Cache
November 2019 21
Cache
May 2020 20
Cache
November 2019 30More Documents from ""
Csql Cache For Postgres
May 2020 4