Shulou(Shulou.com)05/31 Report--

This article shows you what the basic knowledge of the database is, the content is concise and easy to understand, it can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

The storage mode of the database

Manual management stage

File system Pha

Database system management phase

Big data big data (1p distributed Storage)

Technical composition of database

Database system: DBS

a. Database management system (DataBase Management System,DBMS)

Relational database-SQL (RDS): ORACLE,Oracle MySQl,MariaDN,Percona server,DB2

Non-relational database-Nosql:Redis,MongoDB,Memcache

B. DBA-- database administrator

SQL language (structured query statement)

A. DDL statement database definition language: database, table, view, index, stored procedure, function, CREATE DROP ALTER

B. DML statement database manipulation language: insert data INSERT, delete data DELETE, update data UPDATE

C. DQL statement database query language: query data SELECT

D. DCL statement database control language: for example, control user's access rights GRANT, REVOKE

Database access Technology Database Interface-- the Technology of connecting Database with programming language

A. ODBC PHP

B. JDBC JAVA

The above content is what is the basic knowledge of the database, have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.