History of Relational Databases
The history began between Relational Databases and SQL. In 1970, Edgar F. Codd wrote the now-famous paper on relational data modeling: "A Relational Model of Data for Large Shared Data Banks." The original relational database language, developed by IBM, was called SEQUEL (Structured English Query Language) to support its prototype RDBMS (Relational Database Management System) called System/R. The name later was changed from SEQUEL to Structured Query Language.
In the beginning Codd started out a mathematician at IBM in 1970 when he came up with the Relational Data Model. He (Codd) said to have complained that SQL did not meet his mathematical model but it was his model that produced what is the RDBMS standard language some 35 years later and for the foreseeable future. After E.F. Codd wrote his paper on Relational Data Modeling, IBM spent a great deal of money, time, and energy developing and researching the implementation of Codd's model. In 1979, a new product called Oracle was released by a company then known as Relational Software. The Oracle database was the first commercially available relational database software that utilized SQL. Once SQL gained commercial appeal, standards discussion began taking place within standards organizations and universities. Also SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987.
The most significant change introduced is the fifth revision of SQL2003 of the SQL database query language. It introduces a few new features such as:
XML – related features (SQL/XML)
Window functions
The sequence generator, which allows standard sequences
Two new column types; auto-generated values and identify-columns
The new MERGE statement
Extensions to the CREATE TABLE statement to allow “CREATE TABLE AS” and “CREATE TABLE LIKE”
Removal of the poorly implemented “BIT” and “BIT VARYING” data types
OLAP capabilities
The
In the beginning Codd started out a mathematician at IBM in 1970 when he came up with the Relational Data Model. He (Codd) said to have complained that SQL did not meet his mathematical model but it was his model that produced what is the RDBMS standard language some 35 years later and for the foreseeable future. After E.F. Codd wrote his paper on Relational Data Modeling, IBM spent a great deal of money, time, and energy developing and researching the implementation of Codd's model. In 1979, a new product called Oracle was released by a company then known as Relational Software. The Oracle database was the first commercially available relational database software that utilized SQL. Once SQL gained commercial appeal, standards discussion began taking place within standards organizations and universities. Also SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987.
The most significant change introduced is the fifth revision of SQL2003 of the SQL database query language. It introduces a few new features such as:
XML – related features (SQL/XML)
Window functions
The sequence generator, which allows standard sequences
Two new column types; auto-generated values and identify-columns
The new MERGE statement
Extensions to the CREATE TABLE statement to allow “CREATE TABLE AS” and “CREATE TABLE LIKE”
Removal of the poorly implemented “BIT” and “BIT VARYING” data types
OLAP capabilities
The