Ocient Favicon
The Ocient Hyperscale Data Warehouse

To deliver next-generation data analytics, Ocient completely reimagined data warehouse design to deliver real-time analysis of complex, hyperscale datasets.

Learn More
Pricing Icon

Ocient is uniquely designed for maximum performance and flexibility with always-on analytics, maximizing your hardware, cloud, or data warehouse as a service spend. You get predictable, lower costs (and absolutely zero headaches).

See How
Customer Solutions and Workload Services Icon
Customer Solutions and Workload Services

Ocient offers the only solutions development approach that enables customers to try a production-ready solution tailored to their business requirements before investing capital and resources.

Management Services Icon
Management Services

Tap into the deep experience of the Ocient Management Services team to set up, manage, and monitor your Ocient solution.

Learn More
Ocient Favicon
About Ocient

In 2016 our team of industry veterans began building a hyperscale data warehouse to tackle large, complex workloads.

Learn More
Semi-structured Data

Harness Complex Data Types with Ease

Ocient is engineered to natively load, transform, store, and analyze semi-structured data, so you can deliver critical insights across more data types faster than ever before.

Maximize Performance with Native Support for Complex Data Types
Support for Arrays

Including strong support for nulls within arrays, jagged arrays of arrays, and for_some and for_all operations

Support for Matrices

Including the ability to perform linear algebra natively in SQL for scientific math and machine learning

Support for Tuples

Including arrays of tuples, tuples of arrays, and tuples of tuples, nested to an arbitrary depth to handle deeply nested structures

Accelerate Time to Insight Across Complex Data Types

With constant streams of semi-structured data coming from a growing number of sensors, devices, and more, Ocient delivers important performance gains for semi-structured data analysis.

Leverage Secondary Indexes

Place secondary indexes on massive structured and semi-structured datasets and their corresponding nested structure to accelerate performance without impacting cost.

Reduce Maintenance

Add new data without complex index maintenance. With no global indexes, each segment contains its own index that resides alongside the data. You get the performance-boosting power of secondary indexes without any of the hassle.

Unleash the Full Power of SQL on Your Semi-Structured Data

Ocient goes beyond support of nest, unnest, and array_agg functions to provide deeper analysis with native functions and operations directly on arrays, tuples, and matrices, resulting in extremely high-performance SQL.

  • Convert nested, structured objects from source data into desired relational format
  • Select arbitrarily complex nested arrays, objects, and values
  • Gracefully handle missing values
  • Easily normalize or denormalize data via array and tuple manipulation, filtering, and pivoting
  • Apply transformations over arrays and structured objects to create derived fields during loading
At the whiteboard: SQL at Scale
Harness Semi-Structured Data at Scale

With the ability to execute on an advanced class of SQL queries faster than any competitor at hyperscale, Ocient puts you ahead of the curve and opens up new possibilities for relational analytics on everything from complex adtech datasets to financial services and IoT data.

Ready to Unlock the Value of Your Semi-Structured Data?

Learn how you can deploy Ocient and save on always-on analysis for complex data types.