Many times, people use the terms database and data warehouse interchangeably. They truly have some intersections but there are some important differences. Let’s use What, Who, When and Where approach to explain.⠀

Databases are typically used to support specific applications, department or functions in a company. They contain highly related data. They are structured to be highly normalized, eliminate redundancy and perform read and write operations in fractions of seconds to very few seconds.⠀

Data Warehouses (DWs) are basically meant for supporting data analytics. They contain data cutting across applications, functions, departments and external sources which may have relationships or not. They have much more data than databases and are less normalized to enhance speed of queries.⠀

Databases are usually used by all types of organisations but DWs are mostly needed by large orgs. who want to perform analytics across databases from various departments, projects and other data sources thereby using it as a single point of truth. e.g. the NDIS or EFCC might use a DW to track customers across banks or a bank can use a DW to track customers that have loans and have done fixed deposits and treasury bills investments in the last financial year with data grouped by months.⠀

Use a database when your data is coming from different sources (web, mobile, USSD, etc.) & with identical data and operations. You will mostly need a DW at times when your data is coming from many more sources e.g. several external applications and the data are sparsely identical.⠀

Databases are typically used at operational levels for day to day transactions while DWs are more needed at management levels for analysis and empirical decision making.⠀

Some level of analytics and reporting is possible with databases too but this is not likely to scale.⠀

These are just the basic differences. If you have further questions, feel free to ask in the comments section or send a direct message.⠀