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

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.