Wikipedia says, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence.
DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data in one single place that are used for creating analytical reports for workers throughout the enterprise.
EDW can be logically divided into the data-marts depending on business areas like HR, Finance, Production etc. It is important to note that a data-mart is just a logical divide and you could still hold the data together physically
Below are major components of the any data warehouse:
1.) Date warehouse tables which include Facts and Dimensions. These are stored in a OLTP database.
2.) OLAP or Cube for reporting
3.) ETL Tools
DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data in one single place that are used for creating analytical reports for workers throughout the enterprise.
EDW can be logically divided into the data-marts depending on business areas like HR, Finance, Production etc. It is important to note that a data-mart is just a logical divide and you could still hold the data together physically
Below are major components of the any data warehouse:
1.) Date warehouse tables which include Facts and Dimensions. These are stored in a OLTP database.
2.) OLAP or Cube for reporting
3.) ETL Tools
We all know that data warehousing as a service is a kind of outsourcing model in which the service provider manages the software as well as hardware resources.
ReplyDelete