query language

query language

      a computer programming language used to retrieve information from a database.

      The uses of databases are manifold. They provide a means of retrieving records or parts of records and performing various calculations before displaying the results. The interface by which such manipulations are specified is called the query language. Whereas early query languages were originally so complex that interacting with electronic databases could be done only by specially trained individuals, modern interfaces are more user-friendly, allowing casual users to access database information.

      The main types of popular query modes are the menu, the “fill-in-the-blank” technique, and the structured query. Particularly suited for novices, the menu requires a person to choose from several alternatives displayed on a monitor. The fill-in-the-blank technique is one in which the user is prompted to enter key words as search statements. The structured query approach is effective with relational databases. It has a formal, powerful syntax that is in fact a programming language, and it is able to accommodate logical operators. One implementation of this approach, the Structured Query Language (SQL), has the form

      select [field Fa, Fb, . . . , Fn]

      from [database Da, Db, . . . , Dn]

      where [field Fa = abc] and [field Fb = def].

      Structured query languages support database searching and other operations by using commands such as “find,” “delete,” “print,” “sum,” and so forth. The sentencelike structure of a SQL query resembles natural language except that its syntax is limited and fixed. Instead of using a SQL statement, it is possible to represent queries in tabular form. The technique, referred to as query-by-example (or QBE), displays an empty tabular form and expects the searcher to enter the search specifications into appropriate columns. The program then constructs a SQL-type query from the table and executes it.

      The most flexible query language is of course natural language. The use of natural-language sentences in a constrained form to search databases is allowed by some commercial database management software. These programs parse the syntax of the query; recognize its action words and their synonyms; identify the names of files, records, and fields; and perform the logical operations required. Experimental systems that accept such natural-language queries in spoken voice have been developed; however, the ability to employ unrestricted natural language to query unstructured information will require further advances in machine understanding of natural language, particularly in techniques of representing the semantic and pragmatic context of ideas.

Vladimir Slamecka
 

* * *


Universalium. 2010.

Игры ⚽ Нужно решить контрольную?

Look at other dictionaries:

  • Query language — Query languages are computer languages used to make queries into databases and information systems. Broadly, query languages can be classified according to whether they are database query languages or information retrieval query languages. The… …   Wikipedia

  • query language — UK US noun [C] ► IT a way of getting particular information that you want from a large amount of information held on a computer database, spreadsheet, etc.: »HR managers need to be able to use a database query language to make graphs and… …   Financial and business terms

  • Query Language —   [engl.], Abfragesprache …   Universal-Lexikon

  • query language —    In a database management system, a programming language that allows a user to extract and display specific information from a database.    Structured Query Language (SQL) is an international database query language that allows the user to… …   Dictionary of networking

  • query language — noun a source language consisting of procedural operators that invoke functions to be executed • Syn: ↑command language, ↑search language • Hypernyms: ↑source language * * * ˈquery language 7 [query language] …   Useful english dictionary

  • query language —    A predefined set of rules and syntax that must be used to properly retrieve information from a database. Structured Query Language (SQL) is an attempt to define a standard query language …   IT glossary of terms, acronyms and abbreviations

  • query language — užklausų kalba statusas T sritis automatika atitikmenys: angl. query language vok. Abfragesprache, f rus. язык запросов, m pranc. langage de demandes, m …   Automatikos terminų žodynas

  • query language — užklausų kalba statusas T sritis informatika apibrėžtis Kalba, turinti specialias priemones duomenų paieškos ↑užklausoms aprašyti. Viena populiariausių užklausų kalbų yra SQL (struktūrinė užklausų kalba), kuri naudojama tvarkant ↑sąryšines… …   Enciklopedinis kompiuterijos žodynas

  • query language — language used for retrieval and storage of data in a database (Computers) …   English contemporary dictionary

  • query language — /ˈkwɪəri læŋgwɪdʒ/ (say kwearree langgwij) noun Computers a database search language …  

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”