Machine Data Innovations That You Should Know About

CrateDB is an SQL database alternative to NOSQL machine data management solutions. It gives mainstream SQL developers access to machine data applications that previously were available only using NoSQL solutions.

“CrateDB is one of the few systems in the space that can enable JOIN to handle a large amount of machine data,” said Christian Lutz, CEO of Crate.io.

Founded in 2014, the company’s goal was to reinvent SQL for the machine data era, he told LinuxInsider. Today, 75 percent of its customers use CrateDB to manage machine and Internet of Things data because of its ease of use, performance and versatility.

CrateDB provides an alternative to existing analytic data stores, combining the familiarity of SQL with the versatility of search and the ease of scalability of containers.

“The growth of machine data and the opportunities that businesses have to capitalize on it are outstripping the ability of their data management infrastructure to act on it,” said Jason Stamper, an analyst for data platforms and analytics at 451 Research.

CrateDB’s power lies in its ability “to enable users to collect and analyze vast amounts of data in real time, using SQL commands they already know,” he said.

 

Driving Factors

Several factors recently have been driving interest in more effective management of machine data, and CrateDB is tapping into this growth, observed Charles King, principal analyst at Pund-IT.

“First and foremost, as companies utilize cloud services and infrastructures, getting the most from those investments requires automating related processes and services,” he told LinuxInsider. “That demands the efficient gathering of machine data automatically generated by systems applications, transaction applications, customers and users which has resulted in success for machine data players like Splunk.”

In addition, the anticipated rise of IoT devices and deployments will increase the volume of machine data by orders of magnitude, he said, so the efforts that companies make today around managing machine data should pay significant dividends in the future.

CrateDB is the first open source SQL database that enables real-time analytics for machine data applications, according to Crate.io.

If that is indeed the case, that would make it superior to previous applications based on NoSQL technologies.

“That should make CrateDB easier to use for developers familiar and comfortable with SQL databases,” King said. “If the company can deliver on its promises, it should become a significant player in this space.”

 

CrateDB Primer

Crate.io focused on developing a database for the billion-dollar machine data market, Lutz said. “This market is very broad with very special characteristics. It involves more than just industrial machines.”

The machine data management market involves IoT sensors, wearables, industrial IoT, network monitoring, IT/cloud infrastructure monitoring, security audit monitoring and machine learning.

CrateDB manages the unique challenges of machine data management and analysis. It makes possible the handling of millions of data points per second, structured and unstructured data diversity with real-time query performance, and complex queries of big data volumes.

As part of a new machine data stack, CrateDB sits in the stack between input software and specialized apps, Lutz said.