We are launching CrateOM: a smart solution that transforms process data into actionable insights

Learn more
Skip to content

Compare CrateDB

How is CrateDB different from other databases in the market?

Azure TSI can be a good solution for some consumer-IoT applications, but for IoT use cases in need of high scalability, CrateDB is a better fit. Unlike TSI, CrateDB is purpose-built to handle huge volumes of time-series data in real time and without reducing accuracy.

First, using Azure TSI on an industrial scale comes with very high costs. Azure TSI is subject to limitations in data queries (150,000 records, with only 10 concurrent queries on warm data allowed) and data ingress (72.000 records/min or 1200 events/sec). TSI is not built for scalability: on the contrary, the distributed nature of CrateDB makes it easy to scale horizontally, offering automatic replication and cluster rebalancing.

WHITE PAPER

Scalability in CrateDB: Benchmark

CrateDB scales linearly: its performance consistently improves as more nodes are added to the cluster

Azure TSI is built on top of Azure Data Explorer, so its full functionality can only be accessed by the Kusto Query Language. Data can only be queried, not written, and an external API is needed to establish communication between TSI and the underlying database. This can create problems: there is a risk of vendor lock-in, and to have the query language separated from the database restricts future development.

WEBINAR

Why the IIoT needs its own database?

Industrial IoT can cause a new manufacturing revolution... But as Christian Lutz explains in this webinar, IIoT projects won't succeed without the right tools

Without abandoning SQL, CrateDB offers a very versatile data model, performing aggregations, JOINs, sub-selects, and ad-hoc queries at in-memory speed. It processes changing data models and JSON objects fluidly, with automatic schema updates as JSON objects change or are added. CrateDB also integrates native, full-text search features, and it supports JOIN and Postgres wire protocol. In contrast to Azure TSI (which automatically infers a schema), CrateDB schemas are totally flexible: columns can be added anytime, without slowing performance.

Besides, CrateDB has an eventual consistency model that allows prioritizing data availability in complex queries, offering a very efficient real-time performance. Azure TSI doesn’t really offer a real-time response, since it queries in the order of seconds up to a minute. Aggregation queries that in TSI can take up to one minute take seconds or milliseconds in CrateDB.

KEEP LEARNING



Screen-Shot-2020-06-24-at-9.03.20-AM (1)

WHITE PAPER

An Introduction to CrateDB Cloud on Azure

CrateDB Cloud, our fully-managed database in the cloud, is now fully integrated in the Azure ecosystem.

Comparing Databases

WHITE PAPER

The cost of running MongoDB, TimescaleDB and CrateDB for Industrial IoT

Find out how much the monthly price can vary if different databases are used. 

Picture7-600x360-1

WHITE PAPER

The Curious case of time-series data

What are time-series data, really? We talk about it in this webinar, including a little demo

Subscribe to the Crate.io Newsletter now

We respect your privacy and data. Your information will not be shared with third parties. You can unsubscribe from this newsletter at any time.