Getting to know database structure database series from the sqlserver Interface

Source: Internet
Author: User
For more information about database structure learning, see the sqlserver interface! The user-friendly interface helps beginners get started with databases more easily. A database consists of a system database, a database snapshot, A reportserver, A reportservertempDB database, and a custom database (employee, mysql, and students ). I divide it into four parts: System Data

For more information about database structure learning, see the SQL server interface! The user-friendly interface helps beginners get started with databases more easily. A database consists of System databases, database snapshots, reportserver, reportserver tempDB, and custom databases (such as employee, mysql, and students ). I divide it into four parts: System Data

Database Structure

To learn about the database, first look at the SQL server interface! The user-friendly interface helps beginners get started with databases more easily.

A database consists of System databases, database snapshots, reportserver, reportserver tempDB, and custom databases (such as employee, mysql, and students ).

I divided it into four parts: System database, database snapshot, ssrs, and custom database

I. System Database


Master Database: records all system information, including logon, system settings, initial information, and other system databases and user information.

Model Database: Template database of all databases. You can modify it as needed. Always exist in SQL.

Msdb Database: proxy service database.

Tempdb Database: temporary database and temporary storage space. There is only one data record, which can be adjusted by yourself. When SQL server is disabled, data is lost.

Ii. Database snapshots

Database snapshots are read-only and static views of databases (source databases. Multiple snapshots can be located in one source database and can always reside on the same server instance as a database. When a snapshot is created, each database snapshot is consistent with the source database snapshot in the transaction. Snapshots exist until they are explicitly deleted by the database owner.

Iii. ssrs

A tool used to publish reports in a database. The Reportserver tempDB database is a temporary buffer database of the reportserver database.

4. Custom database:

Employee, students, mysql

System database vs custom database

System:

Custom

A synonym is equivalent to an object alias and serves as a link to database objects and applications. If an object needs to be replaced, you can directly modify the synonym without modifying the application. At present, it seems that the database with basic knowledge is useless.

Service broker: a tool that simplifies the work of servers and external servers.

What beginners often use is tables, views, programmability, and security.

Different:

1. the system database does not have a 'database Relational Graph '-a multi-Table relational graph.

2. database objects. The system only has system tables and system views. The custom table includes the system and the custom table and view.

3. programmability: an extended stored procedure is added to the system. Extended stored procedures allow you to create your own external routines in programming languages (for example, C.

In SQL server, the database has been read, and in my mind it is not a bunch of long unfamiliar, non-systematic systems, as well as Shenma tables and constraints, role and so on. In this analysis, we can find what we want to use. Although there are systems and non-systems, we know what we use and what we don't need. After such a comparison, we only need to pay more attention to the differences, which saves the trouble of repeating memories.

Database Operations

This figure is a simple example.

We can use both the Enterprise Manager and SQL statement to achieve what we want. Enterprise Management is relatively an operation performed within the database. During our queries, we use SQL statements, whether designing databases or interacting with applications.

Do you still have so many questions after reading the interface?

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.