<< TOC - Writing Client Application >>
Before you Start
This chapter gives a introduction such as what is CSQL, Information in this manual, and Conventions used in this manual.
What is CSQL
CSQL Main Memory Database is an easily accessible and powerful database management system, which includes the CSQL Main Memory Database, and Cache to MySQL, PostgreSQL and Oracle disk based database management system. It typically resides in the middle tier alongside applications and store data in main memory rather than disk, allowing it to be retrieved very quickly. It is used for applications where extremely fast response times are critical. Investment houses use CSQL to store current stock price information, which they need to quickly make trading decisions. Mobile operators use the software for billing, so that they can quickly determine whether a caller has enough prepaid credit to place a call. CSQL could be used for a wide variety of applications ranging from single-user system to enterprise-wide multi-user installations with hundreds of concurrent connections.
CSQL Components
This Introduction provides an overview of the three major components that make up CSQL. These components include :
- CSQL Main memory database
- CSQL Cache
- CSQL Replication
CSQL Main Memory Database
CSQL Main Memory Database derives much of its power from its unique architecture. At the core, the CSQL database storage engine provides the complete set of services including data storage, concurrency management, transactions, and process management needed to build efficient database management system.
CSQL Cache
CSQL Cache option enables customers to significantly improve application response times and throughput. Based on the CSQL MMDB, CSQL Cache delivers a real-time, dynamic, updateable cache for frequently accessed data in MySQL, Postgres and Oracle database. For performance critical applications in industries such as Telecom, Process Control, Airline Reservation, Stock Market, HealthCare, etc., the CSQL Cache option delivers application response times in microseconds by bringing the frequently accessed data closer to the application, and by executing SQL requests in the CSQL MMDB.
This has been achieved that CSQL and its associated suite of products to be between 10 and 40 times faster than traditional database system. Visit Benchmark result page at http://www.csqldb.com/prod-benchmark.html for more information.
CSQL Replication
CSQL Replication offers complete data protection through automated, real-time, zero-latency fail over and recovery with high availability and load balancing cluster for CSQL MMDB that provides both synchronous and asynchronous transaction propagation to peer instances. Also helps improve performance with query access to the hot standby
Information in this guide
This guide is for application developers who use CSQL drivers and libraries to access data in the database programmatically. Before reading this manual, understanding of following background knowledge is recommended.
- SQL(Structured Query Language)
- C,C++ Programming language
- Relational database technology, CSQL server in particular
- JDBC and ODBC in general
<< TOC - Writing Client Application >>