DATABASE & SQL/PLSQL

adplus-dvertising
Introduction (SQL)
Previous Home Next

MS SQL Server

  1. Fully Web Enabled.
  2. You can use HTTP to send queries to the server. It provides various feature and facility to accesses data on web.
  3. Highly Scalable and Reliable.
  4. SQL sever use scale up and scale out feature to fulfill requirement . In Scale up SQl server use 32 bit Processors and 64GB of RAM to increase the load. In scale out SQL distribute database and data load across the server. When suddenly system crash ,RDBMS recover data quickly with minimum loss. This feature called reliability.

Client Server Architecture (Two Tier Architecture)

SQL
  1. Language to access data object from the SQL server.
  2. Stands for Structured Query Language.
  3. SQL addresses data in sets of rows and column rather than addressing individual component or a single data.
  4. SQL support automatic navigation to target the data means user find data without knowing how to get this data and how to store the data.
  5. Using this user never waste the time on representation of data, user only concentrate on logic.
Previous Home Next