SQL


Also found in: Dictionary, Thesaurus, Medical, Legal, Financial, Acronyms, Wikipedia.

SQL

structured query language: a computer programming language used for database management
Collins Discovery Encyclopedia, 1st edition © HarperCollins Publishers 2005

SQL

(computer science)
McGraw-Hill Dictionary of Scientific & Technical Terms, 6E, Copyright © 2003 by The McGraw-Hill Companies, Inc.

SQL

(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.

An SQL parser is described in "Lex & Yacc", by Levine, Mason & Brown published by O'Reilly.

The 1995 SQL Reunion: People, Projects, and Politics.

["A Guide to the SQL Standard", C.J. Date, A-W 1987].

["SQL for Dummies", Allen G. Taylor, IDG Books Worldwide].
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

SQL

(Structured Query Language) Typically pronounced "see-quill" rather than the acronym, SQL is a language used to interrogate and process data in a relational database. Originally developed by IBM for its mainframes, SQL commands can be used to interactively work with a database or can be embedded within a script or programming language to interface to a database. Programming extensions to SQL have turned it into a full-blown database programming language, and all major database management systems (DBMSs) support it.

ANSI standardized SQL, but most DBMSs have some proprietary enhancement, which if used, makes SQL non-standard. Moving an application from one SQL database to another sometimes requires tweaking, the age old problem in this business! See MySQL, SQLite, MDX, CLI, ODBC, IDAPI and SQL injection.

The following SQL query selects customers with credit limits of at least $5,000 and puts them into sequence from highest credit limit to lowest. The blue words are SQL verbs. See SPUFI.

select name, city, state, zipcode
     from customer
     where creditlimit > 4999
     order by creditlimit desc



From Natural Language to SQL
English Wizard generated the SQL code at the bottom from the English sentence at the top. A lot of SQL code is required to ask a simple question. (Screen shot courtesy of EasyAsk Inc.)
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
As Jamie Wallis, Product Marketing Manager, Redgate Software, comments: "We're continually listening to users to ensure that SQL Monitor is both simple to use and delivers the functionality they need to do their jobs in the most efficient way possible.
Network administrators, database managers, and law enforcement officials use DataNumen SQL Recovery as a forensic tool to identify and repair damaged SQL files.
DataNumen SQL Recovery version 2.1 runs under Windows XP/Vista/7/8 as well as Windows Server 2003/2008/2012, and costs $299.95(US) for a single-user license.
SQL Server is a program that an individual or company purchases and can be used on a variety of hardware - which is then hosted by a Service Provider or Hosting Partner.
He noted that CPU-based vulnerabilities can come from SQL issues as well as other application vulnerabilities.
Pallavi Kathuria, Director, Server Business Group, Microsoft India said, "With the introduction, of the HP PolyServe Software, we can now deploy MS SQL Server that can flex capacity to need, reduce capital costs, improve availability and dramatically simplify management.
* SQL Debugger: A visual SQL debugger has been added to the Advantage Data Architect, allowing developers to debug SQL scripts, stored procedures, triggers and user defined functions by using breakpoints, and call stack/variable inspection.
REAL SQL Server Developer Edition is a full-featured version of REAL SQL Server intended for use by application developers.
According to the company, version 4 of SQL Compare and SQL Data Compare for SQL Server 2005, tools used to compare and synchronize database structures, content and data, have been re-engineered, but retained their simple interface.
Initially, the collaboration will focus on the development of Lucidyx Oracle(R) Gateway(TM), a bridge between Oracle(R) and the Lucidyx search engine, allowing Oracle(R) SQL queries to combine data from Oracle(R) with data from Searcher(TM) as if all the data was stored in Oracle(R) tables.
Red Gate Software has released a new product called SQL Log Rescue that enables undo and redo of individual SQL Server database transactions, protecting users from lost data and eliminating expensive downtime.