Data retrieval

Data retrieval

Data retrieval, in database management, involves extracting the wanted data from a database. The two primary forms of the retrieved data are reports and queries.

In order to retrieve the desired data the user present a set of criteria by a query. Then the Database Management System (DBMS), software for managing databases, 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, such as 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 DBMS may have its own language, but most relational DBMSs also support SQL.

Contents

How the data are presented

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 DBMS.

See also

References

  • Capron, H. L.; J. A. Johnson (2004). Computers: Tools for an Information Age (8 ed.). Pearson/Prentice Hall. ISBN 0-13-122723-8. 
  • Padron-McCarthy, Thomas; Tore Risch (2005). Databasteknik. Studentlitteratur. ISBN 91-44-04449-6. 

External links


Wikimedia Foundation. 2010.

Игры ⚽ Поможем решить контрольную работу

Look at other dictionaries:

  • data retrieval — recall of data, choosing of records according to criteria …   English contemporary dictionary

  • data retrieval — /deɪtə rəˈtrivəl/ (say daytuh ruh treevuhl) noun the finding of required information from all the data stored in a database …  

  • Data warehouse — Overview In computing, a data warehouse (DW) is a database used for reporting and analysis. The data stored in the warehouse is uploaded from the operational systems. The data may pass through an operational data store for additional operations… …   Wikipedia

  • Data architecture — in enterprise architecture is the design of data for use in defining the target state and the subsequent planning needed to achieve the target state. It is usually one of several architecture domains that form the pillars of an enterprise… …   Wikipedia

  • data — da‧ta [ˈdeɪtə, ˈdɑːtə] noun [plural, uncountable] 1. STATISTICS information or facts about a particular subject that someone has collected: • We cannot tell you the results until we have looked at all the data. ˌprimary ˈdata MARKETING STATISTICS …   Financial and business terms

  • retrieval — retrieve re‧trieve [rɪˈtriːv] verb [transitive] 1. COMPUTING to get back information that has been stored in a computer: • The application stores and retrieves data according to the user s requirements. • To retrieve …   Financial and business terms

  • data — n.pl. (also treated as sing., as in that is all the data we have, although the singular form is strictly datum) 1 known facts or things used as a basis for inference or reckoning. 2 quantities or characters operated on by a computer etc. Phrases… …   Useful english dictionary

  • Data Query Language — Die Data Manipulation Language (DML, englisch für „Datenbearbeitungssprache“) ist derjenige Teil einer Datenbanksprache, der verwendet wird, um Daten zu lesen, zu schreiben, zu ändern und zu löschen. DML ist die Datenver oder… …   Deutsch Wikipedia

  • Data Manipulation Language — Die Data Manipulation Language (DML, englisch für „Datenbearbeitungssprache“) ist derjenige Teil einer Datenbanksprache, der verwendet wird, um Daten zu lesen, zu schreiben, zu ändern und zu löschen. DML ist die Datenver oder… …   Deutsch Wikipedia

  • data — noun (uncountable, plural) 1 information or facts: We cannot tell you the results until we have looked at all the data. 2 information in a form that can be stored and used: data retrieval system …   Longman dictionary of contemporary English

Share the article and excerpts

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