Query language

From Wikipedia, the free encyclopedia

Query languages are computer languages used to make queries into databases and information systems.

Broadly, query languages can be classified according to whether they are database query languages or information retrieval query languages. Examples include:

.QL is a proprietary object-oriented query language for querying relational databases;
Common Query Language (CQL) a formal language for representing queries to information retrieval systems such as as web indexes or bibliographic catalogues.
CODASYL;
D is a query language for truly relational database management systems (TRDBMS);
DMX is a query language for Data Mining models;
Datalog is a query language for deductive databases;
ERROL is a query language over the Entity-relationship model (ERM), especially tailored for relational databases;
FQL Facebook query language: SQL-like;
Gellish English is a language that can be used for queries in Gellish English Databases [1], for dialogues (requests and responses) as well as for information modeling and knowledge modeling;
ISBL is a query language for PRTV, one of the earliest relational database management systems;
MQL is a cheminformatics query language for a substructure search allowing beside nominal properties also numerical properties;
MDX is a query language for OLAP databases;
OQL is Object Query Language;
OPath, intended for use in querying WinFS Stores;
Poliqarp Query Language is a special query language designed to analyze annotated text. Used in the Poliqarp search engine;
QUEL is a relational database access language, similar in most ways to SQL;
SMARTS is the cheminformatics standard for a substructure search;
SPARQL is a query language for RDF graphs;
SQL is a well known query language for relational databases;
SuprTool is a proprietary query language for SuprTool, a database access program used for accessing data in Image/SQL (TurboIMAGE) and Oracle databases;
XQuery is a query language for XML data sources;

v • d • e Database management systems
Database models · Database normalization · Database storage · Distributed DBMS · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Transaction processing
Concepts	Database · ACID · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key
Objects	Trigger · View · Table · Cursor · Log · Transaction · Index · Stored procedure · Partition
SQL	Select · Insert · Update · Merge · Delete · Join · Union · Create · Drop · Begin work · Commit · Rollback · Truncate · Alter
Implementations	Relational · Flat file · Deductive · Dimensional · Hierarchical · Network · Document-oriented · Object-oriented · Object-relational · Temporal · XML data stores
Components	Concurrency control · Query language · Query optimizer · Query plan · ODBC · JDBC
Database products: Object-oriented (comparison) · Relational (comparison) · Document-oriented