MySQL Database learning a database overview

1.1 Development stage of database management technology

Human Management phase, file system phase, database system phase.

1.2 Concepts involved in the database system phase

Database DB: A collection of data that can be shared by a variety of users or applications by means of long-term storage on the computer, organized according to certain rules.

Database Management System,dbms refers to a large-scale software that operates and manages databases, which is used to establish, use and maintain databases, and to manage and control the database in order to ensure the security and integrity of the database. The user accesses the data in the database through the DBMS. Currently, the most popular and commonly used DBMS are Oracle, MySQL, SQL Server, DB2, and more.

Database System,dbs is a system that introduces a database into a computer system, which is usually composed of computer hardware, software, database management system and Data Administrator.

1.3 Stages of database technology experience

Hierarchical database and Mesh database technology phase, relational database technology phase, post-relational database technology stage.

Features provided by the 1.4 DBMS

Data definition Language (DDL), Data Manipulation language (DML), Data Control Language (DCL).

1.5 SQL

Structured Query Language (Structure query Language) is a widely used relational database standard language.

Advantages: Universal, easy to learn, highly non-procedural.

1.6 Common Database management system

1.Oracle

The industry is now a more successful relational database management system, Oracle launched in 1983, running a stable, full-featured, superior performance of noble products, technology ahead, focusing on large-scale enterprise database domain applications.

2.db2

Support Multimedia, Web relational database management system, not only can meet the needs of large and medium-sized enterprises or units, but also flexible to serve small and medium-sized e-commerce solutions.

3.SQL Server

Microsoft launches features that are comprehensive, efficient, user-friendly, easy to learn, easy to use, and unique in their usability and interactivity.

4.PostgreSQL

The most powerful free software database management system. Supporting the most abundant data types in the world, it is the only free software that supports things, sub-queries, multi-version parallel control systems and data integrity checking in free software database management system.

MySQL Database learning a database overview