Sunday, September 21, 2008

Microsoft SQL Server

Microsoft SQL Server is a relational database management system (RDBMS) shaped by Microsoft. Its main query language is Transact-SQL, an completion of the ANSI/ISO standard Structured Query Language (SQL) new by both Microsoft and Sybase.

Architecture

The design of Microsoft SQL Server is broadly divided into three mechanism: SQLOS which implements the basic services necessary by SQL Server, counting thread scheduling, memory administration and I/O management; the Relational Engine, which implements the relational database mechanism including support for databases, tables, queries and stored events as well as implement the type system; and the Protocol Layer which expose the SQL Server functionality.

No comments: