CSQL Enterprise Version 2.2 Released
Press Release, Nov 21, 2008
Inner Join, Tree Index, Multiple cache nodes and vertical and horizontal partial caching
BANGALORE, India. – Lakshya Solutions Ltd. announced the release of CSQL Main Memory Database Cache. Lakshya is known for the database solutions and telecommunication software products. CSQL2.2, featuring the significant set of changes since 2.1, was released. Technical details of the new features are available in manuals on documentation page.
Prior to this release, CSQL supported only hash indexes. This version implements tree index with a fast ever-optimized parser to fasten the query execution. Sometimes applications want to cache only latest or certain records from large table in target database to speed up the acccess. In order to support that, partial caching is implemented where only a section of the records or fields can only be cached instead of whole table.
What is included in CSQL2.2 ?
- Inner Join support
- Tree Index
- Arithmetic Expression in update statement
- Multiple cache nodes
- Row Level and Field Level Partial Caching
About Lakshya Solutions
LAKSHYA Solutions Limited is the most respected software solutions and products development company in the domain of Telecom, Database, VXML / Speech enabled applications and Business Intelligence and Data Analytics solutions. Its flag ship product include CSQL (Main memory database) and Commtel (Contact center platform). Lakshya customer base includes major telecom and mobile operators in India.
http://www.lakshyasolutions.com
Contact: arindam.chakrovorthy@lakshyasolutions.com
CSQL Cache Supports Caching for Postgres Database
Press Release Nov 14, 2008
BANGALORE, India - Lakshya Solutions, a unique provider of communication driven software product and database solution, today unveils about CSQL Cache, Main Memory Database Technology that speeds up not only MySQL database, but also PostgreSQL, a world’s most advanced open source database.
CSQL Main Memory Database is deployed in the middle-tier as a cache for Postgres Database in order to accelerate enterprise applications and improve the performance up to 20-40 times. When storing performance-critical data from Postgres to CSQL Main Memory Cache, application gets response time in microseconds by bringing the frequently accessed data closer to the application, and by executing SQL requests in the CSQL Main Memory Database Cache.
Furthermore, CSQL Cache delivers 100 times faster response time for cached tables as it uses fastest MMDB which is built using memory optimized algorithm and avoids network overhead for accessing cache tables.
By using CSQL Cache, industries such as telecommunication, healthcare, financial services, ticketing and reservation systems, e-commerce applications, online gaming, and software as a service (SAS) application platforms where Postgres is considerably famous and used by hundreds of companies can significantly scale without additional hardware.
For more information on CSQL Main Memory Database Cache, please visit: http://www.csqldb.com
CSQL 64 bit Main Memory Database supports massively larger databases
Press Release Nov 12, 2008
BANGALORE, India – Lakshya Solutions CSQL development team today released CSQL-64 bit version of its CSQL Main Memory Database Cache for real-time enterprise systems and is available on Linux(x86_64) and Solaris(Sparc64).
This release supports databases that are hundreds of times larger than the 32-bit version, providing a powerful new tool in the areas such as Internet commerce, event-driven planning, financial trading and risk analysis, and intelligent networking are prime examples of applications that demand real-time performance.
One of the most attractive features of 64-bit is the amount of memory the system can support. It will allow systems to address well over 1 terabyte of memory. CSQL having memory centric architecture, can be streamlined to remove unnecessary processing overhead and thereby performing on average of 20-30 times faster than conventional databases.
CSQL also supports advanced database features such as row-level locking, multi-threaded applications, automatic recovery, and full support for the ACID properties.
For more information, please visit: http://www.csqldb.com
CSQL Enterprise Version 2.1 Released
Press Release Aug 22, 2008
BANGALORE, India. – Lakshya Solutions today announced that CSQL 2.1 Enterprise is released. Lakshya develops and markets innovative telecommunication-aimed products and targeting real-time application industries such as Telecom, Finance and Stock Market, etc, by unveiling CSQL’s potentiality which provides 20-30x faster execution than any other leading database in market.
Major features added to MMDB are Composite Keys, Binary Data type, Aggregate functions, etc. Major enhancement for Cache component is support for PostgreSQL. Currently, CSQL provide cache support for two major open source databases, we are eyeing for cache support for Oracle in our upcoming release.
Following are the additions for the Version2.1
- Composite Keys
- Binary Data type
- Aggregates and Group By support
- LIKE operator
- Cache support for PostgreSQL
For more information on CSQL Main Memory Database Cache, please visit: http://www.csqldb.com
Lakshya announces release of CSQL Enterprise 2.0
Press Release May 12, 2008
BANGALORE, India. – Lakshya Solutions, a leading provider of Database solutions and Telecommunication software and solutions, today proclaimed the release of major enhancements to its “CSQL Main Memory Database Cache” software.
Enhanced functionality and features such as ODBC Driver and Backup for tables and records also empowers MMDB Component with more outstanding performance. This GA fixes many bugs through a rigorous testing and fixing of memory leaks.
Following are the additions in this release
- Primitive ODBC Driver
- csqldump tool
- cacheverify tool to verify the cache coherency with the target database
- Bi-directional update propagation support for cached tables
- Memory leak fixes
- Improved test coverage in DBAPI, SQLAPI and ODBC Interfaces.
All the code has been through a rigorous testing where more than 95% of code is exercised by regression testing. We consider that this release will be stable and ready for production use. For more information on CSQL Main Memory Database Cache, please visit: http://www.csqldb.com