Home

Data Warehouses

Resources

Books

What are data warehouses?

A data warehouse (or enterprise data warehouse) stores large amounts of data that has been collected and integrated from multiple sources. Because organizations depend on this data for analytics or reporting purposes, the data needs to be consistently formatted and easily accessible – two qualities that define data warehousing and makes it essential to today’s businesses.

Why are data warehouses important?

Data is essential to organizations making informed decisions, so it stands to reason that data warehouses are just as important because they store all that data. Data warehouses can:

  1. Store large amounts of data in a central database – and in a standard format.
  2. Integrate data from many different sources and standardize it, so it’s ready for analytics or reporting.
  3. Maintain historical records, since it can store months or even years of data.
  4. Keep data secure by storing it in a single location. Access can be granted only to those who need specific data.
  5. Provide quick, easy access to data to enable faster business decisions.

Repository

https://github.com/okeeffed/developer-notes-nextjs/content/databases/data-warehouses

Sections


Related