Product
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
Pricing

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
Solutions
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.

Explore
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
Company
Ocient Favicon
About Ocient

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

Learn More
Core Data Warehouse

A Time-Series Data Warehouse Designed for Hyperscale Performance

In 2016, we set out to design an affordable time series data warehouse to deliver unprecedented performance at scale. The Ocient Hyperscale Data Warehouse powers always-on, compute-intensive OLAP and real-time analytics workloads while reducing complexity and lowering costs.

Supercharge performance with the Ocient Hyperscale Data Warehouse
core data warehouse icon
Max Scale

Scale out loading, storage and analysis linearly for OLAP and real-time analytics workloads. Consolidate more data and workloads into a single data and analytics platform, decreasing data sprawl and reliance on third party tools.

stopwatch icon
Faster Loading

Stream loading, batch loading, and powerful ELT streamline data integration and make it faster, easier, and less expensive to load data continuously.

core data warehouse performance icon
Extreme I/O Performance

Interactive performance on CPU-intensive queries such as complex joins, full table scans, and geospatial analytics.

core data warehouse gears icon
Workload Management

Leverage scheduling priorities, resource limits, and service-class settings to prioritize your most important queries across multiple users and during peak usage.

core data warehouse icon
Standard SQL

Standard ANSI SQL support enables users to onboard quickly and explore data flexibly.

core data warehouse icon
Data Security

Role-based user access control supports security and auditing with detailed logging reports.

Unlock new insights with the full capabilities of ANSI SQL

The Ocient Hyperscale Data Warehouse supports basic and advanced SQL functionality so users can query large datasets flexibly, accurately, and fast.

Advanced
  • Geospatial capabilities for ST_POINT, ST_LINESTRING, ST_POLYGON
  • Complex types and related operator and functions (ARRAY, TUPLE, MATRIX)
  • Aggregate window functions: avg, count, max, min, sum
  • Ranking window functions: dense_rank, rank, row_number, percent_rank
  • Value window functions: lag, lead, first_value, last_value
Basic
  • Predicate filtering, aggregation, grouping, ordering, limit
  • Joins, count distinct, nested subqueries
  • Like, string operations
  • Union
  • Common table expressions
Connect your favorite BI tools via standard query interfaces

The Ocient Hyperscale Data Warehouse is built to support SQL access through standard JDBC, ODBC, and Python API 2.0 (PEP 249) drivers, so users can connect data from their database administration, business intelligence, and visualization tools directly into Ocient. With Ocient’s SQL standard compliant query interface, users can quickly and easily run SQL queries on all of their data. This saves teams valuable time by minimizing the learning curve for new users.

Ready to See the World’s Fastest Hyperscale Data Warehouse in Action?

Learn how you can deploy Ocient and unlock new insights from your hyperscale datasets.