data retrieval

obtaining data from a database management system, often using a query with a set of criteria

Uses your system voice; voice and rate in settings.

≈ 2 min read

Cite, export and learn8 citation formats · 8 exports · lesson and quiz

Names in other languages

  • Françaisextraction de données
  • slpridobivanje podatkov
  • larecuperatio datorum
  • Bahasa Melayudapatan semula data
  • Englishdata retrieval
  • nbdatauthenting
  • עבריתאחזור נתוניםאיחזור נתונים
  • Русскийпоиск данных
  • Svenskadatahämtning
  • 日本語データ検索データ回復, データ復旧, データ修正, データ補償
  • 中文数据检索

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

Data retrieval means obtaining data from a database management system (DBMS), like for example an object-oriented database (ODBMS). In this case, it is considered that data is represented in a structured way, and there is no ambiguity in data.

In order to retrieve the desired data the user presents a set of criteria by a query. Then the database management system selects the demanded data from the database. The retrieved data may be stored in a file, printed, or viewed on the screen.

A query language, like for example Structured Query Language (SQL), is used to prepare the queries. SQL is an American National Standards Institute (ANSI) standardized query language developed specifically to write database queries. Each database management system may have its own language, but most are relational.[clarification needed]

How the data is presented

edit edit source

Reports and queries are the two primary forms of the retrieved data from a database. There are some overlaps between them, but queries generally select a relatively small portion of the database, while reports show larger amounts of data. Queries also present the data in a standard format and usually display it on the monitor; whereas reports allow formatting of the output however you like and is normally printed.

Reports are designed using a report generator built into the database management system.

See also

edit edit source

References

edit edit source
edit edit source

Text derived from https://en.wikipedia.org/w/index.php?oldid=1193198621 under CC BY-SA 4.0; modifications have been made.

Words in each sectionHow the data is present…How the data is presentedHow the data is presented: 85 words85See alsoSee alsoSee also: 20 words20
Words in each section. Measured from the stored article body; sections below the minimum are not plotted.

Provenance

snapshot data-retrieval-500944-9d6276b85890eb47 · hash 9d6276b85890eb4771af7f61c57cf149ac690bb0b1f78bc51cbc41da066c56c2 · captured 2024-01-02 · ledger · version history

Cite this page as: encyclopegia.org, “data retrieval”, snapshot data-retrieval-500944-9d6276b85890eb47. https://encyclopegia.org/a/data-retrieval

Sources cited in this revision

No external citation was extracted for this revision. That is a statement about the source, not a claim that none exists.