Version 22 provides customers enhanced capabilities built to eliminate disparate data integration and transformation tools and enable data and analytics consolidation at scale

Ocient, the leading hyperscale data analytics solutions company, announced the version 22 release of its flagship product, the Ocient Hyperscale Data Warehouse (OHDW). This latest release builds upon Ocient’s hyperscale data integration and data movement capabilities while adding new real-time analytics features, query performance enhancements, and support for additional business intelligence (BI) tools. Ocient’s ability to continuously stream, load, and transform large scale datasets and execute machine learning directly within the database enables customers to execute complex, continuous data integration, transformation, and exploration alongside real-time analytics and OLAP-style workloads from a single solution stack.

Marketing Technology News: Martech Interview With Mike Nash, President, KS&R

“With version 22, Ocient is enabling customers with the capabilities they need to increase price performance, consolidate multiple resource-intensive tools into a single solution, and unlock new opportunities for product development and real-time decision intelligence to help grow their business.”

Native support for ETL and ELT workloads – Version 22 of the OHDW delivers improved performance for loading, streaming, and extract, load, transform (ELT) workloads. Organizations challenged with continuous data movement and transformation at scale can streamline complicated loading processes for complex data types and eliminate the need for standalone tools like Spark and Informatica that add latency and overhead to hyperscale workloads. Once data is transformed into a relational format and loaded or streamed, Ocient’s ELT capabilities support massive joins, groupings, and aggregations that enable customers to optimize query performance, activate transformed datasets, and prepare variations of source data for data science and operational data stores without needing to move or copy data.

New real-time analytics features – Version 22 marks the general availability of Hyperloglog (HLL) sketches for Ocient’s suite of real-time analytics capabilities so customers can create rollups of data using approximations on aggregated metrics and accelerate query processing without sacrificing performance. Ocient’s ability to execute compute-intensive log-level aggregation, high concurrency queries, and always-on data streaming for real-time analytics alongside complex, compute-intensive OLAP-style workloads enables customers to streamline operations and consolidate a variety of mixed analytical workloads onto a single platform.

Query performance enhancements – To enable customers to enrich data at scale while lowering latency and reducing costs, Ocient version 22 delivers query performance enhancements via I/O pushdown and join optimizations on hyperscale tables with hundreds of billions of rows. When combined with Ocient’s support for semi-structured and multidimensional data types, these enhancements enable Ocient to accelerate query plans on highly complex data sets while tightly controlling costs.

Marketing Technology News: 6 Ways to Elevate E-Commerce Content and Experience Management to Optimize Your Digital Presence

Support for integrations with Metabase and Superset – Ocient version 22 offers new integrations with Metabase and Superset for easy data visualization and integration into existing customer environments. Both integrations leverage Ocient’s geospatial analytics and in-database machine learning (ML) so customers can quickly visualize and act on ML model results without the need for additional ELT processes or requirements.

“In today’s economic environment, enterprises looking to scale their data and analytics requirements must pursue innovation while bringing greater efficiencies and cost savings to their business,” said Chris Gladwin, CEO at Ocient. “With version 22, Ocient is enabling customers with the capabilities they need to increase price performance, consolidate multiple resource-intensive tools into a single solution, and unlock new opportunities for product development and real-time decision intelligence to help grow their business.”

From piloting new solutions to full production deployments, Ocient helps customers simplify complex data pipelines while facilitating the time-intensive task of engineering new end-to-end solutions with comprehensive migration support and services. When consolidating multiple databases and tools into a single solution, Ocient’s Customer Solutions team ensures customers move from pilot to production in weeks to months, with ROI delivered in a year or less. Ocient provides flexibility to deploy on premises and on cloud with Google or AWS, or as a fully managed solution in OcientCloud.