Client/Server Architecture in SQL Server

Below is the architecture for Client Server in SQL Server

Client

Application:

  • Here we create the statements in the front end application.
  • It can either a java / vb.net or any other application.
  • Example: select * from emp;

API:

  • API means Application Programming Interface.
  • API acts as an Interface between the application and database.
  • API is collection of libraries.
  • It collects the statement from the application and divides the statement into packets.

Client Net Libraries:

  • It collects the packets from the API and does the following things:

i. Protocol Component.
Adds upper layer to the packets taken from API.
ii. Network Component.
It prints from and to address on the packets and sends it to the Server.

Server:

Server Net Libraries:

It collects the packets sent by the Client Net Libraries and removes the layer build by the protocol component.

ODS:

  • ODS means Open Data Source.
  • It keeps the packets in the order.

Relational Engine:

It mainly checks for 4 things:

i. Parsing:

  • It checks for the syntax in the statement.
  • Suppose if there is any syntax error it raises that error.

ii. Object Existence:

  • Checks whether object exists or not.
  • Suppose if the object doesn’t exist then it raises error.

iii. Permission:

  • Checks for the permissions for the object in the database.
  • Checks whether the Username and password are correct or not.

Execution Plan:

  • It is calculated in terms of I/O cost, CPU and memory utilization.
  • It takes the most appropriate execution plan ie., takes the optimization query and keeps in the memory so that from the next time onwards it executes the statement taking from the memory.

Storage Engine:

It takes the data from memory / OS / Hardware

Leave a comment

1 Comment

  1. Wonderful, what a website it is! This weblog presents
    valuable facts to us, keep it up.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: