Basic concepts of databases

Database System: database system is a computer systems using database technology, is a database (data) database management system (software) database management personnel (personnel) hardware platform (hardware) and software platform 5 part of the operating entity. (Database Administrator Administrator dba).

　Database Common objects:

1. Table
2. Field
3. Index
4. View
5. Stored Procedures

database composition:SQL Server database mainly consists of files and filegroups. All data and objects in the database (table stored procedure triggers) are stored in the file.

1. File
2. File groups

　　system database:SQL Server has 4 system databases Master,tempdb,model and msdb by default.

1. The master database is the most important database in SQL Server. He records all system-level information for SLQ server instances, including instance-scoped metadata, endpoints, connection servers, and system configuration settings.
2. The tempdb database is a staging database that holds temporary objects and intermediate result sets.
3. The model database is used as a template for all databases created on the instance of SQL Server. Modifications to the model database (if the database size, collation, recovery mode, and other data options) are applied to all databases created later.
4. The msdb database is used for SQL Server Agent scheduled alerts and jobs.

Basic concepts of databases