BT

Splice Machine Version 1.0 Supports Integration with Hadoop and Analytic Window Functions

| by Srini Penchikala Follow 35 Followers on Dec 18, 2014. Estimated reading time: 2 minutes |

Splice Machine version 1.0 supports analytic window functions and integration with Hadoop ecosystem. Splice Machine team recently released their Hadoop based RDBMS data management solution that can be used for transactional workloads on Hadoop.

Its architecture is based on Apache Hadoop Big Data analytics engine, HBase and Apache Derby database to leverage the scalability of Hadoop technology. With the support for ACID transactions, the database can be used for real-time applications and operational analytics for processing big data and scalability.

Splice Machine released the public beta offering back in May and they worked with the beta customers on testing the functionality and performance of the product before releasing the version 1.0.

Main product features in this version are:

  • Analytic Window Functions: These functions provide SQL analytic capabilities based on the SQL-2003 standard. Analytics include running totals, moving averages, and Top-N queries. Supported Window Functions include RANK, DENSE_RANK, and ROWNUMBER.
  • Integration with Hadoop Ecosystem: This integration includes the Apache HCatalog support to work with MapReduce, Hive, Pig, and Spark frameworks. HCatalog provides a relational view of data stored in the Hadoop Distributed File System (HDFS). Users can run queries against the data stored in Splice Machine, Spark, and Hive tables in HCatalog without knowing where and how each data set is stored.
  • Authentication and Authorization: Authentication support includes integration with LDAP v3 standard and FIPS-compliant password hashing algorithms like SHA-512 (default). And the authorization model allows DBAs to create new users to access the data stored in Splice Machine database. It also includes the privileges to control read and write operations at a table or column level.
  • Native Backup & Recovery: This includes a transaction-aware data backup and restore feature to ensure business continuity. This is a hot backup capability that allows applications and workloads continued availability while the backup of the database is in progress.
  • Bulk, Parallel Export: This is used to export query results into text files in Comma Separated Values (CSV) format. All cluster nodes are used in generating the query results.
  • Splice Machine Management Console: The console provides insight into query performance like viewing explain traces on queries. Explain trace shows the timing of the query operation and the distribution of data.

A standalone version of the Splice Machine Hadoop RDBMS, version 1.0, is now available for download on their website. Splice Machine also has a free version of the product which is offered to companies that are less than five years old and generate $10 million or less in revenues.

Splice Machine offers a data migration support program called "Safe Journey" to assist the enterprise customers who are deploying Splice Machine v1.0 in their organizations, with the migration of the customers' database workloads.

For more information on Splice Machine's technical architecture, check out Q&A interview InfoQ conducted earlier this year with Rich Reimer, VP of Marketing and Product Management.

 

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT