From different perspectives, we can divide the SQL server data platform into multiple components. The SQL Server Data Platform is divided into the following according to the common division principles of SQL Server internal team:
- SSAs: SQL Server Analysis Service. It is mainly used for analysis, such as cube. You can view data from different perspectives.
- SSIS: SQL server integration service. For example, the interoperability between Excel data and database data.
- SSRs: SQL Server Reporting Service. Mainly used for Bi and report.
- Engine: SQL Server engine. The database engine is very important, just like the human heart.
- MPU: the periphery of the SQL Server database, such as install, uninstall, upgrade, and repair.
These five components constitute the entire SQL server data platform. Since SQL Server engine is particularly important, we can divide it into the following components:
- AM: access method. The underlying layer is used to store data.
- TS: Transaction Service. Transactions are the basis of all transaction databases.
- FS: filestream. New Functions of SQL Server 2008 are mainly used to store data larger than 2 GB to NTFS Driver.
- Qe: query execution. It is mainly responsible for executing SQL statements.
- QP: Query Process. It is mainly used to process the user's issue SQL statements, such as T-SQL statement optimization, execution plan.
- Sqlos: SQL operation system. To control the database more flexibly, a separate OS layer is developed for SQL Server 2008.
- Programmability: it is mainly used to connect with programming platforms such as Vs and SQL programming, such as assembly, cursor, stored procedure, trigger, etc.
- XML: used to operate XML data.
- Replication: used for data replication. replication is a useful function of the database.
- Fulltext: used for full-text indexing.
- SSB: SQL Server Service Broker: an underlying component that is very useful for maintaining communication consistency.
Among the 11 components of the above engine, am, ts, and FS constitute the SQL server storage engine. As for the functions of each component, I will describe in detail in the future blog.ArticleIt is a rough idea.
There are several books for your reference:
- Inner SQL Server 2000
- Inside-MsSql2K5-SE (inside Microsoft SQL Server 2005 storage engine)
- Inside-MsSql2K5-P (inside Microsoft SQL Server 2005 programming)
- Inside-MsSql2K5-TSql (inside Microsoft SQL Server 2005 T-SQL querying)
- Inside-MsSql2K5-QTO (inside Microsoft SQL Server 2005 query tuning and optimization)
By now, it seems that the books and periodicals of the inside 2008 series have not yet been available.