Share
Explore BrainMass

SQL Characteristics, History, and Example

SQL Information
--------------------------------------------------------------------------------
I need about page about basic SQL, I am looking for your opinion.

a. Characteristics
b. Why was it created?
c. Is there anything unique about it?
d. History
e. small sample example of code
f. What makes it different than other languages?

Solution Preview

SQL (Structured Query Language) is a database language. It is widely used with a DataBase Management System (DBMS) to query, create and modify databases. Originally it was meant to work with Relational Databases, however now it also supports other databases including Object-Relational Database Management Systems (ORDBMS).

Why created?
It was created to test a database system based on Edgar Codd's paper on Relational databases "A Relational Model of Data for Large Shared Data Banks" [1]. Its creators Donald D. Chamberlin and Raymond F. Boyce were working at IBM on a relational database system called "System R".

Characterisitics and uniqueness:
Every programming language is unique, however SQL is different from other "general" programming languages. The basic SQL does not have the concept of general purpose programming as done in C or Java. Extension to ANSI SQL like PL/SQL provides many improvements that allow general programming with SQL. Some aspects of SQL is closer to any declarative programming language like Prolog, Haskell, Miranda, etc. In any case it ...

Solution Summary

In this solution, you will learn all about SQL. Specifically, you will learn about the following with many references.
a. Characteristics
b. Why was it created?
c. Is there anything unique about it?
d. History
e. small sample example of code
f. What makes it different than other languages?

$2.19