Press Release, Oct 15, 2009
Lakshya, software product company focused on solutions for database and communication-driven products, today announced that it has released version 3.0 of its CSQL In-Memory Database Management System (IMDB) and Cache. With this release, CSQL strengthens its query processing through statement caching and with numerous performance optimizations. This release is tested with asterisk (open source PBX) Real Time data management for managing SIP Users/ Queues, etc.
Following are the list of features added in this release.
- Statement Caching
- Explain Plan support
- Cache Support for DB2
- IS NULL support
- FreeBSD Porting
- Performance Improvements
- Improved Test Coverage
Customers in all industries, including Telecommunication, banking and financial, Web 2.0, etc can take advantage of this instantaneous access to information and multiply data access throughput by 20 to 30 times. CSQL is employed in Mobile VAS SDP platform to cache profile, subscription, content, content delivery information to improve the overall throughput of the system with minimal hardware.
About CSQL
CSQL is the fastest enterprise class open source main memory relational database management system. Traditional disk based database management systems are incapable with dealing with dynamic data that constantly changes. Real Time applications that require predictive response time in few microseconds rather than in milliseconds uses CSQL as stand alone DBMS or as cache for general purpose DBMS such as MySQL, Postgres, Oracle, DB2, Sybase, etc
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
Press Release, Aug 14, 2009
The Indian Software and Services Company, Wipro Technogies has selected CSQL, as the DBMS to mediate call events in real time from Avaya PBX to Nortel Voice Application server. Due to its high data volume, voice applications could not retrieve CLI within the stipulated time resulting in reduced customer satisfaction.
Some highlights of the implementation are
- Main requirements are invisible installation, zero maintenance and a small footprint.
- Linux and Solaris versions of CSQL to be employed in this solution.
About Wipro Technologies
The #1 provider of integrated business, technology and process solutions on a global delivery platform. The India and Middle East IT business unit of Wipro Limited is one of the fastest growing companies in the Middle East. This unit offers a 360 degree service portfolio spanning the entire IT life cycle. This includes Consulting, Business Solutions, System Integration, Infrastructure and Application Management and Total Outsourcing services where we service all IT needs of a customer, end-to-end.
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
Press Release Aug 17, 2009
Lakshya, software product company focused on solutions for database and communication-driven products, today announced that it has released version 2.6 of its CSQL In-Memory Database Management System (IMDB). With this release, CSQL strengthens its SQL Engine by adding many features to SQL layer. These features enables CSQL to be used in reporting applications as well as low-end data analytic (OLAP) applications.
CSQL's memory-resident architecture can boost performance by orders of magnitude compared to traditional disk based relational database systems. With its inherent performance boost, analytic applications can retrieve results within seconds for billions of fact records.
Following are the list of features added in this release.
- Table granular replication
- Automatic recovery for replication
- Support for ORDER BY clause
- Support for DISTINCT clause
- Support for LEFT OUTER JOIN
- Multiple Data source caching
- Foreign Key
- Cache support for Sybase
- Support for default value NOW for system date and time
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
Press Release May 25, 2009
Nokia Siemens Network has selected CSQL as it caching platform to improve the throughput of their application currently using ORACLE RAC.�They will be employing asynchronous bidirectional caching mode of CSQL to cache data in application tier from oracle database to deliver real time response.
Some highlights of the implementation are
- Linux 64 bit version to be employed in this solution
- Cache from existing Oracle database running in RAC
- Two Cache node instance caching tables from its respective oracle database
About Nokia Siemens Network
Nokia Siemens Networks is one of the largest telecommunications solutions suppliers in the world. Nokia Siemens Networks was created as the result of a joint venture between Siemens AG's Communication and Nokia's�Network Business Group. Nokia Siemens Networks operates in approximately 200 countries worldwide, and has about 60,000 employees. Its major manufacturing sites are in China, Finland, Germany, Poland and India. The customer base of Nokia Siemens Networks includes 1,400 customers in 150 countries (including more than 600 operator customers).
http://www.nokiasiemensnetworks.com
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
Press Release May 16, 2009
Auto-Incremented Key, Command history for CSQL tool and cachetable tool option to display cached tableLakshya Solutions, a leading provider of database solutions and telecommunication software and services, today announced that the release of CSQL 2.5 for Linux and Solaris platform.
CSQL Database Technology�s new features makes it even easier for developers and users to use the powerful database management system with auto-incremented key for fields, flexibility to use csql interactive tool by supporting command history and option for cachetable tool to get the information about cached table.
Anyone needing help for performance issues with their disk based databases can install and use CSQL to get a formidable performance, which is 20-40 times more than traditional database systems. Tranparent caching and two-way communication between CSQL and Target database are the cornerstones of CSQL.
Some of the new features included in this release
- Auto increment key
- Equi Join
- Command history for CSQL tool
- Logical Undo logging for Tree Index
- cachetable tool option to display cached table information
CSQL enhanced its power by giving tens of hundreds of concurrent connection with an minutes in installation procedure and failure reporting for designated connections. CSQL2.5 Trial version is available now in the csql web site for download.
For more information, visit http://www.csqldb.com
Contact: arindam.chakrovorthy@lakshyasolutions.com
Press Release Mar 23, 2009
By providing 30-40 times faster performance for real-time application, CSQL enables customers of Oracle to generate more revenues while reducing their cost significantly.Lakshya Solutions, a leading telecommunication driven and database solution company, announced today that CSQL Main Memory Database Cache, a world�s fastest performance solution software, is all set to support Oracle Database along with MySQL and Postgres to speed up real time SQL queries 30-40 times faster than ever.
Oracle provides database solutions to real-time applications for the industries like Telecommunication, Healthcare, Financial services, ticketing and reservation, e-commerce and Government across world. But in today�s fast paced business environment, the ability to access, capture, analyze data in real time is increasingly becoming the source of competitive advantage for many companies.
To provide the best response time for huge amount of data in real-time application, CSQL resides in the middle-tier alongside application 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. Mobile operators use the software for billing, so that they can quickly determine whether a caller has enough prepaid credit to place a call or not.
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. By using CSQL companies could significantly reduce their TCO (Total Cost of Ownership) by more than 80%.
For more information, visit http://www.csqldb.com
Contact: arindam.chakrovorthy@lakshyasolutions.com
Press Release Mar 16, 2009
Lock free data structure; synchronous and asynchronous update propagation for replication and caching.Bangalore, India. � Lakshya Solutions, a leading provider of Database solutions and Telecommunication software, today announces an update for CSQL Main Memory Database Cache to version 2.4. CSQL is mainly for middle-tier caching for MySQL and PostgreSQL. This version also includes numerous features to MMDB as well as to Cache.
This version is a full working version of the CSQL In-memory Database Cache. CSQL is an database cache that takes the headache out of caching table of your target databases (or a some section of records as per the application requirement) to boost the performance of applications by keeping the data in MMDB to provide 20-40x faster performance. When the application update records at CSQL / target database, the updates are automatically propagated between CSQL and target database.
What is New ?
- Support for durable transactions and recovery
- Equi Join
- Cache support for Oracle (Bi-directional)
- ASYNC update propagation to target database
- Coherent Distributed Cache
- Bulk Loading support for SQL API
- Unique constraint support for tree index
- Performance Fixes and Bug Fixes
Demo version can be downloaded from the CSQL product page at http://www.csqldb.com/download.html, You can evaluate CSQL for 30 days for free, however, after 30 days, you should purchase a license. The demo version of CSQL will show a report to let you know about product registration key, which can only be obtained by sending mail to sales@csqldb.com
Contact: arindam.chakrovorthy@lakshyasolutions.com
Press Release Feb 16, 2009
Prodea systems has selected CSQL as it caching platform to minimize the overhead of managing distributed database across US and outside. For their VOIP solutions, they want Subscriber information to be available in multiple zones at real time. Any modification in the database should be automatically propagated to all the cached instances without manual intervention at near real time.
Some highlights of the implementation are
- Main requirment is the ease to use of caching platform
- Transparent updateable cache tables
- Cache across WAN
- Linux 64 bit version to be employed in this solution
- Cache from existing postgres database
About Prodea Systems
Prodea Systems, based in Plano Texas, is an emerging private company formed to address the challenges of today�s increasingly complex digital home and connected small business environment. Having a strong legacy steeped in developing solutions for the service provider community, Prodea Systems is uniquely positioned to both understand and solve the complex task of delivering multiple carrier-class, Internet-based applications and services to the consumer.
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
Press Release Feb 12, 2009
Supports Client/Server architecture, JDBC Data Source and performance improvementsBANGALORE, India. � Lakshya Solutions Ltd. an ace in telecommunication industry and database solution provider for real time applications, continues to provide high performing and low cost business solutions with the launch of its CSQL 2.3 Enterprise edition.
With new CSQL database software, global companies can both cache their data from Target database with a simplified Cache platform and preserve their data in CSQL MMDB to carry on ultra fast online transactions. The combination of the two capabilities(main memory database and cache) in one offering can help deliver new results and insights to grow the business and lower costs.
Some of the new features included in this release:
- JDBC Data source support
- Client/Server for ODBC, JDBC and ISQL
- Support for simple expressions in UPDATE statement
- ResultSetMetadata and ParameterMetadata for JDBC
- Performance Improvement and Bug Fixes
- Wisconsin Benchmark Suite
This release fixes several bugs including performance improvments and employs the Wisconsin Benchmark to measure the several predefined query performances with other target databases. Please visit benchmark link on csqldb web site for more information.
Contact: arindam.chakrovorthy@lakshyasolutions.com

