Structured Query Language (SQL)

SQL is a programming language for storing and processing information in a relational database. A relational database stores information in tabular form, with rows and columns representing different data attributes and the various relationships between the data values.

SQL meets ideal DB language requirements:

  1. SQL coverage fits into 2 categories
    • Data Definition - Creates the DB and its table structure
    • Data Manipulation - uses a set of cpmmands to SELECT, DELETE & UPDATE data within the DB tables
  2. SQL is relatively easy to learn
  3. ANSI prescribes a standard SQL

Comments

Post a Comment

Popular posts from this blog

The Network Layer

Image
Note on 22 Jul 2002 Properties and Services The network layer normally offers one of the following services to the transport layer Connection-oriented Connectionless Network layers are designed with the following goals in mind To provide services independent of subnet technology To shield the transport layer from the number, type & topology of the subnets present To use a uniform addressing scheme across both LAN & WAN Virtual Circuits Used in connection oriented services Whenever two machines wish to communicate - a route from source to receiver is setup and remembered Advantages easy congestion control quick to parse subsequent packets Disadvantages setup time vulnerable to crashes Datagrams Used in connectionless oriented services Everytime a packet is sent out, a new route maybe chosen Advantages robust no initia
Read more

The Transport Layer

Image
Note on 22 Jul 2002 Services provided Goal of the transport layer is to provide efficient reliable & cost effective service to higher levels (normally applications) Normally provides connection oriented & connectionless services Functions in a similar manner to network layer QoS Another way of looking at transport layer is that it's primary function is to enhance the "Quality of Service" of the network layer What exactly good is, is best left up to the user Connection establishment delay Connection establishment failure probability Throughput Transit delay Residual error ratio Protection Priority Resilience Transport Service primitives Many programs & programmers use transport layer so primitives must be easy to use and understand Primitive PDPU sent Meaning LISTEN none Block until some process tries to connect CONNECT CONNECTION REQ. Ac
Read more