Best Real-Time Analytic Databases for Apache Flink

StarTree Cloud is a fully-managed real-time analytics platform designed for OLAP at massive speed and scale for user-facing applications. Powered by Apache Pinot, StarTree Cloud provides enterprise-grade reliability and advanced capabilities such as tiered storage, scalable upserts, plus additional indexes and connectors. It integrates seamlessly with transactional databases and event streaming platforms, ingesting data at millions of events per second and indexing it for lightning-fast query responses. StarTree Cloud is available on your favorite public cloud or for private SaaS deployment. StarTree Cloud includes StarTree Data Manager, which allows you to ingest data from both real-time sources such as Amazon Kinesis, Apache Kafka, Apache Pulsar, or Redpanda, as well as batch data sources such as data warehouses like Snowflake, Delta Lake or Google BigQuery, or object stores like Amazon S3, Apache Flink, Apache Hadoop, or Apache Spark. StarTree ThirdEye is an add-on anomaly detection system running on top of StarTree Cloud that observes your business-critical metrics, alerting you and allowing you to perform root-cause analysis — all in real-time.

Apache Doris is an advanced data warehouse for real time analytics. It delivers lightning fast analytics on real-time, large-scale data. Ingestion of micro-batch data and streaming data within a second. Storage engine with upserts, appends and pre-aggregations in real-time. Optimize for high-concurrency, high-throughput queries using columnar storage engine, cost-based query optimizer, and vectorized execution engine. Federated querying for data lakes like Hive, Iceberg, and Hudi and databases like MySQL and PostgreSQL. Compound data types, such as Arrays, Maps and JSON. Variant data types to support auto datatype inference for JSON data. NGram bloomfilter for text search. Distributed design for linear scaling. Workload isolation, tiered storage and efficient resource management. Supports shared-nothing as well as the separation of storage from compute.

VeloDB, powered by Apache Doris is a modern database for real-time analytics at scale. In seconds, micro-batch data can be ingested using a push-based system. Storage engine with upserts, appends and pre-aggregations in real-time. Unmatched performance in real-time data service and interactive ad hoc queries. Not only structured data, but also semi-structured. Not only real-time analytics, but also batch processing. Not only run queries against internal data, but also work as an federated query engine to access external databases and data lakes. Distributed design to support linear scalability. Resource usage can be adjusted flexibly to meet workload requirements, whether on-premise or cloud deployment, separation or integration. Apache Doris is fully compatible and built on this open source software. Support MySQL functions, protocol, and SQL to allow easy integration with other tools.

Scale from 0 to millions of events every second. Arroyo is shipped as a single compact binary. Run locally on MacOS, Linux or Kubernetes for development and deploy to production using Docker or Kubernetes. Arroyo is an entirely new stream processing engine that was built from the ground-up to make real time easier than batch. Arroyo has been designed so that anyone with SQL knowledge can build reliable, efficient and correct streaming pipelines. Data scientists and engineers are able to build real-time dashboards, models, and applications from end-to-end without the need for a separate streaming expert team. SQL allows you to transform, filter, aggregate and join data streams with results that are sub-second. Your streaming pipelines should not page someone because Kubernetes rescheduled your pods. Arroyo can run in a modern, elastic cloud environment, from simple container runtimes such as Fargate, to large, distributed deployments using the Kubernetes logo.