Introduction to Databases

Database brief:

A Web site needs a database to store data, and a school needs to use a database to store information about students and teachers.

A company needs to use a database to store employee information and company information, how the database is stored for several years

Three stages of data storage:

1. Artificial management stage: This stage is mainly stored on paper, the way of bookkeeping

2. File system phase: primarily stored on disk

3. Database system phase: Use of a dedicated database

Database Development (DBD): is a database management system (DBMS) and database application software design and development of related staff, he belongs to the Software Development engineer, but also a part of the operation of the work of the content. He is mainly engaged in software research and development, but also to participate in the database production environment problem optimization and resolution.

Database administrator (DBA): A general designation of the staff involved in managing and maintaining a database management system (DBMS), a branch of the operations engineer, responsible for the entire lifecycle management of the business database from design, testing to deployment delivery.

The role of databases in development: in software development, it is often necessary to use a database to store data. For example, a school's student management system requires a database to store information about the status of the data, exam information, teacher information, and course information.

SQL: Structured queries language (structured query Language) short SQL

Role: Structured Query language is a database query programming language for accessing data and querying, updating, and

Manage relational database systems.

The SQL language is divided into three parts: database definition language (DDL), Database manipulation language (DML), and Database Control Language (DCL)

Common databases:

1 Oracle

2.IBM of DB2

3. Microsoft Access and SQL Server

4. Open-Source PostgreSQL

5. Open-source MySQL

6. File Database SQLite

7. In-Memory database hql

The world's top ten Web sites:

1.Google 2.Facebook 3.Youtube 4.Yahoo 5.Live

6.Baidu 7.Wikipedia 8.Blogger 9.MSN 10.Tencent

Non-relational database:

1. Key-Value Storage database (Key-value), typical products: Memcached, Redis

2. Columnstore (column-oriented) database, typical products: Cassandra, Hbase

3. Document-oriented database, typical products: MongoDB, CouchDB

4. Image-oriented database

Installation method:

1.RPM-IVH mysql.rpm

2. binary file Installation

3. source File Installation

Download source installation package Address: https://dev.mysql.com/downloads/mysql/

　　

　　

Introduction to Databases