The Microsoft Standard Query Language  (SQL) Server 200 is one of the major branches of the RDBMS family or the Relational Database Management Systems that was created and developed by the world leader in software solutions, the Microsoft.  The fundamental language that Microsoft SQL uses is component known as the Transact SQL.

Generally speaking, the MS SQL Server 2000 architecture is largely divided into three major elements:  the SQLOS, the Relational Engine, and the Protocol Layer all of which are working in one engine to ensure the maximum functionality of the SQL server.  

The SQLOS serves as the fundamental component of the SQL Server framework.  It usually takes control of all functions that are relevant and linked with the Operating System.  Operating systems work on managing the input and output resources, schedules the threading activities, management of the system memory, management of the buffer and repository device, and the efficient management of all the system resources.  The SQLOS works in consonance with how the operating system works on these activities.

The Relational Engine on the other hand works on effectively implementing the data storage of relational dbases by using the mechanisms provided by the SQLOS component. The Relational engine implements the system type in order to define efficiently the varied data types that are compatible to be stored on the database tables.

Lastly, the Protocol Layer is the component that is instructed to implement the perimeter interface going to the SQL Server.  All activities and actions that are being called upon on the SQL server are being channeled to the Protocol Layer thru the use of the format defined by Microsoft known as the Tabular Data Stream function or the TDS.

Categories: News