DBMS Interface – SQL
In this chapter we shall reflect the relational data model (chapter 3) against the contemporary practice of relational database systems. Contemporary practice is primarily centred around a language known as SQL (Structured Query Language). SQL was originally designed as a query language based on the relational calculus (section 3.3.11). The current specification of SQL is however much more than simply a query language. It is more accurately described as being a database sublanguage. Indeed, this database sub-language is becoming the standard interface to relational and non-relational DBMS.
Unable to display preview. Download preview PDF.
- Codd E. F. (1988a) ‘Fatal Flaws in SQL.’ Datamation. Aug 1988. pp. 45–48.Google Scholar
- Codd E. F. (1988b) ‘Fatal Flaws in SQL.'Part 2. Datamation. Sept 1988. pp. 71–74.Google Scholar
- Date C. J. (1987) ‘Where SQL Falls Short.’ Datamation. May 1987. pp. 83–86.Google Scholar
- International Standards Organisation. Database Language SQL. ISO/IEC 9075:1987.Google Scholar
- International Standards Organisation. Database Language SQL with Integrity Enhancement. ISO/IEC 9075:1989.Google Scholar
- International Standards Organisation. Database Language SQL. ISO/IEC 9075:1992.Google Scholar
- Melton J. and Simon A. R. (1993). Understanding the New SQL: a complete guide. Morgan Kaufmann, New York.Google Scholar