Data warehouse

A DW (data warehouse) is a repository of structured information, available for queries and analysis. Data and information are extracted from mixed sources as they are generated, making it easier and more efficient to run queries over data that originally came from different sources.

A data warehouse is similar to a data lake and some large organizations may use both. A data warehouse to store structured SQL (Structured Query Language) data and a data lake to store all other data.

Cloud providers like AWS (Amazon Web Services), Cloudera, Google Cloud, and Microsoft all have data warehouse solutions.

Artificial intelligence terms, BI, Big data, Business terms, Computer acronyms, Data, Data lake