Introduction
<< TOC - Introducing CSQL Replication >>
This chapter gives a brief introduction to 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. Further, 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 site.
Information in this Manual
This manual describes CSQL concepts, components, and basic usages and could be useful for the following CSQL Users.
- Database Administrators
- Application Designers
- Programmers
Before reading this manual, understanding of following background knowledge is recommended.
- Basic knowledge required for Linux Operating System and Operating System Commands.
- Experience in using the relational database or understanding of the database concepts.
Conventions
The below typographic and syntax rules have been maintained throughout the guide.
Typographic Rule
This manual uses the following typographic rule.
Table 1.1. Typographic Rule
| Formatting | USED FOR |
|---|---|
| Main Memory Database | This font is used for ordinary text |
| SELECT * FROM T1 | This font is used for SQL Statements and Program code |
| UNIQUE | This font with uppercase letter indicates SQL keywords and data types |
| csql.conf | This font indicates file name and path |
| build.ksh | This font is used for command lines |
| SQLFetch( ) | This font is used for function names |
| Java.Sql.Statement | This font is used for interface, classes and header files names |
| Test | This font is used for directory name |
Syntax Annotation
This manual uses the following syntax annotation conventions.
Table 1.2. Syntax Annotation
| FORMAT | USED FOR |
|---|---|
| [ ] | This square bracket indicates that item in command line is optional |
| { } | Curly braces indicates that one must choose one of the items separated by a vertical bar( | ) in a command line |
| | | A vertical bar separates arguments |
| … | An ellipsis indicates that arguments can be repeated several times |
| $ | This dollar sign indicates the Linux prompt |
| # | The pound sign indicates the Linux root prompt |
Additional Documentation
The following sections describe the on-line documents that supplement the information in this manual. Please refer to these documents before begin using database server. They contain absolutely necessary information about installation, configuration and performance issues.
On-Line Help
The set of CSQL documentations is available on the CSQL web site: http://www.csqldb.com/prod-Documentation.html
Documentation Notes, Release Notes
The following on-line documents appear in the installation package under $csql/docs directory.
| File | Purpose |
|---|---|
| User Manual | This manual describes concepts, components, basic usages, and installation and configuration details of CSQL on Linux platform. |
| Programmer Guide | This manual is for application developers who use CSQL drivers to access data in the database programmatically. It covers JDBC, ODBC and proprietary SQL interface. |
| Cache Guide | This manual describes caching functionality of CSQL and configuration settings required to set up caching for MySQL, Postgres and Oracle DBMS. |
<< TOC - Introducing CSQL Replication >>