Mysql database Introduction

Mysql database Introduction
MySQL

Database:

Oracle, DB2, SQL Server, MySQL, access, mangodb, bigtable

 

Relational Database Service

Large

Oracle and DB2

Medium and small

SQL Server, MySQL

Small

Access

Non-relational databases

Mangodb, bigtable

 

What is a relational database?

A relational database is a database that uses a "relational model" to organize data.

What is non-relational database?

Databases that do not use "Relational Models" to organize data are non-relational databases.

 

LINK model

A relational model is a two-dimensional table model. A relational database uses multiple two-dimensional tables to organize data.

Link:

A relational table is a two-dimensional table. each two-dimensional table is in a database, that is, a data table.

Tuples: it can be understood as a row in the orders table, corresponding to the records in the data table in the database.

Attribute: it can be understood as a column in the tables Table, corresponding to the fields in the data table in the database.

Field: The value range of the attribute, that is, the value restriction (field type) of fields in the data table in the database ).

Keyword: is a set of attributes that uniquely identify a single tuples, corresponding to the primary key field in the database data table.

 

Several concepts in the database:

Data: storage objects of databases

Database: a set of databases used in computers for long-term data storage, sharing, and unified management.

Data table: table

Record

Field: field (column)

DBMS (DataBase Management System): a DataBase Management System is a large software used to manage databases. It is mainly used to create, delete, and maintain databases.

 

MySQL object structure