Product
The Splice SQL Engine™
The Splice SQL Engine™ delivers a massively scalable database without the compromises of NoSQL or traditional relational databases. Companies can use it to access their Big Data without having to rewrite existing SQL-based applications or Business Intelligence (BI) tools.
Built on the proven Hadoop stack, the Splice SQL Engine extends HBase to provide robust SQL support, secondary indexes, join optimizations and transactional integrity. Key benefits include:
Cost-Effective Scalability
By leveraging the proven auto-sharding in the Hadoop Distributed File System (HDFS), the Splice SQL Engine can easily scale from gigabytes to petabytes using cost-effective, commodity hardware.
Flexible Schema
Splice Machine uses the flexible schema in HBase to handle rapidly changing application data requirements. With its compact, column-oriented design, the Splice SQL Engine can efficiently store semi-structured and unstructured data.
High Availability and Fault Tolerance
Splice Machine leverages the high availability and fault tolerance built into the Hadoop stack. For instance, HBase and HDFS provide automatic failover support between nodes, and MapReduce automatically restarts failed jobs.
Transactions
The Splice SQL Engine delivers real-time updates with the transactional integrity most SQL developers expect. Splice Machine uses a state-of-the-art snapshot isolation design to provide high transactional throughput without deadlocks.
SQL Optimizations
With an enhanced SQL parser, the Splice SQL Engine provides rich support for existing queries. It also enhances HBase to deliver fast query performance with typed columns, secondary indexes and optimized joins.
Powerful Aggregation
Developers can use MapReduce to perform powerful aggregation across massive data sets.
Flexible Application Integration
Splice Machine provides flexible integration options such as RESTful APIs and ODBC drivers, so developers don’t need to rewrite existing SQL-based applications and BI tools to access their Big Data.
To sign up for a look at the Splice SQL Engine, click here.