Addition of SQL JOIN operations to the world’s fastest real-time data platform delivers cost-effective self-service analytics to day-to-day decision-makers
BURLINGAME, Calif. April 16, 2020–(BUSINESS WIRE)–Imply, the real-time intelligence company, today announced Imply 3.3, featuring enhancements that help customers optimize their analytics spend and improve time to insight on their freshest data, while extending Imply’s leading real-time analytics performance to a broader set of queries. An Imply 3.3 download or cloud trial is available on the Imply website.
Enterprise leaders in a range of industries use Imply to deliver self-service real-time analytics to their business users, make business intelligence interactive and exploratory, and create data-driven applications for their customers. They’ve wanted the ability to query multiple data sets directly using standard SQL operations while not sacrificing performance, and now they can.
Imply 3.3 takes advantage of new SQL JOIN support in Apache Druid 0.18. The addition of JOIN operations broadens Druid’s performance advantage over data warehouses and data lake query engines by leveraging Druid’s architectural advantages such as advanced indexing and horizontal query distribution. Druid’s innate query speed advantage over data lake query engines was demonstrated last year by researchers at the University of Minho (Portugal). Druid displayed a 10X to 59X advantage over Presto and was 110X to 190X faster than Apache Hive.
Support for JOIN operations reduces cloud data storage volumes and compute costs, and enables broad adoption of self-service analytics. Previously, multiple data sets would have to be “flattened” into a single table which included redundant data and made updates expensive. Now multiple data sets can be used “as is,” simplifying data pipelines and creating substantial savings by reducing storage costs, data ingestion costs and maintenance costs.
For one Imply customer, a Global 2000 retailer who uses Imply to optimize procurement and product mix in real-time, JOIN support will reduce storage requirements by half. It will also greatly reduce their compute costs, as updates will require a fraction of the processing previously required.
“Digital transformation has spawned huge amounts of continuously flowing data. Our customers’ challenge is to bring that data to bear on day-to-day decisions, cost-effectively,” said Fangjin Yang, chief executive officer and co-founder of Imply, “Our latest release greatly improves the cloud computing economics of real-time intelligence, while maintaining best-in-class performance, so that companies can extend analytics beyond the analyst, to business users, while maintaining fiscal responsibility.”
In this release, Imply also added query laning to improve resource utilization and reduce costs. Query laning works like an HOV lane. It provides prioritized access to a subset of resources for urgent queries. Query laning ensures that interactive time-sensitive queries are never blocked by longer-running reporting queries.
Examples where these enhancements lower total cost of ownership (TCO) include:
- Lower storage costs: denormalizing tables with hundreds or thousands of dimensions can create high storage and compute costs.
- Lower data loading costs: datasets whose dimensions change frequently no longer have to be completely re-ingested with each change.
- Lower data engineering costs: existing queries from BI tools such as Tableau or Looker can be used “as is”, without rewriting JOIN queries.
- Lower compute costs: query laning makes more efficient use of computing resources by consolidating mixed workloads onto the same cluster.
About Imply
Imply, founded by the original creators of Apache Druid®, develops an innovative database purpose-built for modern analytics applications. Imply is driving a new era in data analytics, called Analytics in Motion, where interactive queries, real-time and historical data at unlimited scale, combine with the best price/performance, to realize the full potential of data.
Imply has operations in North America, Europe and Asia Pacific and is backed by Andreessen Horowitz (a16z), Bessemer Venture Partners, Tiger Global Management, Khosla Ventures and Geodesic Capital. For more information please visit imply.io.
Contact
Jeff Tieszen
Touchdown PRM
imply@touchdownpr.com
(512) 394-8568
