Menu

M2M FEATURE NEWS

Clustering, Security Enhance Crate.IO IoT Database

By Paula Bernier May 16, 2017

Crate.io, a company that specializes in databases for Internet of Things applications, today came out with CrateDB 2.0. The SQL database is also now available in an enterprise version.

Special databases are required to handle the fire hose of data that IoT creates and the fact that this data can be messy as opposed to tabular and neat, said Andy Ellicott, Crate.io’s chief marketing officer. CrateDB addresses all that, and enables organizations to query and analyze data in real time. Now, version 2.0 of CrateDB brings clustering upgrades for better performance and resiliency. “It just makes CrateDB faster,” Ellicott explained.

CrateDB 2.0 also lets users drill down into sensor readings based on such parameters as sensor type, time, geographic region, IP addresses, etc. “Those are pretty complex queries for any database…and clustering makes it even faster,” said Ellicott.

This new version of the database also features SQL improvements. That includes aggregations on Joins, sub selects, table renaming, and reindexing.

And the new Enterprise Edition of CrateDB 2.0 offers premium features including better security, which leverages authentication and authorization; better visibility on who’s doing what; and improved analytics. CrateDB is available via three annual subscription levels. That starts at $500 per month per cluster. And CrateIO offers discounts for startups. The company also now offers CrateDB as a managed service. CrateIO, which was founded in 2014, in December launched its open source, SQL database. Today CrateIO has more than 60 customers in production and more than 12 paying customers. 

Among the CrateDB users are a fleet tracking company called Clickdrive.io out of Singapore. Roomonitor is another CrateDB customer. The company, which is out of Barcelona, Spain, enables rental property owners and managers to monitor whether air conditioning is being wasted and whether there’s too much noise at their locations.




Edited by Ken Briodagh

Executive Editor, TMC

SHARE THIS ARTICLE
Related Articles

Beyond the Closet, Connecting to IoT

By: Gary Audin    11/11/2020

Two challenges arise when considering cable based IoT.

Read More

Banyan Security Enhances Secure Remote Access for Engineering Resources

By: Ken Briodagh    10/27/2020

Banyan's Continuous Authorization Can Grant or Revoke Access to Sensitive Engineering Environments and Applications in Real-time Based on TrustScore

Read More

Senet Eyes RAN Partnerships as Key to Delivering Network Services for Massive IoT

By: Arti Loftus    10/21/2020

To meet the challenges that come with providing network connectivity for IoT solutions, Senet is executing a strategy for massive IoT that will be bui…

Read More

mimik Selected by 5G Open Innovation Lab to Drive Early Adoption of 5G

By: Ken Briodagh    10/15/2020

mimik's patented Hybrid Edge Cloud platform will boost the performance and reduce the cost of 5G Networks

Read More

5G Sets New Standards for Vertical Industries' IoT Connectivity

By: Special Guest    10/13/2020

As 5G rolls out across the world, vertical industries across IoT are working on additional standards to make the technology suitable for their industr…

Read More