The theoretical basis of MySQL database learning----

One: Data storage development process

1. Human Management Phase

Mainly stored in paper tape, tape and other media, manual recording, inefficient.

2. File System phase

stored in the computer disk, as a file, data management becomes simple, but the data is not structured processing, not easy to query.

3. Database System phase

Stored on a computer's disk as a database, users can query data through a database management system.

II: Database Technology composition

1. Database system----DBS)

Not just a database, but a collection of databases, database management systems, application development tools, database administrators, and users.

A database is a place where data is stored, a database management system---DBMS) is software that defines, manages, maintains data, and application development systems are software that requires the use of a database.

2. SQL language (structured query Language----structured Queries language)

is a database query and programming language used to access data, query data, update data, and manage database systems.

Adopted by the American National Standards Institute and the International Organization for Standardization as a relational database language standard.

There are mainly DDL (define data tables, tables, views, index Triggers), DML (insert, query, UPDATE, delete data), DCL (Control user access rights) constitute.

3. Database access Technology

SQL statements embedded in a program only work if you use database access techniques. Different program languages are not the same way to access a database.

The ODBC----provides a common interface for accessing different relational databases. The driver CONNECTOR/ODBC must be installed to access the database by using ODBC.

JDBC----classes and interfaces written in the Java language, and Java can use JDBC to access the database and to install the driver connector/j.

The ADO----is a component provided by Microsoft, and C # can use ADO to access the database and need to install the driver connector/net.

PHP provides programmers with the MySQL function module, PHP can access the MySQL database through the MySQL function module.

Three: Common Database system

1. Oracle for Oracle

Oracle is the world's leading database software developer, the world's Most outstanding database, the world's first support SQL language database.

Mainly used in large-scale systems, the database is very complex, management is not convenient.

2. IBM's DB2

The main application and OS/2, Windows and other platforms.

Major applications and large-scale systems provide high-level data utilization, data integrity, security, and strong recoverability.

3. Microsoft Access and SQL Server

Access----is primarily used in small systems and is part of the Office system.

SQL Server----Microsoft-specific software that does not support UNIX and Linux, and is primarily used in large systems.

4. Open-source MySQL

Developed by the Swedish Mysqlab Company, which was acquired by Sun's $1 billion price in 2008, Oracle bought Sun for $7.4 billion in 2009, with many large domestic websites such as Sina and NetEase.

Four: Why use MySQL Database

1. mysql is a database of open source code

Anyone can get database code, and improve database bugs, open source, free.

2. The cross-platform nature of MySQL

Not only can you run on Windows, but you can also run on UNIX, Linux, MacOS and other operating systems.

3. Price Advantage

Anyone can download it on the MySQL website, and the community version of MySQL is free to use, even if you need to pay for the additional version, the price is also very cheap.

4. Powerful and easy to use

Multi-user, multi-threaded SQL database server. Fast, efficient, and secure processing of large amounts of data is relatively straightforward with oracle.

V: MySQL version and get

The main distinctions are Windows, UNIX, Linux, and Mac OS editions. Select the database version according to your system.

According to the development situation is divided into

Alpha----This version is in the development phase and may add new functionality or make significant changes;

Beta----This version is in beta, the development has been basically completed, but not thoroughly tested;

Gamma----This version is a beta version released over a period of time, more stable than the beta version;

Generally Available (GA)----This version is stable enough to be used in software development. Also known as version production.

Developers can download different versions of MySQL in http://dev.mysql.com/downloads/.

The theoretical basis of MySQL database learning----