Aerospike SQL Powered by Starburst

Aerospike SQL Powered by Starburst provides a tightly integrated SQL processing engine to the Aerospike Real-time Data Platform. Powered by Starburst Enterprise, Aerospike SQL provides an enterprise-grade implementation of the open source Trino project (formerly PrestoSQL) that is installed, managed and supported by Aerospike. The combination of the Aerospike Database and the Starburst SQL engine offers a rapid and cost effective way for SQL users to generate valuable insights in dashboards, ad-hoc queries, or Python applications.

Delivering massively parallel, SQL analytics on petabytes of data

diagram: High speed SQL access to Aerospike real-time data

High speed SQL access to Aerospike real-time data

Aerospike SQL enables SQL developers to enjoy the performance and scalability benefits of the Aerospike Real-time Data Platform such as:

  • Massively parallel secondary indexes announced with Aerospike Database 6
  • High throughput batch operations (reads, writes, updates, deletes)
  • Hybrid memory architecture to exploit large memory systems, flash storage (SSD, PCIe, NVMe), and hybrid architectures for sub-millisecond data operations

Key Capabilities of Aerospike SQL

Run ANSI SQL

queries against Aerospike data to perform in-place, on-demand analytics on massive amounts of data.

Federated queries

across Aerospike clusters to create a single point of access across multiple Aerospike clusters.

Create dashboards

using data stored in Aerospike and familiar business intelligence (BI) tools, such as Tableau, Power BI, etc.

Run highly performant SQL

queries using Aerospike’s massive parallelism, predicate pushdown, secondary indexes (queries run roughly 80x faster).

Leverage Trino's cost-based optimizer (CBO)

via row count for query optimization. Aerospike connector is one of the two Presto connectors that support Presto CBO.

Secure your data

with TLS between clients all the way to Aerospike clusters, LDAP and PKI authentication of Presto users with ASDB, and support for server quotas to guarantee fair usage.

Best in class support

Operationalize your use cases quickly with best in-class support offered by Aerospike and Starburst.

Deploy anywhere

- either on-premises or in the cloud with Amazon Web Services and Google Cloud Platform.

Target Use Cases

Aerospike SQL Powered by Starburst enables numerous exciting use cases for data analysts, data engineers, data scientists, and audit/compliance teams.

Data Analysts

  • Run ad-hoc SQL queries on massive datasets in-place - e.g. “count # of users that clicked new banner ad”
  • Create insightful dashboards using BI tools such as Tableau, Power BI, Qlick

Data Engineers

  • Exploratory Data Analysis (EDA)
  • Develop/query complex data models programmatically using Python and Jupyter notebooks

Data Scientists

  • Data exploration and analysis to understand the distribution, anomaly, correlation, and other data characteristics before applying machine learning models.

Audit and Compliance

  • Using SQL queries to ensure compliance
  • Leverage the audit trail capability to understand who accessed sensitive data, when they accessed it, and what they accessed

Aerospike + Starburst: SQL Insights from Real-time Data

Aerospike SQL Powered by Starburst is a new product option for the Aerospike Real-time Data Platform that enables SQL users and developers to access data residing in Aerospike Databases.

The product is the result of an OEM and support agreement between Aerospike – the leading real-time data platform provider – and Starburst – the analytics anywhere company.

diagram: Aerospike + Starburst: SQL Insights from Real-time Data

The agreement means that customers will benefit from a single product – single point of installation, configuration, operation, and support – that offers the combined power of both platforms for fast analytics anywhere and real-time data processing.

How Aerospike SQL Powered by Starburst Works

Here is a look at how the solution works. Aerospike Connect for Presto-Trino is installed in Starburst worker nodes. The Aerospike Database is installed and licensed separately.

diagram: How Aerospike SQL Powered by Starburst Works

How Aerospike SQL Powered by Starburst Works

Additional Resources