Choose Index below for a list of all words and phrases defined in this glossary.


Query-By-Example / Query by Example (QBE)

index | Index

Query-By-Example / Query By Example (QBE) - definitions

Query-By-Example (QBE) - 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.

Source: Northwest Database Services, 13 November 2009 10:14:54, http://www.nwdatabase.com/database-glossary-q.htm External


These advertisers support this free service


Query by Example (QBE) - Query by Example (QBE) is a method of query creation that allows the user to search for documents based on an example in the form of a selected text string or in the form of a document name or a list of documents. Because the QBE system formulates the actual query, QBE is easier to learn than formal query languages, such as the standard Structured Query Language (SQL), while still enabling powerful searches.

To conduct a search for similar documents based on matching text, the user enters or copies selected text into the form search field. This is then passed to the QBE parser for processing. A query is created using the relevant words (common words such as "and," "is" and "the" are ignored by default) and a search is carried out for documents containing them. Because the meaning of the selected text is less precise than a formal query, results may be more variable than those in a formal query entry.

To conduct a search for similar documents based on full document text, the user submits documents or lists of documents to the QBE results template. The QBE parser performs an analysis of these and formulates a query to submit to the search engine, which in turn conducts a search for similar material.

In terms of database management system, QBE can be thought of as a "fill-in-the blanks" method of query creation. The Microsoft Access Query Design Grid is an example. To conduct a search for field data matching particular conditions, the user enters criteria into the form, creating search conditions for as many fields as desired. A query is automatically generated to search the database for matching data.

Related glossary terms: stored procedure, The Open Group, Dynamic Structured Query Language (SQL), autonomous transaction, ColdFusion Markup Language (CFML), Java Database Connectivity (JDBC), Open Database Connectivity (ODBC), foreign key

[Category=Data Management ]

Source: WhatIs.com, 02 September 2013 09:46:25, http://whatis.techtarget.com/glossary/Data-and-Data-Management External

 

 

 

 

 


Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: dqglossary@grcdi.nl