SQL Assignment | The Evolution of SQL
Added on 2020-05-16
9 Pages3530 Words106 Views
Data Science and Big DataDatabases
|
|
|
Running head: THE EVOLUTION OF SQLThe Evolution of SQLName of the Student:Name of the University:Author note:
1THE EVOLUTION OF SQLTable of Contents1. Introduction............................................................................................................................22. The development of SQL Language......................................................................................22.1 Implementing SQL...........................................................................................................32.2 Features and Constructs that characterize SQL...............................................................32.3 Programming style and examples....................................................................................43. The evolution of SQL.............................................................................................................53.1 Contributions of SQL in the field of Database Management Systems............................53.2 Success of SQL and RDBMS..........................................................................................63.3 Failure tasted by SQL in the recent past..........................................................................63.3 Influencing the next generation languages.......................................................................64. Analysis of SQL.....................................................................................................................64.1 Strength and weaknesses..................................................................................................64.2 Design trade-offs..............................................................................................................75. Conclusion..............................................................................................................................7
2THE EVOLUTION OF SQL1. IntroductionTo maintain any business, there shall be data and hence there shall be a need toorganize data in a proper fashion. The requirement for an organized method to maintain datawas solved by the development of the Database Management System. However, today withthe advent of technologies and the internet, the volume and variety of data has also increased.It is a known fact that the pre-relational database systems did not have their own set oflanguage to work with data handling. They had to depend upon the assistance of otherlanguages like C and COBOL in order to manipulate and retrieve data from the database.However, handling the database model was still an attempt of massacre back then. Therefore,the Relational Database model was introduced. The Relational Database Management Systemwas designed with the aim to store data in the form tables and relational. This boosted theability to store or retrieve data from the database. SQL was later introduced as the primelanguage for RDBMS designing. SQL or Structured Query Language is a major databasecomputer language. It was one of the first commercial languages, which was designed fordatabase handling. The SQL language serves the purpose of management and retrieval of datain relational databases. This report aims to talk about the evolution of the SQL language with keen detailsabout how the language was developed, what milestones it had achieved and the changes ithas faced of the past decades.2. The development of SQL LanguageInitially developed at the IBM centres by Raymond F. Boyce and Donald D.Chamberlin in the early 1970s, SQL was called as SEQUEL or Structure English QueryLanguage. Its initial purpose was to manipulate and retrieve data that was stored in System R,the quasi-relational database management system of the company. However, the acronym‘SEQUEL’ had to be changed to ‘SQL’ as a UK-based aircraft company already had thetrademark rights over the name. Later that decade, Relational Software Inc. now commonlyknown as Oracle Corporation, recognized the importance and potential in the concepts of thelanguage and they developed their own system, driven by SQL. This system was namedOracle Version 2. It was a commercially available product, initially designed for the VAXcomputers. After having tested SQL in the various customer test sites, IBM determined itspracticality and usefulness. Doing so, they started working on their new chain of projects.This time, they were far more determined to grasp the commercial market through theirsoftware launches. They developed prototypes of the System R model. These included theSQL/DS, DB2 and System/38, which were available commercially in the late 1970s and early1980s. Currently, various relational database systems or RDBMSs like Oracle Database, IBMDB2, MySQL, Microsoft’s SQL Server and Microsoft Access use SQL as their primary orbackground programming paradigm.Karsai et al. (2014), says SQL is a domain specific non-procedural language. It can beused to store, update and retrieve data from a relational database model. The relationaldatabase consists of one or many tables that hold data. SQL helps to access these tables andcreate relationships between the tables within the database, thus creating a strong database,which is easy to work with. The working of the language shall be discussed in details in theupcoming sections of the report. However, as mentioned earlier, the language was designedwith the primary motive of database handling, which remains the same application until date.However, with the advent of technology the language has gone through severalmodifications. These are to be elaborately explained in a later context.
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
SQL Database in Decision Makinglg...
|17
|987
|178
SQL (Database app)lg...
|14
|580
|66
Relational Database Management Systemlg...
|5
|778
|370
History and Evolution of the Productslg...
|26
|7671
|20
Database Concepts with SQLlg...
|20
|3585
|242
SQL vs NoSQL: Choosing the Right Database for Big Data Managementlg...
|10
|2698
|1