![[db-vs-dl-dw.png]] ![[data-terms_01.png]] ### Definitions #database are typically structured with a defined schema. Information organized in rows and columns. Product: - Microsoft SQL Server - Oracle DB - PostgreSQL - MySQL ![[data-base-ex_01.png]] #data-warehouse a data warehouse is a special type of database that is designed to support and enable business intelligent #BI activities, especially #analytics. **Why** can't it just be stored in a database? Let's say a product get's deleted and no longer appears in a database. How would you be able to access the metrics for this without something to query to? **Because** the purpose of a #data-warehouse is archiving metrics. The process of transferring data from a #database to a #data-warehouse is called #ETL or #Extract-Transform-Load. ![[data-warehouse_01.png]] #data-lake is a centralized repository that stores #structured and #unstructured data.