Splice Machine has released version 1.5 of its Hadoop RDBMS, which adds multiple enterprise-ready features.
"We're proud to release version 1.5 of our Hadoop RDBMS as another milestone in the development of our solution," said Monte Zweben, co-founder and CEO, Splice Machine. "We have added major enterprise-ready features and made significant enhancements to our cost-based optimizer, which dramatically improves performance on analytical queries. In 1.5, we have combined industry standards like SQL and ACID compliance with a modern scale-out architecture – bringing us one step closer to having a single database platform that powers real-time applications and analytics."
In working with customers and partners, Splice Machine says its team identified key functionality and performance improvements that would enable companies to increase the benefits of using Splice Machine to support real-time applications, run operational data lakes, and accelerate their ETL pipelines.
A PDF of the Fall 2015 issue of Big Data Quarterly magazine is available for download now. To become a subscriber to the print magazine, go to www.dbta.com/BigDataQuarterly/Subscribe.aspx.
In the area of SQL compliance, new features in version 1.5 of Splice Machine's Hadoop RDBMS include support for foreign keys, which enables referential integrity between tables, and triggers to execute procedural code based on update, insert or delete actions.
The new release also expands BI tool compatibility for popular tools with the addition of temporary tables which enables BI tools to create temporary tables to perform operations on intermediate results, and delivers pre-built SQL functions such as TOP N, LIMIT N, MONTHNAME, QUARTER, WEEK and NOW.
Splice Machine 1.5 also enables incremental backups to provide recovery from data corruption by backing up data changed since last backup; and provides FIRST, LAST, LEAD and LAG functions for advanced analytical queries.
In terms of performance, there is the ability to collect more granular statistics in order to choose the best query plan; cost-based optimizer improvements for ordering of table access, selection of query plans, index selection, and join algorithm selection (e.g., broadcast join, merge join, merge sort join, batch nested loop join); and subquery unrolling which converts subqueries in joins to accelerate certain analytical queries by more than 1,000 times.
The Splice Machine database is available for licensing at a per node price that includes 24/7 technical support. Version 1.5 is also now available to download and try at www.splicemachine.com/download. For more information about Splice Machine, visit www.splicemachine.com.
Image courtesy of Shutterstock.