ClickHouse: Data Warehousing with Robert Hodges

Columnar databases store and retrieve columns of data rather than rows of data. Each block of data in a columnar database stores up to 3 times as many records as row-based storage. This means you can read data with a third of the power needed in row-based data, among other advantages.

The company Altinity is the leading enterprise provider for ClickHouse – an open-source column-store analytic database, now a fully managed service developed and operated with Altinity.Cloud. Altinity only bills for the compute, storage, and support that is used. They provide enterprise support for analytic applications like tuning queries, Kafka support, and ClickHouse bugs, and their ClickHouse clusters run with out-of-the-box security and privacy.

In this episode we talk with Robert Hodges, CEO at Altinity. Before becoming CEO at Altinity, Robert worked as a Senior Staff Engineer at VMWare and was the CEO of Continuent before that. We discuss databases and data warehousing, ClickHouse, and how Altinity helps customers create enterprise analytic applications.

Sponsorship inquiries: sponsor@softwareengineeringdaily.com

Transcript

Transcript provided by We Edit Podcasts. Software Engineering Daily listeners can go to weeditpodcasts.com to get 15% off the first three months of audio editing and transcription services with code: SED. Thanks to We Edit Podcasts for partnering with SE Daily. Please click here to view this show’s transcript.


Sponsors

Aurora is an Ethereum Layer-2 built on top of NEAR Protocol. Aurora delivers 1000x lower transaction fees compared to Ethereum and sub-two-second transaction finalization. Aurora is fully interoperable with Ethereum, with ETH used as a base token and all existing Ethereum tools usable out of the box. Aurora includes the trustless Rainbow bridge, allowing for bidirectional transfers of any information from Ethereum, including ERC-20s. To learn more about Aurora, please visit softwareengineeringdaily.com/aurora

Yotascale is a leading cloud cost management solution designed uniquely for engineers to make smart cloud cost decisions with smarter attributions and smarter analysis. Get a complete view of your cloud infrastructure spend including containers and Kubernetes. Get 95% cost attribution accuracy, actionable recommendations and continuous cost anomaly detection. You’ll also get team-based alerts. Request a demo and find out how Yotascale can empower your engineering teams today! Visit www.yotascale.com/demo

Oracle wants to help you land those big customers, so they’re offering preferred pricing on enterprise cloud for startups. Free cloud credits and 70% off their cloud services, and with multi-cloud support and no vendor lock-in, you can build it out any way you want. Oracle for Startups doesn’t want you wheezing on the side of the road. They want you to have enough power to scale and land your dream customer. Visit oracle.com/go/sedaily.

Today’s podcast is brought to you by Google Cloud and DORA research team. The team recently launched a survey to collect insights for the 2021 State of DevOps report and would love your input! The State of DevOps report is the largest and longest running research of its kind, providing insight into how we can improve software delivery performance with DevOps. By completing the survey, you get to shape the conversation on DevOps along with over 30 thousand software professionals who took the survey over the past six years. So what are you waiting for? Take the survey at cloud.google.com/devops!

Software Weekly

Software Weekly

Subscribe to Software Weekly, a curated weekly newsletter featuring the best and newest from the software engineering community.