Blog

Aerospike SQL powered by starburst for better time to insight

headshot-Lenley-Hensarling-201904c-720x720-150x150
Lenley Hensarling
Chief Product Officer
June 15, 2022|4 min read

Today Aerospike announced Aerospike SQL Powered by Starburst. This new solution dramatically reduces the time for business insight and real-time decisions. Customers can now run massively parallel, complex SQL queries on the gigabyte-to-petabyte-scale data stored in the Aerospike Database. The solution adds to the value of the data stored in Aerospike while opening the platform to a wider set of analytics use cases for data engineers and SQL developers.

This is a complete solution for SQL access and the myriad of tools that work with SQL to allow a broader group of users to access data in Aerospike. Partners can also resell this OEM solution to enhance revenue streams.

As the amount of data held in Aerospike has grown, there are increasing requests by our user community to do more with the data in place. But it goes beyond that. Our customers have many Aerospike clusters deployed and other data stores of various types distributed across their data architectures. And, it does not end there – they have a vast set of databases under different technologies that compose the whole of their data.

Agility + data

Over the last decade, two important trends have been working their way through the information technology landscape. The first is the trend towards more agile application models – namely micro services architectures. This leads to deconstructing the application in its parts, allowing for each component to evolve independently, which decomposes the overall view of the underlying data. It also decomposes the overall view of the data.

The second trend has been the growing awareness of the value of applying data to enhance business processes and decision-making. The requirement here is that all data is available wherever it can be used.

For decades the mantra was for enterprises to get to a single data model, a single database, and a single holistic data warehouse. Not necessarily a bad idea, but one that proved to be an impossible goal and that carried several less than desirable side effects.

Now we are faced with the task of making all the data available anywhere and to be able to compose it into different data models or views as required for new applications, analytics, or AI/ML solutions. It’s important to note Aerospike SQL solution allows for Federated data to be accessed from a single point.

Data mesh + SQL

The solution to view data as a whole is often called a data mesh. A key technology that has arisen to enable this was developed at Facebook and its open-sourced products such as Presto and later Trino. Starburst has led in the commercialization of the technology and championed the approach of dealing with this disaggregated data landscape as a data mesh.

Aerospike sees value for our customers from this approach in two ways. One is to use Starburst to enable SQL access to data in our database and open the myriad of tools for reporting, analysis, and visualization of the information there. The other is to bring Aerospike data into the overall data mesh realized by the Starburst model.

One aspect of this is that we can now present data from any number of Aerospike clusters as a combined data set, allowing exploration of how different data sets relate to each other. Being a part of the overall data mesh allows Aerospike to be viewed in relation to other data sets in relational and other non-relational data stores as well.

diagram-Aerospike-and-Starburst-1600w-1024x419

Aerospike + Starburst

Today we are delivering a new capability powered by the Starburst SQL engine. Aerospike offers a product composed of our Aerospike Connector for Presto/Trino and Starburst. This allows Aerospike to provide a complete SQL solution. Aerospike will provide first-level support for the overall solution and will provide complete support for its connector to Starburst.

This partnership provides customers with value when deploying Aerospike SQL but also provides value to our joint customers when they are deploying Starburst across multiple data sources. More data, and more information created, means more value for our customers.

Learn more: