PIVOTAL SQLFire Technology
What Is SQLFire and How Is It Powered by GemFire?
SQLFire leverages the decade of research and development that went into making GemFire the data grid of choice for some of the biggest enterprises in the world. Because of its GemFire legacy, SQLFire supports highly optimized in-memory data management, split-brain detection, group membership management, highly optimized metadata management, extreme data volume support in-memory and on disk, high availability through a variety of techniques, WAN replication capabilities, in-memory stored procedure support, and a scalable management and monitoring framework.
Relational Technology Based on Apache Derby
SQLFire leverages Apache Derby to provide a familiar SQL interface to applications while leveraging the in-memory technology, the elasticity and the scaling characteristics of GemFire. The combination of these two very mature code bases provides a product that delivers stellar performance, as well as the broad SQL support needed for OLTP applications.
One of the important characteristics of relational databases is their ability to support referential integrity ensuring that foreign key relationships are honored in a transactional system. SQLFire supports referential integrity in the system and allows your users to configure foreign key relationships across tables and enforces these at run time. In this area, most NoSQL products cannot compare with SQLFire and traditional databases.
Standards-Compliant Powerful Querying Engine
SQLFire provides a powerful querying engine that is optimized for a distributed system. It includes a distributed cost-based optimizer that ensures the generation of optimal query plans to satisfy queries accessing data across the system. Most common queries and Data Manipulation Language (DML) statements are based on ANSI SQL-92, so experienced database application developers can use their knowledge of SQL when working with SQLFire. SQLFire is implemented entirely in Java, and it can be embedded directly within a Java application. The use of JDBC, ADO.NET and ODBC (coming soon) drivers ensures that application code accessing the database can use familiar programming constructs without being subject to the scaling limitations of traditional databases.
Data-Dependent and Data-Aware Java Stored Procedures
SQLFire enables applications to run both data-aware and data-independent stored procedures on the cluster. These stored procedures run in parallel and provide results back to the sender, allowing for both synchronous, asynchronous and partially synchronous behavior execution in the data grid. These stored procedures enjoy extremely high throughput since they execute on data that is typically in-memory.