Aerospike SQL Powered by Starburst provides a tightly integrated, distributed SQL analytics engine to Aerospike Database 6. 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.
High speed SQL access to Aerospike real-time data for analytics
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 SQL 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 SQL analytics 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 SQL analytics and 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 Analytics 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.
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 SQL 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.
How Aerospike SQL Powered by Starburst Works
