THE WHATIS.COM WORD-OF-THE-DAY January 2, 2003 Query by Example ______________ TODAY'S SPONSOR: SearchSystemsManagement.com's Tips and Newsletters
Do you appreciate time-saving advice? If you're not already signed up for SearchSystemManagement's Tips and Newsletters, you're missing out on our best compilation of IT advice, tips, and trade secrets. Don't miss out - click below to preview newsletters and sign up for free delivery today! http://searchsystemsmanagement.techtarget.com/tips/0,289484,sid20_tax283177,00.html ______________ TODAY'S WORD: Query by Example See our complete definition with hyperlinks at http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci214554,00.html 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 TERMS: query http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci214553,00.html Structured Query Language http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci214230,00.html parser http://searchwebservices.techtarget.com/sDefinition/0,,sid26_gci212749,00.html search engine http://searchwebservices.techtarget.com/sDefinition/0,,sid26_gci212955,00.html database management system http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci213669,00.html ______________________ SELECTED LINKS: SearchDatabase.com offers hundreds of technical resources covering key database languages and technologies. http://searchdatabase.techtarget.com/bestWebLinks/0,,sid13_tax281659,00.html ______________________ 2003 PREDICTIONS | Happy New Year! What areas of IT will your company be focusing on in 2003? What's hot and what's not? Share your IT predictions for 2003! http://whatis.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.1dcfae0e/201!viewtype=threadDate&skip=&expand= ______________________ WHATIS.COM POLL | IT Training How many times last year did your company send you for IT training? >> Cast your vote in our latest member poll http://whatis.techtarget.com/poll/1,289525,sid9,00.html ______________________________ RECENT ADDITIONS AND UPDATES [1] ASAP http://searchsap.techtarget.com/sDefinition/0,,sid21_gci871489,00.html [2] Online Service System http://searchsap.techtarget.com/sDefinition/0,,sid21_gci871202,00.html [3] R/3 Repository http://searchsap.techtarget.com/sDefinition/0,,sid21_gci871109,00.html [4] user exit http://searchsap.techtarget.com/sDefinition/0,,sid21_gci871107,00.html [5] race condition http://searchstorage.techtarget.com/sDefinition/0,,sid5_gci871100,00.html ____________________________________________________________________ ::::::::::::::::::: WHATIS.COM CONTACTS ::::::::::::::::::: LOWELL THING, Site Editor ([EMAIL PROTECTED]) ____________________________________________________________________ MARGARET ROUSE, Associate Editor ([EMAIL PROTECTED]) ___________________________________________________________________ :::::::::::::::::::: ABOUT THIS NEWSLETTER ::::::::::::::::::::: Published by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. Unsubscribe from 'Word of the Day' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://WhatIs.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."