CSQL Cache Main Memory Database Cache

 
 
 
 

CSQL Cache  

- An Ultra fast stand alone Main Memory Database

- An Updateable Table Cache using main memory database

CSQL provides an updateable bi-directional table level database caching for any disk resident database including the leading commercial databases. These cache tables reside in the application tier and offload the computing cycles from backend systems along with reduction in costly network calls, thereby enabling real time applications to provide faster and predictive response time (Refer Fig-1). It also acts as gateway, providing access to non-cached tables and procedures in target database. This uses the fastest Main Memory Database (CSQL MMDB) designed for high performance and high volume data computing to cache the table records and provides most flexible and cost-effective way to cache and manage enterprise information.

In a three-tier application architecture scenario (Figure-1), CSQL cache can accelerate the performance of the data tier by sitting in the clustered middle tier servers.

Figure 1



Frequently accessed tables are loaded into CSQL Main memory database using table loader module (Refer Figure-2). Once the table is loaded, any access to this table will be executed locally by the gateway module and for other tables that are not cached, it is redirected to the target database for execution. Application is unaware whether the query is handled locally in CSQL MMDB or target database. This minimizes the application code changes to adapt this caching solution for improving the throughput of the application.
Bi-directional caching enables auto refresh of cached tables, which gets updates that happen on target database directly.

Benefits
No license fees
Open Source and Protractible
Easy of Administration
Small Footprint (~250 KB)
Highly concurrent
Ultra high performance
    100K selects/sec
    50K writes/sec
No disk I/O and network latency
Cache any vendor’s database tables
Transparent Caching
    No application changes
    Access to non-cached tables
    Access to native procedures
Bi-directional update propagation
Horizontally scalable
    Dozens of cache nodes for clusters

Industry Applications

Telecom,
Finance, Retail
HealthCare, Airline

 
Figure 2

 



CSQL MMDB Features

Shared memory architecture
Fault tolerance
    Process cleanup for resources
Hash Index for faster point lookup
ACID of Transaction
Highly Concurrent
    Row Level Locking
Isolation Level Support
    Read uncommitted
    Read committed
    Read repeatable
Constraints
    Primary Key, Unique, Not Null
Multi user
Data Type support
    All primitive types,
    Date, Time and Timestamp

CSQL Cache Features
Table level cache granularity
Operation consistent caching
    Insert operation completes only after it
    inserts in cache and in target database
Gateway for non-cached tables
    Enables transparent caching
Recovery from target database
Auto-Refresh
    Get updated records from target db
Automatic fail over to target db
Tool to check cache consistency

Interfaces Supported

JDBC
ODBC
SQLAPI
    C++ interface to SQL engine
DBAPI
    C++ interface to Storage engine
CSQL
    Interactive command line

Standard Compliance
ODBC Level 2
JDBC 2.0
SQL 92 Entry Level

Business Value
Improves ROI by providing business applications instant high performance access to enterprise data.
Seamlessly plugs into the existing architecture with no or minimal changes
Reduces the network bandwidth and load on back end systems
Zero or Minimal administration