当前位置：网站首页>Database overview
Database overview
2022-07-19 09:48:00 【Program three two lines】
1、 Why use database
Persistent and structured to save data
2、 Database and database management system
DB: Warehouse for storing data It's essentially a file system （mysql Installation directory data Directory ）
DBMS: Software for operating and managing databases , common DBMS:MYSQL Sql server Oracle mongdb, Database ranking website DB-Engines Ranking - popularity ranking of database management systems
SQL: Language specially used to communicate with database
3、 Database classification
sql Relational database （ Binary relationships store data ）
mysql 、orcale 、sql server
sql It is the query language of relational database
nosql This is a non relational database
Key database ：redis
Document database ：mongodb 、couchdb
Search engine ：es 、solr、splunk
Column store ： Compared to a row database mysql、oracle、sql server, Columnar database HBase Greatly reduced io
Graphic database :neo4j、infogrid
4、ER Relationship between model tables
one-on-one
One to many
Many to many
Self quoting
边栏推荐
猜你喜欢
![[Network Research Institute] the threat of machine learning system is time to take it seriously](/img/9b/dd75a7b86743569711819bb97840b1.png)
[Network Research Institute] the threat of machine learning system is time to take it seriously
中国十大国民小吃，第一居然是它
第一部分—C语言基础篇_3. 运算符与表达式
The inflection point of eth may be just around the corner, which is how to
Have you learned the database design pattern of multi tenant SaaS?
Part I - Fundamentals of C language_ 2. Data type
第十二章 STL 之 list
第一部分—C语言基础篇_6. 函数
![[C language] storage of shaping data](/img/50/5454826da9a671fff0138388d23469.png)
[C language] storage of shaping data
DuiLib 实现tooltip自定义鼠标提示窗口
随机推荐
OLED displays how to understand the character sizes of 12*6, 16*8, 24*12, etc
Mux256to1v,Hadd，Fadd
Part I - Fundamentals of C language_ 6. Function
EBay searches eBay products by keyword API return value description
On the problem of dependency invalidation when the dependency in the basic module is inherited by the sub module in the microservice
Vector容器的系列操作( 详解 )
Chapter 4 - first order multi-agent system consistency - > continuous time system consistency with time delay [program code]
The study found that DNA nano device injection can be safely used for medical purposes
Chapter XI queue of STL
R语言ggplot2可视化分面图（faceting）：ggplot2可视化分面图并移除分面图之间的边框线、以及分面图之间的间隙（Remove Spacing between Panels）
Mux256to1v,Hadd，Fadd
pip和pip3的区别用法详解
rhcsa 第二天 7.15
第一部分—C语言基础篇_2. 数据类型
Add - before the command in makefile to ignore the error caused by the command and continue to execute the next command
MySQL--SQL优化案例--隐式字符编码转换
Fundamentals of C language -- 2-1 pointer and wild pointer
Could NOT find CUDA (missing: CUDA_INCLUDE_DIRS) (found suitable exact version “11.4“)
第4章-一阶多智体系统一致性 -＞ 切换拓扑系统一致性
[C language] summary of array knowledge points