What is the question for example?

Question by example (QBE) is a query language for relational databases similar to structured questions (SQL). Part of the "example" of this language for collecting data allows a person or application to seek to load data from a relational database to complete the information they know about the data they are looking for. The query method could include a form that the user would fill in to generate a SQL query to which database understands.

Suppose there is a database full of employees in the organization and this information was made available for employees if they need to communicate with other employees. The information storage database understands commands such as Select FNAME from employees where name = 'Smith', but many people do not understand this type of syntax. Asking for example can help with it. Following statements:

Select FNAME, LNAME, extension from employees where Name = 'Smith'

Tells database to view the staff information table and display all baptismal JMEN (FNAME), surname, (Name) and phone extension (extension) where the surname field contains the SMITH value. Using a QBE style query, a user seeking this information could provide the information they know, surname = 'Smith', and see information about this surname. This allows employees to give an example of what they are looking for and see the returned results.

Inquiry sent to the database in the above example looks just like the above SQL command, even if the search for the search only told the database that the surname was SMITH and which items he needed to know, first name, surname, extension. Since most of the questions, by example, include a form or application for data entry, the table staff could be firmly encoded with the Into System so that users do not have to worry about it.

Another similar example is searching for recipient used by MICRosoft Outlook Web Access®. When someone clicks on the field header , there is another form that allows this person to complete the items they know about and click on the Find button, all records corresponding to the specified example will be returned and the employee can click the correct information and use them in the e -mail message.