Query language

Information about Query language

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:

See also

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


 •  • [ e]
Types of Computer languages
Programming Specification Query Markup Transformation Template processing Hardware description Stylesheet Data modeling
The term computer language includes a wide variety of languages used to communicate with computers. It is broader than the more commonly-used term programming language. Programming languages are a subset of computer languages.
..... Click the link for more information.
In general, a query is a form of questioning, in a line of inquiry. A query may also refer to:
  • The Queries - a set of 31 questions outlined by Isaac Newton beginning in 1704, which stimulated the development of chemistry in the 18th century.

..... Click the link for more information.
database is a structured collection of records or data that is stored in a computer system so that a computer program or person using a query language can consult it to answer queries. The records retrieved in answer to queries are information that can be used to make decisions.
..... Click the link for more information.
An Information System (IS) is the system of persons, data records and activities that process the data and information in a given organization, including manual processes or automated processes.
..... Click the link for more information.
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:
  • .

..... Click the link for more information.
An information retrieval query language is a query language used to make queries into database, where the semantics of the query are defined not by a precise rendering of a formal syntax, but by an interpretation of the most suitable results of the query.
..... Click the link for more information.
.QL

Paradigm: multi-paradigm,logic-paradigm,object-oriented-paradigm
Appeared in: 2007
Developer: Semmle
Typing discipline: static, strong
Major implementations: SemmleCode

.
..... Click the link for more information.
A relational database is a database that conforms to the relational model, and refers to a database's data and schema (the database's structure of how that data is arranged).
..... Click the link for more information.
Common Query Language or contextual query language (CQL) is a formal language for representing queries to information retrieval systems such as search engines, bibliographic catalogs and museum collection information. Based on the semantics of Z39.
..... Click the link for more information.
Information retrieval (IR) is the science of searching for information in documents, searching for documents themselves, searching for metadata which describe documents, or searching within databases, whether relational stand-alone databases or hypertextually-networked databases
..... Click the link for more information.
CODASYL (often spelt Codasyl) is an acronym for "Conference on Data Systems Languages". This was an IT industry consortium formed in 1959 to guide the development of a standard programming language that could be used on many computers.
..... Click the link for more information.
D is a set of requirements proposed by Christopher J. Date and Hugh Darwen in their book The Third Manifesto for what they believe a relational database query language ought to be like; D is not a language itself.
..... Click the link for more information.
A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Relational databases are the most common kind of database in use today (assuming one does not count a file system as a database).
..... Click the link for more information.
Data Mining Extensions (DMX) is a query language for Data Mining Models, much like SQL is a query language for relational databases and MDX is a query language for OLAP databases. DMX syntax is more similar to SQL than MDX.
..... Click the link for more information.
Data mining can be defined as "the nontrivial extraction of implicit, previously unknown, and potentially useful information from data".[1] Data mining may also be defined as "the science of extracting useful information from large data sets or databases".
..... Click the link for more information.
Datalog is a query and rule language for deductive databases that syntactically is a subset of Prolog. Its origins date back to the beginning of logic programming, but it became prominent as a separate area around 1978 when Hervé Gallaire and Jack Minker organized a workshop on
..... Click the link for more information.
A deductive database system is a database system which can make deductions (ie: conclude additional facts) based on and facts stored in the (deductive) database. Datalog is the language typically used to specify facts, rules and queries in deductive databases.
..... Click the link for more information.
Errol may refer to:
  • Errol, a male first name
  • ERROL - Entity Relationship Role Oriented Language. A database language over the Entity-relationship model (ERM).
  • Errol Flynn, a famous actor in the 1930s, 1940s and 1950s

..... Click the link for more information.
The introduction to this article provides insufficient context for those unfamiliar with the subject matter.
Please help [ improve the introduction] to meet Wikipedia's layout standards.

..... Click the link for more information.
A relational database is a database that conforms to the relational model, and refers to a database's data and schema (the database's structure of how that data is arranged).
..... Click the link for more information.
Facebook, Inc.

Private
Founded Cambridge, Massachusetts
(February 4 2004)
Headquarters Palo Alto, California

Key people Mark Zuckerberg, Founder and CEO
Dustin Moskovitz, Co-founder and VP of Engineering
Owen Van Natta, COO
..... Click the link for more information.
SQL
Paradigm: multi-paradigm
Appeared in: 1974
Designed by: Donald D. Chamberlin and Raymond F. Boyce
Developer: IBM
Latest release: SQL:2003/ 2003
Typing discipline: static, strong
Major implementations: Many
SQL
..... Click the link for more information.
Gellish English is a variant of Gellish and is a structured subset of natural English. Its definition includes an English dictionary of concepts that is arranged in a taxonomy and that is extended into an ontology.
..... Click the link for more information.

Explicitation of knowledge and standard specifications

Knowledge modeling is a process of creating a computer interpretable model of knowledge or standard specifications about a kind of process and/or about a kind of facility or product.
..... Click the link for more information.
ISBL (Information Systems Base Language) is the relational algebra notation that was invented for PRTV, one of the earliest database management systems to implement E.F. Codd's relational model of data.

External Links

  • Sample ISBL usage

..... Click the link for more information.
The Molecular Query Language (MQL) was designed for allowing more complex and problem specific search methods. The query language is based on an extended Backus–Naur form (EBNF) using JavaCC.
..... Click the link for more information.
Cheminformatics (also known as chemoinformatics and chemical informatics) is the use of computer and informational techniques, applied to a range of problems in the field of chemistry.
..... Click the link for more information.
In complexity theory, Subgraph-Isomorphism is a decision problem that is known to be NP-complete. The formal description of the decision problem is as follows.

Subgraph-Isomorphism(G1, G2)
Input: Two graphs G1 and G2.
..... Click the link for more information.
Multidimensional Expressions (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas.
..... Click the link for more information.
Online Analytical Processing, or OLAP (IPA: /ˈoʊlæp/), is an approach to quickly provide answers to analytical queries that are multidimensional in nature.
..... Click the link for more information.

This article is copied from an article on Wikipedia.org - the free encyclopedia created and edited by online user community. The text was not checked or edited by anyone on our staff. Although the vast majority of the wikipedia encyclopedia articles provide accurate and timely information please do not assume the accuracy of any particular article. This article is distributed under the terms of GNU Free Documentation License.