Splice Machine's SQL on Hadoop database goes on general release

Created out of the technology from two Apache projects, Splice Machine's real-time relational database is now available with a number of extra features.

Read this

Full SQL on Hadoop? Splice Machine opens up its database for trials

Splice Machine has brought together technology from two Apache projects in its quest to create a SQL-on-Hadoop database.

Read More

After six months in public beta and a 20-company charter testing scheme, Splice Machine today released version 1.0 of its Hadoop database.

The company describes the product as opening up the Hadoop stack to a full-featured SQL database, capable of running transactions and analytics simultaneously.

Splice Machine has brought together technology from two Apache projects, taking the Apache Derby Java relational database and replacing its storage layer with the Apache HBase NoSQL database. Then it has modified the planner, optimiser and executor inside Derby to take advantage of HBase's distributed architecture.

The firm said feedback from companies taking part in testing has resulted in a number of improvements to the database for version 1.0.

These include analytic window functions to provide advanced SQL analytics based on the SQL:2003 standard, native backup and recovery, and bulk and parallel export for moving query results to spreadsheets.

Also featured in version 1.0 is support for the Hadoop HCatalog table and storage management layer for integration with MapReduce, Hive , Pig and Spark .

Users, who can now download the standalone version of the Splice Machine Hadoop RDBMS, also now have LDAP authentication and column-level privileges, and Console v1.0 to provide insights into query performance.

The company is promoting the database as an alternative for businesses experiencing cost or scaling issues with Oracle or MySQL.

"With these new features and the validation from our charter customers, we are now fully prepared to support enterprises struggling with their existing databases and looking to scale-out affordably," Splice Machine co-founder and CEO Monte Zweben said in a statement.

To help companies migrate database workloads, Splice Machine is offering its Safe Journey methodology, which it said implements risk-mitigation best practices and uses commercial tools to automate most of the PL/SQL conversion process.

"This program encompasses comprehensive services and support, including training courses, a Kickstart package to speed implementation, and on-demand consultants to optimise ongoing operations," Splice Machine said.

Since May, the ACID-compliant product has been available on a freemium basis for test developments and experimentation. When the beta was launched, Splice Machine had a list price annual licence fee of $5,000 per node when used in production.

Splice Machine is a contributor to the Hadoop and HBase projects but does not offer all its code back to the community.

More on Hadoop and databases

Show Comments