Data retrieval

From Wikipedia, the free encyclopedia
Jump to: navigation, search
This topic is distinct from Information 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.

How the data are presented[edit]

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[edit]

References[edit]

  • 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[edit]