title: DataBase Management System
date: 2023-11-03
status: DONE
tags:
  - Navigation
  - DataBase
author:
  - AllenYGY
created: 2024-01-16T21:03
updated: 2024-06-14T16:35
icon: TiBrandMysql
publish: True

DataBase Management System

数据库

- Database Design

- MySQL

- NoSQL

Relational Database Management System Design

RDBMS

数据存储在列和表中
通过数据表示关系
数据操纵语言
数据定义语言
从物理层抽象
应用指定需求而非实现方式
物理层可以更改
- 创建索引以支持查询
- 内存数据库

01-Entity-Relationship-Model-Modeling

02-Entity-Relationship-Model-Constraints

03-Entity-Relationship-Model-Extended-Features

04-Design-Issues

05-Logical-Design

06-Key-Concept

07-Relational-Database-Design-Purpose-&-First-Normal-Form

08-Relational-Database-Design-Functional-Dependency

09-Relational-Database-Design-BCNF

10-Relational-Database-Design-3rd-Normal-Form

SQL

01-Basic-MySQL

02-Cross-table-Query

03-Join

04-Aggregation

05-Data-Definition

06-Data-Modification

07-Null-Subquery

08-Set-Operation-&-Where-Subquery

09-Division-and-Correlated-Subquery

10-Advanced-SQL

NoSQL

图数据库

文档数据库

键值数据库

列族数据库