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.
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.
Stream loading, batch loading, and powerful ELT streamline data integration and make it faster, easier, and less expensive to load data continuously.
Interactive performance on CPU-intensive queries such as complex joins, full table scans, and geospatial analytics.
Leverage scheduling priorities, resource limits, and service-class settings to prioritize your most important queries across multiple users and during peak usage.
Standard ANSI SQL support enables users to onboard quickly and explore data flexibly.
Role-based user access control supports security and auditing with detailed logging reports.
The Ocient Hyperscale Data Warehouse supports basic and advanced SQL functionality so users can query large datasets flexibly, accurately, and fast.
- 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
- Predicate filtering, aggregation, grouping, ordering, limit
- Joins, count distinct, nested subqueries
- Like, string operations
- Common table expressions
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.
Learn how you can deploy Ocient and unlock new insights from your hyperscale datasets.