Query – Explanation of terms and definition

The term query describes the request to a database. Data can be queried from a database by a person or a program. The English term has its origins in the Latin “quaerere”, which means “to ask” or “to seek”. In order for the system to be able to answer a query, the request must be made in a language that the system can understand. There are different query languages to choose from. Depending on the purpose and skills of the user, these differ significantly. The simplest query form, Query by Example, is particularly user-friendly. One or more search terms are simply entered into a query mask. Operation is simple and intuitive. Database queries using the SQL database language or the XML query language XQuery are more demanding.

A database can only be used effectively with the right query language. Which language is suitable for the individual company depends on the activity and the knowledge of the user. Query languages are classified according to their power. If a query language separates the results of a query (query) more sharply than another, then it is more powerful. The data filtered by the more powerful query language contains all the results that the less powerful language also found. But the amount of data is filtered more precisely and the results are more concentrated. A query can be translated into another language. This makes work easier for inexperienced users in particular. A query in the system language can first be translated into a system-related intermediate language and then into the actual query language. In this way, even complicated queries can be implemented by inexperienced employees and the database is available to all departments and employees to its full extent.

You can find more information about queries here.

If you are looking for a cloud solution for your company, you will here find what you are looking for – – Explanation of terms and definition