|
|
|
|
+ Search |
 
|
Mar 19th, 2005 09:01
Knud van Eeden,
---------------------------------------------------------------------- --- Knud van Eeden --- 25 December 2003 - 06:56 pm ------------------- Database: Language: SQL: History: Inventor: Who invented the SQL language? --- SQL (=Structured Query Language) is the standard language to communicate with a relational database. --- The basis for SQL can be traced down to Dr. Edgar Frank Codd (called "Ted") (1924-2003), a mathematician from Oxford (UK), and the inventor of relational databases, while working as an IBM researcher in the IBM San Jose Research Laboratory (USA). In June 1970 he published an article called 'A relational model of data for large shared data banks', which appeared in the ACM (=Association for Computing Machinery) magazine, Vol. 13, No. 6, pp. 377-387 Dr. Edgar Codd wanted to create here a system where you could query the tables using English like commands. This article laid the foundations of the theory of relational databases. This article can also seen as the triggering starting point for the further development initiatives of the SQL language. --- Honeywell brought the first commercial SQL based product on the market in June 1976. --- That prototype of SQL, originally developed by IBM at the San Jose Research Laboratory (where it was known as 'Sequel') has further involved by committee. The standards of the SQL language are controlled by the American National Standards Institute (=ANSI) committee on Database Languages, called X3H2. http://web.ansi.org This standards organizations ANSI and ISO published an SQL standard in 1986. The first official SQL standard, called SQL-89, is the most widely, completely implemented SQL in popular database servers. Further standards SQL-92 (or SQL-2) and SQL-99 (or SQL-3) have only been sporadically implemented. The official standards document for SQL is called ANSI X3.135-1992 (R1998) --- Larry Ellison, founder of the 'Relational Software' company (nowadays called 'Oracle Corporation')) brought in 1979 the first standard SQL product (called 'Oracle' after a CIA database project) on the market. --- Also the request from NASA for querying a database containing information about rocks brought back from the moon by the American government has played a further role in accelerating the further development of SQL. [Internet: see also: http://www.google.com search for '"moon rock" database SQL history': http://www- curator.jsc.nasa.gov/curator/lunar/lnews/lnaug96/computer.htm] --- --- Book: see also: --- [book: author: Groff, James R. / Weinberg, Paul N. - title: SQL (the complete reference) - publisher: McGraw-Hill - year: 1999 - ISBN: 0-07- 211845-8 - p. 25 'A brief history of SQL'] --- [book: author: Lane, David / Williams, Hugh E. - title: Web Database Applications with PHP & MySQL - publisher: O'Reilly - ISBN: 0-596- 00041-3 - pages total: 582 - 'Database Management Systems'] --- [book: author: Medinets, David - title: PHP programming, developing browser based applications - publisher: McGraw-Hill - year: 2000 - ISBN: 0-07-135342-9 - pages total: 551 - p. 120 'An introduction to SQL'] --- --- Internet: see also: --- A Brief History of Databases http://wwwdb.web.cern.ch/wwwdb/aboutdbs/history/industry.html --- Database: Language: SQL: Overview: Can you give an overview of links about SQL? http://www.faqts.com/knowledge_base/view.phtml/aid/32811/fid/54 ----------------------------------------------------------------------