Query By Example Article Index for
Query
Website Links For
Query
 

Information About

Query By Example




QBE is based on the notion of Domain Relational Calculus .


EXAMPLE

A simple example using the Suppliers And Parts Database is given here, just to give you a feel for how QBE works.

This "query" selects all supplier numbers (S#) where the owner of the supplier company is "J. Doe" and the supplier is located in "Rome".

Other commands like the "P." (print) command are: "U." (update), "I." (insert) and "D." (delete).

The result of this query depends on what the values are for your the Suppliers And Parts Database .


SEE ALSO



REFERENCES

  • M. Zloof. ''Query by Example''. AFIPS, 44, 1975.

  • Raghu Ramakrishnan, Johannes Gehrke. ''Database Management Systems'' 3rd edition. Chapter 6 .

  • 1