structured query language (SQL)

structured query language (SQL)

A relational data language that provides a consistent, English keyword-oriented set of facilities for query, data definition, data manipulation and data control. It is a programmed interface to relational database management systems (RDBMSs). IBM introduced SQL as the main external interface to its experimental RDBMS, System R, which it developed in the 1970s. SQL statements include:

• Data manipulation language statements: SELECT, INSERT, UPDATE and DELETE

• Data definition language statements, including the CREATE and DROP statements for tables and indexes

• Statements that control data consistency, and grant and revoke authority

SQL statements are called “dynamic” when they are not completely specified until the program is executed. They are called “static” when they are completely specified when the program is compiled. SQL is precise, because it is based on predicate logic, but is difficult for average users to deal with, and its most fruitful position is as a protocol for software-to-software connectivity, rather than for human-to-software access.

0 0

Improve it

Add an image

Part of Speech: noun
Synonym(s):
Blossary: Information Technology
Industry/Domain: Technology
Category: Information technology
Company: Gartner
Product:
Acronym-Abbreviation:

Collect to Blossary

Other Languages:

Terms in the News

Billy Morgan

Sports; Snowboarding

The British snowboarder Billy Morgan has landed the sport’s first ever 1800 quadruple cork. The rider, who represented Great Britain in the 2014 Winter Olympics in Sochi, was in Livigno, Italy, when he achieved the man-oeuvre. It involves flipping four times, while body also spins with five complete rotations on a sideways or downward-facing axis. The trick ...

Marzieh Afkham

Broadcasting & receiving; News

Marzieh Afkham, who is the country’s first foreign ministry spokeswoman, will head a mission in east Asia, the state news agency reported. It is not clear to which country she will be posted as her appointment has yet to be announced officially. Afkham will only be the second female ambassador Iran has had. Under the last shah’s rule, Mehrangiz Dolatshahi, a ...

Weekly Packet

Language; Online services; Slang; Internet

Weekly Packet or "Paquete Semanal" as it is known in Cuba is a term used by Cubans to describe the information that is gathered from the internet outside of Cuba and saved onto hard drives to be transported into Cuba itself. Weekly Packets are then sold to Cuban's without internet access, allowing them to obtain information just days - and sometimes hours - after it ...

Asian Infrastructure Investment Bank (AIIB)

Banking; Investment banking

The Asian Infrastructure Investment Bank (AIIB) is an international financial institution established to address the need in Asia for infrastructure development. According to the Asian Development Bank, Asia needs $800 billion each year for roads, ports, power plants or other infrastructure projects before 2020. Originally proposed by China in 2013, a signing ...

Spartan

Online services; Internet

Spartan is the codename given to the new Microsoft Windows 10 browser that will replace Microsoft Windows Internet Explorer. The new browser will be built from the ground up and disregard any code from the IE platform. It has a new rendering engine that is built to be compatible with how the web is written today. The name Spartan is named after the ...