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
Published May 6, 2022

At the Whiteboard with Ocient: SQL at Scale

Greg Dhuse, a Distinguished Engineer at Ocient, discusses the different types of containers in the Ocient Hyperscale Data Warehouse.

Containers are tools that simplify the process of integrating semi-structured data into a relational data warehouse.

While SQL is a highly versatile and expressive language, one common issue people encounter when transferring data from a NoSQL database to a SQL database is the growth of multiple tables, which can result in overly complex schemas and sluggish queries.