structured query language: a computer programming language used for database management
language, database, standard
/S Q L/ An industry-standard language for creating, updating and, querying relational database management systems.
SQL was developed by IBM in the 1970s for use in System R. It is the de facto standard as well as being an ISO and ANSI standard. It is often embedded in general purpose programming languages.
The first SQL standard, in 1986, provided basic language constructs for defining and manipulating tables of data; a revision in 1989 added language extensions for referential integrity and generalised integrity constraints. Another revision in 1992 provided facilities for schema manipulation and data administration, as well as substantial enhancements for data definition and data manipulation.
Development is currently underway to enhance SQL into a computationally complete language for the definition and management of persistent, complex objects. This includes: generalisation and specialisation hierarchies, multiple inheritance, user defined data types, triggers and assertions, support for knowledge based systems, recursive query expressions, and additional data administration tools. It also includes the specification of abstract data types (ADTs), object identifiers, methods, inheritance, polymorphism, encapsulation, and all of the other facilities normally associated with object data management.
The emerging SQL3 standard is expected to be complete in 1998.
According to Allen G. Taylor, SQL does __not__ stand for “Structured Query Language”. That, like “SEQUEL” (and its pronunciation /see’kw*l/), was just another unofficial name for a precursor of SQL. However, the IBM SQL Reference manual for DB2 and Craig Mullins’s “DB2 Developer’s Guide” say SQL __does__ stand for “Structured Query Language”.
SQL Standards (http://jcc.com/sql_stnd.html).
An SQL parser (ftp://ftp.ora.com/published/oreilly/nutshell/lexyacc/) is described in “Lex & Yacc”, by Levine, Mason & Brown published by O’Reilly.
The 1995 SQL Reunion: People, Projects, and Politics (http://mcjones.org/System_R/SQL_Reunion_95/).
[“A Guide to the SQL Standard”, C.J. Date, A-W 1987].
[“SQL for Dummies”, Allen G. Taylor, IDG Books Worldwide].
structured query language
database, standard, language A draft standard for another extension of SQL. The latest SQL3 Working Draft addresses the requirement for objects and “object identifiers” in SQL and also specifies supporting features such as encapsulation, subtypes, inheritance, and polymorphism. In the USA, SQL3 is being processed as both an ANSI Domestic (“D”) project and as an […]
- Sql access group
body The origanisaton which defined Call-Level Interface, on which ODBC is based. It is now part of X/Open. [Address, details?] (1995-11-05)
- Sql module language
A language used to interface other languages (Ada, C, COBOL) to SQL-based DBMSes. It is an ANSI standard. Version: Ada/SAME by Informix. (1994-11-23)
- Sql server
database (Note capitalised) 1. Sybase Adaptive Server Enterprise. 2. Microsoft SQL Server. (2003-07-02) database (Note not capitalised) Any database management system (DBMS) that can respond to queries from clients formatted in the SQL language. Two popular examples are Microsoft SQL Server and Sybase SQL Server. (1997-12-07)