Query by Example (QBE) is a database query language for relational databases. It was devised by Moshé M. Zloof at IBM Research during the mid-1970s, in parallel to the development of SQL.[1] It is the first graphical query language, using visual tables where the user would enter commands, example elements and conditions. Many graphical front-ends for databases use the ideas from QBE today. Originally limited only for the purpose of retrieving data, QBE was later extended to allow other operations, such as inserts, deletes and updates, as well as creation of temporary tables.
The motivation behind QBE is that a parser can convert the user's actions into statements expressed in a database manipulation language, such as SQL. Behind the scenes, it is this statement that is actually executed. A suitably comprehensive front-end can minimize the burden on the user to remember the finer details of SQL, and it is easier and more productive for end-users (and even programmers) to select tables and columns by selecting them rather than typing in their names.
In the context of information retrieval, QBE has a somewhat different meaning. The user can submit a document, or several documents, and ask for "similar" documents to be retrieved from a document database [see search by multiple examples[2]]. Similarity search is based comparing document vectors (see Vector Space Model).
QBE represents seminal work in end-user development, frequently cited in research papers as an early example of this topic.
Currently, QBE is supported in several relational database front ends, notably Microsoft Access, which implements "Visual Query by Example", as well as Microsoft SQL Server Enterprise Manager. It is also implemented in several object-oriented databases (e.g. in db4o[3]).
QBE is based on the logical formalism called tableau query, although QBE adds some extensions to that, much like SQL is based on the relational algebra.
^Zloof, M.M. (1977). "Query-by-Example: A data base language". IBM Systems Journal. 16 (4): 324–343. CiteSeerX 10.1.1.86.3485. doi:10.1147/sj.164.0324.
^Zhu, Mingzhu; Wu, Yi-Fang Brook (2014-02-24). "Search by multiple examples". Proceedings of the 7th ACM international conference on Web search and data mining. ACM. pp. 667–672. doi:10.1145/2556195.2556206. ISBN 9781450323512. S2CID 8397529.
^"QBE", db4o, Developer works Java library, IBM, 27 March 2007
QuerybyExample (QBE) is a database query language for relational databases. It was devised by Moshé M. Zloof at IBM Research during the mid-1970s, in...
the query string. Web frameworks may provide methods for parsing multiple parameters in the query string, separated by some delimiter. In the example URL...
systems, query languages rely on strict theory to retrieve information. A well known example is the Structured Query Language (SQL). Broadly, query languages...
Microsoft Query is a visual method of creating database queries using examples based on a text string, the name of a document or a list of documents. The...
Structured Query Language (SQL) (pronounced S-Q-L; historically "sequel") is a domain-specific language used to manage data, especially in a relational...
GraphQL is an open-source data query and manipulation language for APIs and a query runtime engine. GraphQL enables declarative data fetching where a client...
or viewed on the screen. A query language, like for example Structured Query Language (SQL), is used to prepare the queries. SQL is an American National...
media descriptions (for example, elimination of Redundancy) Categorization of media descriptions into classes. In querybyexample, the element used to search...
gives answers to DNS queries from data that have been configured by an original source, for example, the domain administrator or by dynamic DNS methods...
SPARQL query for a SPARQL endpoint, for example ViziQuer. In addition, tools exist to translate SPARQL queries to other query languages, for example to SQL...
GQL (Graph Query Language) is a standard graph query language published 2024-04-12 as ISO/IEC 39075:2024. The GQL project is the culmination of converging...
the most simple case of PbD is the macro recorder. QuerybyExample Automated machine learning Example-based machine translation Inductive programming Lapis...
part of .NET Framework 3.5 in 2007. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used...
part without a query part may also be referred to as a 'clean URL' whose last part may be a 'slug'. An optional query component preceded by a question mark...
Particular examples include vp-tree and BK-tree methods. Using a set of points taken from a 3-dimensional space and put into a BSP tree, and given a query point...
(input query) and comparing it to an existing database. The system then returns a ranked list of music closest to the input query. One example of this...
parallel with the development of SQL, IBM also developed QuerybyExample (QBE), the first graphical query language. IBM's first commercial relational-database...
graph database (GDB) is a database that uses graph structures for semantic queries with nodes, edges, and properties to represent and store data. A key concept...
A web query or web search query is a query that a user enters into a web search engine to satisfy their information needs. Web search queries are distinctive...
techniques, query languages and query optimization methods, RAID, and more. The database research area has several dedicated academic journals (for example, ACM...
Power Query is an ETL tool created by Microsoft for data extraction, loading and transformation, and is used to retrieve data from sources, process it...
WHOIS (pronounced as the phrase "who is") is a query and response protocol that is used for querying databases that store an Internet resource's registered...
theory, a conjunctive query is a restricted form of first-order queries using the logical conjunction operator. Many first-order queries can be written as...
hierarchical query is a type of SQL query that handles hierarchical model data. They are special cases of more general recursive fixpoint queries, which compute...
also known as the Kleene star. glob (programming) Pattern matching QuerybyExample Wildcard DNS record wildmat "Using wildcard characters". Microsoft...