How does a data warehouse differ 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.

In the context of computer science, a database is a collection of data organized to facilitate rapid search, retrieval, modification, and deletion through a database management system. Databases are typically designed to handle specific, ongoing operational tasks, such as managing airline reservations or medical records, by allowing multiple users to manipulate information quickly.1

A data warehouse differs from a standard database in that it represents a larger, consolidated collection formed by electronically combining formerly separate databases. While a database focuses on the immediate storage and retrieval of operational data, a data warehouse serves as a centralized repository that enables organizations to perform data mining. By aggregating data from various sources, a data warehouse allows users to analyze complex patterns and relationships across an entire organization that might not be visible when looking at independent, smaller databases.1