Data retrieval
In today's world, Data retrieval has become a topic of great relevance and interest to a wide audience. Since its emergence, Data retrieval has captured the attention of experts and fans alike, generating passionate debates and conflicting opinions. Its impact has extended to various areas, from politics and society to popular culture and entertainment. In this article, we will explore different aspects related to Data retrieval, analyzing its evolution over time, its implications in the current world and future prospects. Data retrieval continues to be a topic in constant evolution, and its influence never ceases to surprise those who delve into its complexity.
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
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
- Database model
- Data maintenance
- Relational database
- Query by Example, a database query language devised in the mid-1970s
References
 | This section includes a list of references, related reading, or external links, but its sources remain unclear because it lacks inline citations. (February 2011) |
- 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
- SQL Statements SQL Statements Tutorial
- SQL Tutorial at W3Schools