SQL Server Master----Data basics from Getting Started

Getting Started with databases :

　　　The development of database: The stage of-----file Management Stage-----Database system in the stage of human management

The composition of the Data system:

1. Database (data) DB

2. Data management system (software) DBMS

3. DBA for Database administrators

4. Hardware platform

5. Software platform

3-level mode of the database

Mode in out-of-pattern mode

The simple point of view is that the pattern is the out-of-table mode, which is the physical structure and storage mode.

Level 2 mapping between level 3 modes

Mode/External mode mapping (logical Independence)

External mode/Internal mode mapping (physical independence)

Data model

Hierarchical model Mesh Model relationship model (access,sql,oracle)

　　　　　　　　　　The relational model is a two-dimensional table to describe the data

The composition of the database

1) from the file point of view

Data files. mdf log files. ldf

2)

System Database

Master: Record all system-level information (elements, endpoints, system configuration, etc.)

Temp: Staging database for saving temporary objects or intermediate result sets

Model: A template for creating all the data,

MSDB: For agent scheduled alarms and jobs

Naming rules for instances

The computer name/instance name cannot exceed 16 characters

The data model is usually made up of three parts

Data structure, data manipulation, and entity integrity constraints

　　　　　　　　　　

　　

　　　　

　　　　

SQL Server Master----Data basics from Getting Started