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

The necessity of using databases

1. Structured storage of a large number of data information, convenient for users to effectively retrieve and access.

two。 Maintain data consistency, integrity and reduce data redundancy.

3. Meet the requirements of sharing and complete aspects of the application.

The basic concept of database

1. data

The symbolic record that describes things is called Data.

Including numbers, words, images, sounds, etc.

two。 Database and database tables

Different records are organized together to form a 'table'

A database is a collection of tables.

3. Database system and database management system

Database system (DBS)

Database management system (DBMS)

Database administrator (DBA)

History of database development

First generation database: (database based on hierarchical model and mesh model)

Second generation database: (relational database)

The third generation database: (new database for different fields, object-oriented database, 'relational-object' database)

Database model

It is the core and foundation of database system.

~ represent the structure of the data

~ define database operations and constraints

Contains data structures, data operations and data constraints

Classical data models include 'mesh model', 'hierarchical model' and 'relational model'.

Introduction to mainstream databases

1.SQL server (Microsoft products)

Oriented to windows operating system

Simple and easy to use

2.oracle (Oracle products)

For all mainstream platforms

Safe, perfect and complex to operate

3.DB2 (factory products of IBM)

For all mainstream platforms

Large, complete, perfect

4.MySQL (acquired by Oracle)

Open source, small, fast and stable

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.