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

Related Posts

News

ITIL PREDICTIVE ANALYTICS REPORT

  This ITIL report evaluates technologies and applications in terms of their business impact, adoption rate and maturity level to help users decide where and when to invest. The Predictive Analytics Scores below – ordered Read more…

News

Cybersecurity PREDICTIVE ANALYTICS REPORT

Read online and subscribe to Predictive Analytics Email Updates HERE You can have a say in which analytics you need in which timeframe: simply add your (anonymous) need to the list at https://theartofservice.com/predictive-analytics-topics-reports-urgency and we Read more…

News

Storage Technologies PREDICTIVE ANALYTICS REPORT

  This Storage Technologies report evaluates technologies and applications in terms of their business impact, adoption rate and maturity level to help users decide where and when to invest. This predictive analytics evaluates 36 storage-related Read more…