Shulou(Shulou.com)06/01 Report--

This article is mainly about the basic knowledge of MySQL database, if you are interested, let's take a look at this article. I believe it is of some reference value to you after reading the basic knowledge of MySQL database.

I. the mode of data storage

Manual management stage: manually write information to oracle bones, bamboo slips, cloth, paper and other materials for archival management.

File system phase: people save information in the form of text, word documents, etc. on the disk of the computer.

Database system management phase: people write information to the DBMS database management system.

II. Definition of database

An efficient solution for managing large amounts of information. A library that organizes, stores, and manages data according to the data structure.

3. Database system DBS

SQL (RDBS Relational Database system) A database system based on a relational model, such as ORACLE, Oracle MySQL, MariaDB, Percona server, DB2, SQL Server (Microsoft).

NoSQL (non-relational database system) for example: Redis, MongoDB, Memcache...

DBA (database administrator)

IV. The concept of relational database

Database database: a warehouse of data.

Table table: data stored in a table and stored in a table should have the same data format.

Rows and columns: rows are used to record data and columns are used to specify the data format.

Record: data in the line.

Field: a column of data.

SQL: data management system, language used to manage data, structured query language.

5. SQL language

DDL statements (database definition language): databases, tables, views, indexes, stored procedures, functions, such as create, drop, alter

DML statement (database manipulation language): insert data insert, delete data delete, update data update

DQL statement (database query language): query data select

DCL statements (database control language): for example, control user's access rights grant, revoke

VI. System database

Information_schema: virtual library, which mainly stores the information of some database objects in the system, such as user table information, column information, permission information, character information, etc.

Performance_schema: mainly stores the performance parameters of database CVM

Mysql: authorization library, which mainly stores the permission information of system users.

Sys: mainly stores the performance parameters of database CVM

VII. Data access technology

Refers to the interface technology that uses other software to access the database system. [for example, ODBC (open database connection driver interface) is needed to access the database in the languages of PHP, ASP and. Net development platform, while JDBC (java database connection driver interface) is used to access the database with jsp]

8. Why use MySQL?

MySQL, developed by Sweden's MySQL AB, is currently a relational database product of Oracle (MySQL AB was acquired by Sun in 2008 and Sun was acquired by Oracle in 2009) and is open source and free. The most popular open source database system in the world is powerful enough to handle web applications.

9. MySQL architecture: Cramp S

CVM side: stores and manages the database.

Client: a program that makes a request for an operation.

10. MySQL characteristics

1. Written in C and C++, and tested with a variety of compilers to ensure the portability of the source code

two。 Support AIX, FreeBSD, HP-UX, Linux, MacOS, Novell Netware, OpenBSD, OS/2 Wrap, Solaris, Windows and other operating systems

3. Provides API for a variety of programming languages. These programming languages include C, C++, Python, Java, Perl, PHP, Eiffel, Ruby and Tcl.

4. Support for multithreading and make full use of CPU resources

5. Optimized SQL query algorithm to effectively improve the query speed

6. Not only can it be used as a separate application in the client cloud server network environment, but also can be embedded in other software as a library to provide multilingual support. Common codes such as Chinese GB 2312, BIG5, Japanese Shift_JIS can be used as data table names and data column names.

7. Provide multiple database connections such as TCP/IP, ODBC and JDBC

8. Provides management tools for managing, checking, and optimizing database operations

9. Can handle large databases with tens of millions of records

The details of the above basic knowledge about MySQL database are helpful to all of you. If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.