Get Started with the Ocient Hyperscale Data Warehouse

It is designed to be flexible in its deployment options and cost-effective. Ocient does not require knowledge of unfamiliar programming languages that require additional time and cost to learn. With industry-standard interfaces like SQL, JDBC, and ODBC, Ocient makes it easy for organizations to interact with data in Ocient. Running on commodity hardware, Ocient can run on-premises in an organization’s data center, in the cloud, or as a fully managed service by Ocient. While flexible and cost-effective, Ocient is also designed to be extremely fast and scalable with timeseries datasets larger than 100 terabytes. Traditional relational databases, even those designed for analytics, don’t scale from a cost or performance perspective to petabyte and exabyte-sized datasets. Big data solutions can scale to large datasets but are often complex, inflexible, and require too much time to execute queries. Ocient is designed to give users the interactive analysis of traditional relational databases at the scale of big data solutions. This means that queries that used to take hours, or not run at all, now execute in seconds. Ocient achieves this performance through its distributed architecture where storage and compute are collocated. The collocation of storage and compute also allows Ocient to perform other valuable operations on the data stored in the data warehouse such as machine learning and geospatial analysis. By executing machine learning and geospatial analysis within the data warehouse, Ocient eliminates additional data movement and enables organizations to run machine learning and geospatial analysis at a scale that was previously impossible or impractical.

Key Concepts

Core Ocient concepts and terms needed for a quick start

Install an Ocient System

Installation, Upgrade, System Configuration, Maintenance, and Monitoring of an Ocient System

Luu5qEBBuTxrJd_NW6t4L_connectingdatabase

Connect to Ocient

Connection to Ocient with JDBC and other drivers

Database Administration

Overview of key database administration capabilities like workload management, result set caching, and managing users, groups, and roles

Load Data

Guides for loading data in various formats from Kafka® and S3 sources.

Query Ocient

Overview of Ocient data types and the components of a query

Use this reference information for querying and loading data.

SQL Reference

SQL command, function, operator, and keyword reference including DDL, DCL, and query reference

LAT Overview

Loading and transformation capabilities, managing pipelines, the LAT Client, and transformation functions

2IKrcbOBeZpFDGd59ptqe_sqlclientconnectors

Connection Driver Reference

Different SQL client connectors

For information about OcientML™ for the machine learning capabilities, see Machine Learning in Ocient. For information about OcientGeo™ for the geospatial functionality, see Geospatial Functions. For information about integrations and connections to third-party applications and tools, see Ocient Integrations. For a detailed explanation of the Compute Adjacent Storage Architecture™ in Ocient, design principles, storage capabilities, and query engine, see the Ocient Architecture.