The In-Memory SQL Grid adds in-memory distributed database capabilities to the GridGain platform, which help dramatically speed up and scale out SQL applications with minimal or no code changes. The In-Memory SQL Grid is horizontally scalable, fault tolerant and ANSI SQL-99 compliant. It fully supports SQL and DML commands including SELECT, UPDATE, INSERT, MERGE and DELETE queries.
The In-Memory SQL Grid allows users to interact with the GridGain platform using standard SQL commands through the GridGain JDBC or ODBC APIs without custom coding. In addition to natively supported Java, .NET, and C++, the new JDBC and ODBC driver capabilities allow SQL-based cross-platform connectivity from languages such as Ruby, PHP, Python, and more.
Enhanced geospatial functionality is also supported by the In-Memory SQL Grid, making the GridGain in-memory computing platform well suited for an increasing number of location-based IoT use cases, such as those found in transportation, logistics, mobile, retail and wearables.
Redis is an open source in-memory data structure store that can be used as a database, cache and message broker. Native support for Redis in GridGain Professional Edition 1.8 enables users to store and retrieve distributed data to and from a GridGain cache using any Redis-compliant client. This allows users to easily migrate from the Redis caching solution to the full-featured GridGain in-memory computing platform with minimal changes to their client communication protocols.
Support is now provided for .NET Entity Framework's 2nd level cache, which can be easily plugged into existing applications. This delivers significant performance improvements because query results are stored in a shared, distributed, fault-tolerant cache.
Further, an enriched ASP.NET session management component provided by the Ignite.NET session state provider allows a session to be distributed across a cluster of machines for fault-tolerant workload balancing.
"The GridGain Professional Edition 1.8 is a major step forward for our in-memory computing platform. It adds key features which makes it easier for users to communicate with the GridGain platform and provides even better functionality for demanding use cases such as web-scale applications and the Internet of Things", stated Abe Kleinfeld, President and CEO of GridGain Systems. "As the world's most comprehensive in-memory computing platform, GridGain Professional Edition 1.8 makes it easier than ever for more companies to deploy in-memory computing to achieve their speed and scalability goals."
Based on Apache Ignite, GridGain Professional Edition enables data-intensive applications to scale out to petabytes of data and improve performance by 1,000x or more versus disk-based data stores without replacing their existing databases. GridGain provides high-speed transactions with ACID guarantees, real-time streaming, and fast analytics in a single, comprehensive in-memory computing platform. GridGain powers existing and new applications in a distributed, massively parallel architecture on commodity hardware, which can easily scale out by adding more nodes to the GridGain in-memory computing grid. GridGain requires minimal or no modifications to the application or database layers for architectures built on all popular RDBMS, NoSQL or Apache Hadoop databases.
The GridGain Professional Edition includes the latest version of Apache Ignite, patches that have not yet been released in Apache Ignite, and high-value LGPL libraries. Users receive regular maintenance releases with timely bug fixes. These bug fixes are contributed to the Apache Ignite project but are not released until the next Apache Ignite release cycle. GridGain Professional Edition 1.8, available to GridGain Standard Professional Support subscribers, is for companies that want support, timely bug fixes, and an easily deployed package when using Apache Ignite in production.