Query by Example
Query by Example (commonly shortened to QBE) is a database query language for relational databases. It was developed at IBM in the 1970s. The development of SQL…
Query by Example (commonly shortened to QBE) is a database query language for relational databases. It was developed at IBM in the 1970s. The development of SQL ran in parallel. QBE was developed for those users who only use databases occasionally, and who do not want to learn a complex language such as SQL.
With Query by example, users are presented with a visual schema of the database, which they edit with a special editor. When they are done, a parser translates their actions into a query in a regular query language such as SQL. Behind the scenes, it is this statement that is actually executed. With a suitable front-end, the user does not need to remember the details of a query language. The user will be able to select tables and columns more quickly, for example by clicking on them, rather than typing their names. This will improve productivity.
In the context of information retrieval, QBE has a somewhat different meaning. The user can submit a document and ask for "similar" documents to be retrieved from a document database. Similarity search is based comparing document vectors (see Vector Space Model).
Today, many database systems have front-ends that resemble QBE.
References
- "Query by Example" (pdf; 140 kB). www.cs.wisc.edu. Retrieved 2011-10-15.
Content Disclaimer
Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.
- The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
- There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
- It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
- Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
- Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.