Database Glossary – Q
Useful Terms For Working With Data
Query-By-Example, a tabular language for expressing queries, in which sketching an abbreviated ‘schema’ of the output specifies a query desired, along with any criteria that should be applied to the fields desired.
1) Literally, a question you ask about data in the database in the form of a command written in a query language, defining sort order and selection, that is used to generate an ad hoc list of records.
2) The output subset of data produced in response to a query.
See: Language, Query.
The process of collecting the data needed to answer a query.
Query, Ad hoc
A temporary query for which neither the criteria nor resulting output are saved.
Same as a ground query.
A query in which all of the fields are taken directly from tables; none are taken from
the output of other queries.
A statement that contains one or more sub queries.
A query that is stored for reuse.
A query from which output is then used as input for the same query.
A query contained within another query, usually hierarchically larger in scope.
A query in which the output is possibly infinite. This most often occurs in queries which are recursive or which contain negation. Such queries are disallowed by many database management systems to prevent unsafe queries.