SQL or structured query language will be 37 next year. Based on this, we can conclude that it is much older than many other areas of IT technology, such as personal computers or existing operating systems. How did it all start?
Linn In 1970, the IBM researchers at the San Jose Research Center set up a test database management system called System R. The system was based on one of the key documents in the area of databases published that year:
Edgar F. Cude: “A Data Model for Large Shared Data Banks”.
All operations on the system “System R” are based on the English query language, or SEQUEL. The use of the word ‘SEQUEL’ has already been protected and banned by the British company Hawker Sidley, so the database name language has been reduced to SQL (modified query language), and is still maintained. Although the communication database management system is based on coding, it should be noted that the same author did not “create” the SQL language, but the loan was given to two IBM experts (Donald de Chamberlain and Raymond F. Boyce).
The first SQL-based trading systems appeared on the market about a decade later. In 1979. In that year, IBM introduced SQL / DS to System 38, after extensive testing of the concept of system “system R”. Four years later (1983) it became the first known version of the DB2 database, which is still on the market today.
When IBM completed commercial SQL / DS that same year, another well-known software manufacturer (Oracle Corporation – then Communication Software Inc.) introduced a marketing system for communication databases (Oracle version 2). Of course, Oracle will release IBM in a few weeks with their commercial version, so today the contact databases can be proud of their title as the first commercial manufacturer. Over the next few years, more competitors appeared in the competition, and Microsoft also began to compete, with the most advanced version of SQL Server being much smaller.
It was necessary to introduce the same language rating, as many communication database manufacturers later added extensions to the basics of SQL language. First In 1986 by ANC (American National Standards Institute), and a year later by ISO (International Rating Organization). Since SQL has been constantly evolving over the years, today we can talk about a number of developed and accepted standards: SQL-86, SQL-89, SQL-92, and so on.