Britannica
Sources used in this answer
How does a database management system retrieve information from a database?
Created from Britannica articles
using AI.
AI can make mistakes, so verify using Britannica articles.
information system
A woman taking a driver's license test on a computer, an example of a government using an information system to provide services to citizens.
A database management system (DBMS) retrieves information primarily by processing queries submitted by users. These queries act as the interface through which users specify the data they wish to access, search, or manipulate.12
When a query is submitted, the DBMS searches the databaseâwhich is organized into files, records, and fieldsâto find sequences that match the user's criteria. The retrieval process often involves:1
- Query Languages: Users employ a query language to define their search. This can range from simple menu selections and "fill-in-the-blank" forms to powerful, formal syntax like SQL (Structured Query Language).2
- Data Organization: The DBMS leverages the underlying structure of the databaseâwhether flat, hierarchical, network, or relationalâto locate the requested information efficiently. For instance, in relational databases, the system associates tables to yield specific data points.1
- Indexing: To speed up retrieval, many systems use indexes, which allow for direct access to data rather than requiring a sequential search through files.1
By interpreting these commands, the DBMS identifies the relevant records and presents the requested information to the user.12