Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Architecture Insight of OceanBase: A Distributed SQL Database - CMU Database Seminar

CMU Database Group via YouTube

Overview

Explore the architecture and design of OceanBase, a distributed SQL database, in this comprehensive seminar talk by Charlie Yang. Delve into the system's ability to handle high-traffic scenarios, such as Alibaba's Double Eleven Day, and its use by over 500 customers in mission-critical systems. Examine OceanBase's design goals, TPC benchmark performance, and key architectural components including partitioning, Paxos-based replication, and distributed transactions. Learn about the database's approach to isolation levels, linearizability, and two-level compression. Investigate the challenges and solutions for Hybrid Transactional/Analytical Processing (HTAP), covering storage, resource isolation, query optimization, and execution. Analyze OceanBase's performance in TPC-C benchmarks, including configuration details, challenges faced, and results achieved. Gain insights into the storage engine and overall system architecture of this powerful distributed database solution.

Syllabus

Intro
Traffic Peak of Payment of Double Eleven Day
About OceanBase
OceanBase Alipay
Used by 500+ customers in Mission Critical Systems
Design Goals
TPC Benchmark
Architecture
Basic Concept
Partition
Paxos-based Replication
Distributed Transaction
Isolation Level
Linearizability
Two Level Compression
Online Schema Change
Introduction to HTAP
HTAP challenges for storage
HTAP challenges for resource isolation
HTAP challenges for optimizer
HTAP challenges for executor
Serial Execution
Parallel Execution
TPC-C benchmark
Benchmark Configuration
Challenges & Solution
Results-tpmC jitter
Results (D Test)
Storage Engine

Taught by

CMU Database Group

Reviews

Start your review of Architecture Insight of OceanBase: A Distributed SQL Database - CMU Database Seminar

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.