【TiDB 4.0 PCTA 学习笔记】- 1.1 A Brief History of Distributed Database@2班+陈俊聪

☄️ 学习与认证 经验&心得&笔记
1

课程名称： 课程版本（101）+ 1.1 A Brief History of Distributed Database（分布式数据库发展简史）

学习时长：5 min

课程收获： 分布式数据库的概念，发展历程以及代表产品

课程内容：

2000 年以前

  • Traditional Database
    • interact with SQL
    • single node / Shared everything
    • OLTP workloads

MySQL、PostgreSQL、SQL Server

Internet decades (2000s)

分布式中间件

  • Distributed middleware

ShardingSphere、Vitess

大数据，非 SQL 语言

  • The rise of Data Warehouses
    • Interact with programming language API

haddop

OLAP 数据库

SQL 、数据仓库、海量数据分析、分布式、列式数据库

  • The rise of Data Warehouses
    • Interact with SQL
    • Distributed / Shared nothing
    • Column-oriented
    • OLAP workloads

Greenplum、monetdb

NoSQL

  • NoSQL
    • Interact with key-value API
    • No transaction,No relation model,No schema
    • High performance
    • High Availability
    • Distributed / Shared nothing

mongoDB、HBASE、Cassandra

NewSQL (2010s)

  • NewSQL provides the scalability of NoSQL systems for OLTP workloads while not giving up ACID transactions
    • Interact with SQL
    • Distributed / Shared nothing

Cloud Spanner

HTAP (2010s)

  • HTAP
    • Execute OLTP queries like NewSQL
    • Execute OLAP queries like a data warehouse

TiDB

And TiDB tries to bring the best to you

  • An HTAP NewSQL database
    • Interact with SQL
    • OLTP & OLAP workloads
    • Distributed / Shared nothing
    • High performance
    • High Availability

学习过程中参考的其他资料