Query by Example
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.