NoSQL player Aerospike links up with Starburst for SQL-based access to edge data

'We’re not necessarily replacing Snowflake' is an interesting choice of words

Aerospike, the value-key NoSQL database, has launched a collaboration with data connection vendor Starburst to offer SQL access to its datastores.

Dubbed Aerospike SQL Powered by Starburst, the system hopes to offer data analysts and data scientists a single point of access to federated data in Aerospike using existing SQL analytic tools such as Tableau, Qlik, and Power BI. It is the first time Aerospike has offered an off-the-shelf tool to analyze its database using SQL, the ubiquitous database language.

Aerospike was purpose-built with a highly parallelized architecture to support real-time, data-driven applications that cost-effectively scale up and out. It claims to offer predictable sub-millisecond performance up to petabyte-scale with five-nines uptime with globally distributed, strongly consistent data.

It is commonly employed as a persistent cache and a user store to support data collection, distribution and analysis requirements for online business problems like adtech, e-commerce, online bidding, online gaming and online gambling. Customer include PayPal, Airtel, Adobe, Sony (Playstation), and Nokia.

Starburst is based on open-source Presto, a SQL query engine written in Java. Its distributed architecture was originally developed at Facebook back in 2013 to query data residing in Hadoop.

'We’re not necessarily replacing Snowflake or whatever'

Lenley Hensarling, Aerospike chief product officer, told The Register the point of the product was to give analysts a view on data it stores to help decide how to manage or analyze the real-time information.

“The visibility into what's there at the edge and into these real time transactional scores, is what we're enabling. There's a huge polyglot landscape of data and having a map to it, if you will, the ability to browse through it is what we're providing,” he said.

While developers might want to build tools to analyze the edge data held in Aerospike, it was more like they would be making decisions about where else they might move and analyze the data. “We’re not necessarily replacing Snowflake or whatever,” Hensarling said.

In a pre-canned quote, Holger Mueller, vice president and principal analyst of Constellation Research, said the tool offered the ability to open up more data for multiple enterprise audiences. “Innovators like Aerospike and Starburst are effectively democratizing data for enterprise SQL developers, data architects and BI analysts to achieve fast, efficient SQL queries at an unlimited scale,” he said.

Open-source Aerospike is available on Apache License Version 2.0 and Affero General Public License. The eponymous company also offers a paid-for enterprise edition.

Starburst is gaining traction as a way to join up disparate sources of enterprise data. For example, in late 2020, enterprise data warehouse stalwart Teradata announced an update to its QueryGrid.

Starburst Data is designed to integrate a Presto connector so that users of Teradata's Vantage analytics platform can access and query a range of cloud and on-premises data sources, including MongoDB, Databricks Delta Lake, columnar database Apache Cassandra, as well as cloud data warehouses Amazon Redshift and Google BigQuery.

In April, Aerospike added support for JSON documents to a slew of new features included in its Database 6 release. ®

Narrower topics

Other stories you might like

  • Intel is running rings around AMD and Arm at the edge
    What will it take to loosen the x86 giant's edge stranglehold?

    Analysis Supermicro launched a wave of edge appliances using Intel's newly refreshed Xeon-D processors last week. The launch itself was nothing to write home about, but a thought occurred: with all the hype surrounding the outer reaches of computing that we call the edge, you'd think there would be more competition from chipmakers in this arena.

    So where are all the AMD and Arm-based edge appliances?

    A glance through the catalogs of the major OEMs – Dell, HPE, Lenovo, Inspur, Supermicro – returned plenty of results for AMD servers, but few, if any, validated for edge deployments. In fact, Supermicro was the only one of the five vendors that even offered an AMD-based edge appliance – which used an ageing Epyc processor. Hardly a great showing from AMD. Meanwhile, just one appliance from Inspur used an Arm-based chip from Nvidia.

    Continue reading
  • Cloudflare's outage was human error. There's a way to make tech divinely forgive
    Don't push me 'cos I'm close to the edge. And the edge is safer if you can take a step back

    Opinion Edge is terribly trendy. Move cloudy workloads as close to the user as possible, the thinking goes, and latency goes down, as do core network and data center pressures. It's true  – until the routing sleight-of-hand breaks that diverts user requests from the site they think they're getting to the copies in the edge server. 

    If that happens, everything goes dark – as it did last week at Cloudflare, edge lords of large chunks of web content. It deployed a Border Gateway Protocol policy update, which promptly took against a new fancy-pants matrix routing system designed to improve reliability. Yeah. They know. 

    It took some time to fix, too, because in the words of those in the know, engineers "walked over each other's changes" as fresh frantic patches overwrote slightly staler frantic patches, taking out the good they'd done. You'd have thought Cloudflare of all people would be able to handle concepts of dirty data and cache consistency, but hey. They know that too. 

    Continue reading
  • AWS sent edgy appliance to the ISS and it worked – just like all the other computers up there
    Congrats, AWS, you’ve boldly gone where the Raspberry Pi has already been

    Amazon Web Services has proudly revealed that the first completely private expedition to the International Space Station carried one of its Snowcone storage appliances, and that the device worked as advertised.

    The Snowcone is a rugged shoebox-sized unit packed full of disk drives – specifically 14 terabytes of solid-state disk – a pair of VCPUs and 4GB of RAM. The latter two components mean the Snowcone can run either EC2 instances or apps written with AWS’s Greengrass IoT product. In either case, the idea is that you take a Snowcone into out-of-the-way places where connectivity is limited, collect data in situ and do some pre-processing on location. Once you return to a location where bandwidth is plentiful, it's assumed you'll upload the contents of a Snowcone into AWS and do real work on it there.

    Continue reading

Biting the hand that feeds IT © 1998–2022