India’s 1st and world’s fastest main memory database system is available under Enterprise release. CSQL is currently available in 3 major components
- CSQL MMDB – in-memory database
- CSQL Replicator – for replication
- CSQL Cache – for caching
CSQL Main Memory Database Management system is a relational database management, which stores the database in memory using lock free data structures. It provides highly concurrent access through standard SQL interfaces to retrieve and manipulate the data with unprecedented high throughput and response times.
Some quick facts
- 20--30x faster than disk based DBMS
- Full ACIID support
- Highly Concurrent:: Lock free structures
- Standard Support:: JDBC, ODBC,, SQL
- High availability:: Replication
- No Application Migration:: Cache
CSQL Replication enables real time data replication between multiple CSQL MMDB instances to provide high availability and load balancing for mission critical enterprise data & applications
Some quick facts
- Update anywhere ‘‘N’’ way replication
- Transparent replication
- High Availability and Disaster recovery
- Load balancing –– Increase throughput
- Flexible deployment options
CSQL Cache is a generic database-caching platform to cache frequently accessed tables from your existing open source or commercial database management system (Oracle, MySQL, etc) closer to the application tier. It uses the fastest Main Memory Database (CSQL MMDB) designed for high performance and high volume data computing to cache the table and enables real time applications to provide disruptively faster and more predictive response times with higher throughputs.
Some quick facts
- 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